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.