SME - Mainframe Automation Tools

Job Summary Mainframe IMS Database Administrator (IMS DBA) An IMS Database Administrator ( DBA) should possess the following key skills: Technical Skills Strong experience in Database Administration ( v13 and above). Expertise in database objects: DBD, PSB, ACB, and Format Definitions (FMT). Administration of 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 utilities (IBM and BMC tools). Familiarity with exit points and custom routines. Platform Skills Strong working knowledge of OS, TSO/ISPF, and . Experience with supporting technologies such as , , and DC. Working knowledge of RACF security administration related to environments. Tools Expertise Hands-on experience with: File Manager IMSUTIL DELTA IBM/BMC Utilities Operational & Support Skills Database monitoring, performance tuning, and capacity management. Troubleshooting and resolution of 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. DBA – Key Responsibilities Database Administration Administer and maintain 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 database performance and availability. Analyze and optimize database structures, access paths, and resource utilization. Database Utilities Management Execute and support utilities (IBM and BMC tools). Build and maintain secondary indexes, pointer checker, and database integrity processes. Incident Management & Troubleshooting Diagnose and resolve database failures, performance issues, and application-related database problems. Perform root cause analysis (RCA) and implement preventive actions. Security & Compliance Administer -related security using RACF. Ensure compliance with organizational security and operational standards. System Support & Integration Support environments running on OS. Work with TSO/ISPF, , , , DC, and associated technologies. Support 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 , 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 Database Administration ( v13 and above). Expertise in database objects: DBD, PSB, ACB, and Format Definitions (FMT). Administration of 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 utilities (IBM and BMC tools). Familiarity with exit points and custom routines.