Description

  • support, troubleshoot issues, monitor system health, optimize performance .
  • 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.

Responsibilities

  • · Production Support & Monitoring:
  • o Provide 24x7 support for DB2 and IMS database environments, including on-call rotation.
  • o Monitor database performance, availability, and integrity using mainframe tools and utilities.
  • o Respond to incidents, troubleshoot issues, and resolve problems related to DB2/IMS systems.
  • · Database Maintenance & Administration:
  • o Perform database backup and recovery procedures for DB2 and IMS databases.
  • o Conduct regular reorgs, image copies, and utilities execution (RUNSTATS, REORG, CHECK).
  • o Support DB2 and IMS subsystem maintenance, upgrades, and patching.
  • · Performance Tuning & Optimization:
  • o Analyze and tune SQL queries, buffer pools, and access paths in DB2.
  • o Optimize IMS database segments, DBDs, PSBs, and access methods.
  • o Work with developers to design efficient data access strategies .
  • · Change Management & Deployments:
  • o Review and implement database schema changes via Change Control processes.
  • o Participate in software releases, ensuring database readiness and minimal impact on production.
  • · Security & Compliance:
  • o Manage user access, RACF integration, and permissions in DB2/IMS environments.
  • o Ensure compliance with enterprise security standards and data privacy regulations.
  • · Documentation & Collaboration:
  • o Maintain accurate and up-to-date documentation, including runbooks, architecture diagrams, and operational procedures.
  • o Collaborate with application teams, infrastructure, and middleware teams to support business applications
  • Qualification:
  • · Experience working in regulated environments (e.g., insurance, banking, healthcare) with audit and compliance exposure.
  • · IBM Certified Database Administrator – DB2 for z/OS certification
  • · Knowledge of COBOL, CICS, and batch job data flows.
  • · Understanding of DB2 Data Sharing and IMS Sysplex environments.
  • · Education qualification: Any degree from a reputed college
  • · 10+ years overall IT experience

Key Skills
Education

Any Gradute

Back To Jobs