IMS DB2 DBA - Contract Hiring - GO/JC/1696/2025

Job Title: IMS DB2 Database Administrator (DBA)

Location:

Experience:

Job Summary

IMS DB2 DBA

Key Responsibilities

• Install, configure, and maintain IMS DB, IMS DC, and DB2 subsystems in mainframe environments.
• Perform database design, implementation, schema changes, and database object maintenance.
• Handle database performance tuning, query optimization, buffer pool tuning, and system-level performance improvements.
• Perform backup, recovery, and disaster recovery planning for IMS and DB2 databases.
• Conduct IMS database reorganizations, pointer validations, and space management.
• Monitor and troubleshoot IMS & DB2 database issues, logs, jobs, and system resource utilization.
• Work with development teams to support application deployment, data modeling, DDL changes, and SQL reviews.
• Execute PDS load, unload, utilities (REORG, LOAD, COPY, RUNSTATS, RECOVER) and IMS utilities.
• Ensure high availability, data integrity, and compliance with organizational security standards.
• Participate in on-call rotation for production support and incident resolution.
  

Required Skills & Experience

• 5+ years of hands-on experience as an IMS DBA and DB2 DBA in a mainframe environment (z/OS).
• Strong knowledge of IMS Full Function & Fast Path databases (HALDB, HDAM, HIDAM).
• Experience with IMS tools such as:
• IMS Utilities, IMS Explorer, IMS Admin Tools, IBM Tools
• Proficiency in DB2 administration:
• DB2 utilities (LOAD, UNLOAD, REORG, RECOVER, RUNSTATS), SQL optimization
• Solid understanding of JCL, TSO/ISPF, RACF, SMP/E, SDSF.
• Experience with Change Management tools (Endevor, Changeman, BMC tools).
• Strong analytical, troubleshooting, and performance tuning abilities.
  

Skills Required

• DB2
• DBA
• IMS DB