Software Engineer (DB2 for z/OS, IBM DB2, REORG, RUNSTATS, LOAD, UNLOAD, IBM InfoSphere CDC)

Responsibilities

• Provide application-focused DBA support for IBM DB2 on z/OS environments across development, testing, UAT, and production.

• Review and optimize SQL queries developed by application teams, identifying performance bottlenecks and recommending efficient database access strategies.

• Perform SQL performance tuning, including query optimization, access path analysis, index optimization, statistics management, and related database tuning activities.

• Support database design and enhancement activities involving tables, indexes, relationships, stored procedures, and database objects.

• Troubleshoot DB2-related application issues, including SQL errors, performance degradation, data integrity concerns, and database-related production incidents.

• Manage database object changes and coordinate migrations across DEV, TEST, UAT, and PROD environments.

• Perform DB2 database maintenance activities using utilities such as REORG, RUNSTATS, LOAD, UNLOAD, COPY, RECOVER, CHECK DATA, and related utilities.

• Monitor database health, performance, availability, and capacity, and implement appropriate corrective and preventive measures.

• Support production operations, incident management, problem resolution, root cause analysis, and SLA-driven activities for business-critical applications.

• Provide technical guidance to application developers on DB2 best practices, SQL coding standards, query efficiency, and database design considerations.

• Support database refreshes, test-data preparation, validation, and database-related testing activities.

• Participate in backup, recovery, disaster recovery, and business continuity activities.

• Support data replication and migration initiatives involving IBM InfoSphere CDC, DB2 LUW, and DB2 for z/OS.

• Work with mainframe technologies including z/OS, JCL, TSO/ISPF, and SDSF as required for database operations and production support.

• Collaborate with application, infrastructure, development, and operations teams to ensure database stability, performance, availability, and successful application releases.

• Provide on-call and weekend support when required for critical production environments.

Requirements

• 10+ years of relevant DB2 DBA/Application DBA experience, with strong hands-on experience in IBM DB2 for z/OS.

• Strong Experience enterprise DB2 database administration.

• Strong experience in SQL performance tuning, including query optimization, access path analysis, index design, and database performance analysis.

• Hands-on experience with DB2 utilities, including REORG, RUNSTATS, LOAD, UNLOAD, COPY, RECOVER, and CHECK DATA.

• Good understanding of DB2 database design, tables, indexes, relationships, stored procedures, and database objects.

• Experience supporting DEV, TEST, UAT, and PROD database environments and managing database object migrations between environments.

• Strong experience in DB2 production support, incident troubleshooting, problem management, RCA, and SLA-driven operations.

• Experience with backup/recovery, disaster recovery, and business continuity processes.

• Working knowledge of z/OS, JCL, TSO/ISPF, and SDSF.

• Experience with IBM InfoSphere CDC Replication is preferred.

• Experience with DB2 LUW and cross-platform database support or migration is an advantage.

• Familiarity with BMC DB2 utilities and administration tools is advantageous.

• Experience with mainframe storage concepts such as VSAM is preferred.

• Strong communication and interpersonal skills, with the ability to work effectively with application developers and technical teams.