Job Title: DATABASE ADMINISTRATOR (IBM DB2) – DA20261310002
Date Posted: 13/10/2026
Job Code: DA20261310002
Job Duties and Responsibilities:
A Mainframe DB2 DBA is responsible for the design, maintenance, and high availability of Db2 databases on IBM z/OS systems. Responsibilities include performance tuning, executing database utilities such as RUNSTATS and REORG, managing backups, and supporting development teams with SQL optimization.
Core Job Responsibilities:
Database Administration: Maintain Db2 for z/OS environments, including tablespaces, indexes, and database storage allocation.
Performance Tuning: Monitor system health, analyze SQL query access paths, and perform performance optimization using tools such as EXPLAIN and SPUFI.
Backup & Recovery: Develop and maintain disaster recovery strategies, manage database logs, and execute restores.
Utilities Management: Run and schedule routine Db2 utilities such as REORG, RUNSTATS, COPY, LOAD, and UNLOAD.
Security & Compliance: Manage user access controls, maintain system security (RACF), and conduct audit compliance checks.
Collaboration & Support: Provide 24/7 on-call Tier-3 production support and assist application developers with schema changes, DDL/DML deployments, and stored procedure tuning.
Key Skills & Requirements:
- Mainframe architecture, z/OS, JCL, TSO/ISPF, and SDSF.
- IBM and third-party database tools/utilities such as PLATINUM, IBM DB2 Admin, SPUFI, QMF, BMC, and CA Technologies.
- Strong SQL skills (Static and Dynamic) and familiarity with COBOL used in mainframe integrations.
Salary: $101,500/Year