SME - Mainframe Automation Tools

Job Summary Mainframe IMS Database Administrator (IMS DBA) An IMS Database Administrator (IMS DBA) should possess the following key skills: 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 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. Soft Skills 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. Key Responsibilities 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.

Skill Requirements 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.