Mainframe IMS Database Administrator (IMS DBA)
An IMS Database Administrator (IMS DBA) should possess the following key skills:
Strong experience in IMS Database Administration (IMS v13 and above).
Expertise in IMS database objects: DBD, PSB, ACB, and Format Definitions (FMT).
Administration of IMS Full Function, HALDB, Fast Path, and DEDB databases.
Proficiency in DBRC, database load, restore, recovery, and reorganization (REORG) processes.
Experience with database initialization, forward recovery, checkpoint/restart, secondary index creation, and pointer checking.
Strong knowledge of IMS utilities (IBM and BMC tools).
Familiarity with IMS exit points and custom routines.
Strong working knowledge of OS, TSO/ISPF, and JCL.
Experience with supporting technologies such as VSAM, CICS, and IMS DC.
Working knowledge of RACF security administration related to IMS environments.
Tools Expertise
Hands-on experience with:
File Manager
IMSUTIL
DELTA IMS
IBM/BMC IMS Utilities
Operational & Support Skills
Database monitoring, performance tuning, and capacity management.
Troubleshooting and resolution of IMS database issues.\\r\\nRoot Cause Analysis (RCA) and incident management.
Backup, recovery, disaster recovery, and high-availability support.
Change, release, and production support experience.
Analytical problem-solving and troubleshooting abilities.
Strong communication and collaboration skills.
Ability to work in critical production environments and manage priorities effectively.
Documentation and process improvement mindset.
IMS DBA – Key Responsibilities
IMS Database Administration
Administer and maintain IMS databases (Full Function, HALDB, Fast Path, DEDB).
Create, modify, and manage DBDs, PSBs, ACBs, and Format definitions.
Database Maintenance & Recovery
Perform database initialization, load, reorganization (REORG), backup, restore, and recovery activities.
Manage DBRC, forward recovery, checkpoint/restart processes, and disaster recovery support.
Performance Monitoring & Optimization
Monitor IMS database performance and availability.
Analyze and optimize database structures, access paths, and resource utilization.
Database Utilities Management
Execute and support IMS utilities (IBM and BMC tools).
Build and maintain secondary indexes, pointer checker, and database integrity processes.
Incident Management & Troubleshooting
Diagnose and resolve IMS database failures, performance issues, and application-related database problems.
Perform root cause analysis (RCA) and implement preventive actions.
Security & Compliance
Administer IMS-related security using RACF.
Ensure compliance with organizational security and operational standards.
System Support & Integration
Support IMS environments running on OS.
Work with TSO/ISPF, JCL, VSAM, CICS, IMS DC, and associated mainframe technologies.
Support IMS exit points, routines, and database interfaces.
Change & Release Management
Support change implementation, migrations, and production releases.
Participate in problem, change, and availability management processes.
Tools Administration
Utilize File Manager, IMSUTIL, DELTA IMS, and related tools for database administration and maintenance.
Documentation & Continuous Improvement
Maintain operational procedures, recovery documentation, and database standards.
Identify automation and performance improvement opportunities to enhance database reliability and efficiency.
Technical Skills Strong experience in IMS Database Administration (IMS v13 and above). Expertise in IMS database objects: DBD, PSB, ACB, and Format Definitions (FMT). Administration of IMS Full Function, HALDB, Fast Path, and DEDB databases. Proficiency in DBRC, database load, restore, recovery, and reorganization (REORG) processes. Experience with database initialization, forward recovery, checkpoint/restart, secondary index creation, and pointer checking. Strong knowledge of IMS utilities (IBM and BMC tools). Familiarity with IMS exit points and custom routines.
Mainframe Platform Skills Strong working knowledge of z/OS, TSO/ISPF, and JCL. Experience with supporting technologies such as VSAM, CICS, and IMS DC. Working knowledge of RACF security administration related to IMS environments.
Hands-on experience with: File Manager IMSUTIL DELTA IMS IBM/BMC IMS Utilities
HCLTech is a global technology company, home to more than 226,600 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2025 totaled $14.2 billion. To learn how we can supercharge progress for you, visit hcltech.com.
