Database Administrator

Role: DB2/IMS Lead Database Administrator

Location: Onshore/US

Who are we looking for?

DB2 and IMS Database Administrator (DBA)

Technical Skills:

• Proven experience as a

  DB2/IMS

  Databases Administrator or similar role in production support environments.
• 10+ years of hands-on experience supporting

  DB2 for z/OS

  and

  IMS (Information Management System)

  in a production environment.
• Strong knowledge of mainframe tools such as SPUFI, QMF, BMC, CA-DB2/IMS tools, and IBM utilities.
• Deep understanding of DB2 database internals, logs, buffer pools, catalog/directory, and utilities.
• Proficient 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
• Experience with modern mainframe automation tools and schedulers (e.g., Control-M, CA-7).
• Knowledge of COBOL, CICS, and batch job data flows.
• Understanding of DB2 Data Sharing and IMS Sysplex environments.
• Experience with backup and recovery solutions
• Solid knowledge of Linux/Unix systems and scripting (Shell, Python, or similar).
• Proficiency in troubleshooting performance tuning, and capacity planning.
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Strong troubleshooting and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work in a 24/7 support rotation and handle urgent production issues.
• Familiarity with data security is the best practice and backup procedures.