logo

View all jobs

Senior Database Administrator(DB2 + HANA)

Remote, AB

Description of Work:
The “Senior Database Administrator (DB2, HANA)” will support the IBM DB2 database on AIX, Linux and Windows. Experience in an SAP environment is highly recommended, as is a working knowledge of HANA. This is a “hands-on” position requiring solid technical DBA skills.

Required Skills and Experience:
DB2 DBA experience should cover the following items:
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 explaining 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 (e.g. AIX to Linux) using db2-native tools (e.g. db2move/load) and 3rd party tools such as IBM Infosphere and Attunity).

HANA DBA experience should cover the following items:
installation, configuration, security
backup and recovery; replication; high availability and DR setup
monitoring, tuning, and troubleshooting
memory management, compression, defragmentation, partitioning
knowledge of SAP tools such as HANA Cockpit and HANA Studio

Job Requirements
Collaborative, Team Player, Accountable, Agile, Analytical.
Focus on documentation and procedures
Experience in working in a 24x7 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 providing recommendations on database performance (indexing, table management).
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.

Powered by