Description

You will maintain the stability, availability, and performance of DB2 and IMS databases on IBM mainframe (z/OS) environments.

Responsibilities

• Provide 24/7 support for DB2 and IMS database environments, including on-call rotation.
• Monitor database performance, availability, and integrity using mainframe tools.
• Respond to incidents, troubleshoot issues, and resolve problems related to DB2/IMS systems.
• Perform database backup and recovery procedures for DB2 and IMS databases.
• Analyze and tune SQL queries, buffer pools, and access paths in DB2.

Required Skills

• 6+ years of hands-on experience supporting DB2 for z/OS and IMS in a production environment.
• Proven experience as a DB2/IMS Databases Administrator in production support.
• Strong knowledge of mainframe tools: SPUFI, QMF, BMC, CA-DB2/IMS tools, and IBM utilities.
• Deep understanding of DB2 database internals, logs, buffer pools, and catalog/directory.
• Proficiency in IMS Full-Function and Fast Path databases, DL/I calls, PSB/DBD maintenance.
• Solid experience with JCL, TSO/ISPF, SDSF, and mainframe batch job troubleshooting.
• Knowledge of COBOL, CICS, and batch job data flows.
• Experience with backup and recovery solutions and data security practices.
• Proficiency in troubleshooting performance tuning and capacity planning.

Key Skills

Education

Not specified