2021-45 – SAP Database Administrators

  • Location: Calgary, AB
  • Type: Full-time
  • Job #177233
Category:
Information Technology
Type:
Full-time
Location:
Calgary, AB
Job ID:
#177233

Our client, a market leading financial institution, has an immediate need for two (2) SAP Database Administrators. This is a contract position for one (1) year located in Calgary, Alberta.

Description

Database Administrator to do project work in the SAP environment. The Senior Database Administrator will support the IBM DB2 database on AIX, Linux and Windows. This is a “hands-on” position requiring solid technical DBA skills that encompass various components of DB2 Database Administration in order to support our critical database systems and ensure the availability and consistent performance of our corporate applications.

 Accountabilities

  • Collaborative, Team Player, Accountable, Agile, Analytical.
  • Focus on documentation and procedures
  • Perform traditional DBA-level tasks (installation, maintenance/patching, upgrades and migrations, backup and recovery, monitoring and performance tuning, replication, High Availability, Disaster Recovery)
  • Manage a multi-platform database environment (DB2 on AIX and Windows; SAP HANA, Sybase/ASE, Sybase/IQ) on Linux.

 Required

  • Experience in working in a 24×7 environments and providing on-call support
  • DB2 Database Certification
  • Experience performing traditional DBA-level tasks (installation, maintenance/patching, upgrades and migrations, backup and recovery, monitoring and performance tuning, replication, High Availability, Disaster Recovery)
  • Experience providing application-level DBA tasks such as SQL optimization and tuning, reviewing access plans and explain output, provided recommendations on appropriate indexing and database performance.
  • Experience in shell programming (bash, ksh, csh) and/or script (python, perl)
  • Experience on Cloud platforms such as GCP, AWS, Azure
  • Experience on SAP environment and toolset (DBACockpit, SAP Solution Manager)
  • Experience managing a multi-platform database environment (DB2 on AIX and Windows; SAP HANA, Sybase/ASE, Sybase/IQ) on Linux.

Additional Skills “Nice to Have”

  • Physical DBA knowledge (installation, maintenance/patching, upgrades and migrations, backup and recovery, monitoring and performance tuning, replication, High Availability, Disaster Recovery).
  • Logical DBA knowledge (SQL optimization and tuning, reviewing access plans and explain output, provide recommendations on appropriate indexing and database performance).
  • Development DBA knowledge (ability to write tools and scripts using shell / python / perl, *nix command line tools ie sed/awk, Stored Procedures).
  • Migration DBA knowledge (ability to migrate DDL and data across heterogeneous environments (eg AIX to Linux) using db2-native tools (eg db2move/load) and 3rd party tools such as IBM Infosphere and Attunity).

If you’re a technical professional, you know that it can be difficult to find fulfilling work that advances your career. At the Ian Martin Group, we exist to connect professionals like you with meaningful work at industry-leading companies in your field. And we walk the walk, too: as a Certified B Corporation, we believe in using business as a force for good for people, our communities, and the environment.

We value diversity and inclusion and encourage all qualified people to apply. If we can make this easier through accommodation in the recruitment process, please contact us at recruit@ianmartin.com

We encourage all qualified candidates to apply; however, only those selected for an interview will be contacted.

 

EWEMI