Senior DB2 z/OS DBA & Performance Engineer

EXASOFT CONSULTING PTE. LTD.; Singapore; On-site; SGD 140,000 - 200,000; Full time

Job summary

EXASOFT CONSULTING PTE. LTD. is seeking a senior DB2 DBA to provide application-focused DBA support for IBM DB2 on z/OS across development, testing, UAT and production environments.

You will review SQL queries, tune performance, assist with database design, migrations, and production incident management while ensuring DB2 health and availability. Strong z/OS, JCL, and DBA expertise are required.

Qualifications

• 10+ years of relevant DB2 DBA experience on IBM DB2 for z/OS.
• Strong experience in enterprise DB2 administration.
• Experience with SQL performance tuning, including query optimization and index design.
• Hands-on with DB2 utilities: REORG, RUNSTATS, LOAD, UNLOAD, COPY, RECOVER, CHECK DATA.
• Knowledge of DB2 database design, tables, indexes, relationships, stored procedures, and database objects.
• Experience supporting DEV, TEST, UAT and PROD environments and migrations.
• Strong production support, incident troubleshooting, RCA, and SLA-driven operations.
• Experience with backup/recovery, DR and BC processes.
• Familiarity with z/OS, JCL, TSO/ISPF, and SDSF.
• Experience with IBM InfoSphere CDC Replication preferred.
• DB2 LUW cross-platform support or migrations advantageous.
• Familiarity with DB2 utilities and administration tools.

Responsibilities

• Provide application-focused DBA support for IBM DB2 on z/OS across development, testing, UAT, and production.
• Review and optimize SQL queries, identify bottlenecks, and recommend efficient access strategies.
• Perform DB2 performance tuning including query optimization and index design.
• Support design and enhancement of tables, indexes, relationships, and stored procedures.
• Troubleshoot DB2-related issues including SQL errors and production incidents.
• Coordinate migrations and object changes across DEV, TEST, UAT, PROD environments.
• Perform DB2 maintenance using utilities: REORG, RUNSTATS, LOAD, UNLOAD, COPY, RECOVER, CHECK DATA.
• Monitor DB health, performance, availability, capacity; implement corrective measures.
• Support production operations, incident management, root cause analysis, and SLA-driven activities.
• Provide guidance on DB2 best practices, SQL coding standards, and database design considerations.
• Assist with DB2-related testing, refreshes, and data validation.
• Participate in backup, recovery, DR and business continuity activities.
• Support data replication and migration initiatives (InfoSphere CDC, DB2 LUW, z/OS).
• Work with mainframe tech (z/OS, JCL, TSO/ISPF, SDSF) as required.

Skills

DB2 DBA

SQL performance tuning

Mainframe experience

Incident troubleshooting

Production support

Tools

DB2 Utilities (REORG, RUNSTATS, LOAD, UNLOAD, COPY, RECOVER, CHECK DATA)

InfoSphere CDC

z/OS JCL/TSO/ISPF/SDSF

Job description

EXASOFT CONSULTING PTE. LTD. is seeking a senior DB2 DBA to provide application-focused DBA support for IBM DB2 on z/OS across development, testing, UAT and production environments.

You will review SQL queries, tune performance, assist with database design, migrations, and production incident management while ensuring DB2 health and availability. Strong z/OS, JCL, and DBA expertise are required.