IMS Application DBA

Key Responsibilities

• Install, configure, and maintain IMS database environments (IMS DB)
• Support and manage different IMS database types: Full Function DB, Fast Path DB, HALDB
• Perform database administration activities: Database definition, allocation, and dataset management
• REORGs and space management to maintain performance
• Manage IMS control structures: DBD, PSB, ACB libraries, and IMS Catalog
• Execute and support IMS utilities: Load / Unload, REORG, Image Copy, Recovery utilities (e.g., DFSURGL0, DFSUICP0)
• Maintain database performance and resolve issues: Access path inefficiencies, space constraints, application-related data issues, abends, and data inconsistencies
• Collaborate with: Application development teams (DL/I access, database design), IMS System Programmers (performance and tuning), Operations teams (batch and online processing)
• Manage multiple, moderately complex projects and may direct activities of a team related to special initiatives or operations
• Routine accountability for technical knowledge and capabilities as a team member or as an individual contributor
• Create process flow charts and related procedural documentation
• Perform database recovery of all types (Image Copy recovery, PIT recovery)
• Provide independent application development support
• Experience with Performance and Tunning

Required Skills & Qualifications

• Minimum 7 years of DBA experience supporting IMS databases in a z/OS environment using Sysplexed Data Sharing
• Knowledge of Full Function, Fast Path and HALDB databases using Secondary Indexing, Logical Relationships, Sparsing Routines (Assembler), Replication, Compression, Encryption
• Strong experience with IBM z/OS environment
• Hands-on experience as IMS Application DBA (IMS DB)
• Experience with IMS utilities and DB maintenance activities
• Experience troubleshooting: Database abends (Uxxx, S0Cxx), data corruption or integrity issues
• Familiarity with: JCL, TSO/ISPF, SDSF, REXX, Batch and online IMS environments (IMS DB/DC), IMS Database Administration Utilities, BMC utility and monitoring tools or equivalent

Preferred Qualifications

• Experience integrating IMS with: DB2, CICS, MQ, and distributed systems
• Experience with performance tools (e.g., OMEGAMON, MainView)
• Exposure to IMS modernization (APIs, z/OS Connect)
• Knowledge of scripting/automation (REXX)
• Experience in large-scale IMS database migrations or consolidation
• Exposure to data replication or data integration solutions
• Experience in regulatory/compliance-driven environments (SOX, PCI, etc.)
• Management procedures and/or tools (ISPW, Service Now)
• Experience with VISIO