Plano, TX; Charlotte, NC; Jersey City, NJ; Chandler AZ onsite 3 days per week
Duration:
6+ months Mainframe IMS Application
DBA / IMS DBA
Analyst The IMS Application DBA will manage and support IMS database environments in a high-availability enterprise environment. The role will focus on database design support, performance optimization, data integrity, backup and recovery, and database administration for mission-critical applications running on IBM z/OS.
Mandatory requirements include:
Minimum 7 years of DBA experience supporting IMS databases in a z/OS environment using Sysplexed Data Sharing. Strong knowledge of Full Function, Fast Path, and HALDB databases Experience with secondary indexing, logical relationships, sparsing routines using Assembler, replication, compression, and encryption. Experience with database performance and tuning, monitoring, troubleshooting, physical database design and build, backup, and recovery. Strong IBM z/OS experience Hands-on experience as an IMS Application DBA supporting IMS DB. Experience with IMS utilities and database maintenance activities. Experience troubleshooting database abends, including Uxxx and S0Cxx errors. Experience resolving data corruption and data integrity issues Knowledge of JCL, TSO/ISPF, SDSF, and REXX Experience with batch and online IMS environments, including
IMS DB/DC.
Experience with IMS Database Administration Utilities and BMC utility/monitoring tools or equivalent. Experience with IMS database types, including Full Function DB, Fast Path DB, and HALDB Experience with database definition, allocation, dataset management, REORGs, and space management. Knowledge of
DBD, PSB, ACB
libraries, and IMS Catalog Experience with Load/Unload, Reorganization, Image Copy, and recovery utilities such as DFSURGL0 and
DFSUICP0.
Experience performing Image Copy recovery and point-in-time recovery. Strong database performance and tuning experience. Willingness to work onsite three days per week.
Preferred experience:
Experience integrating IMS with DB2, CICS, MQ, and distributed systems. Experience with OMEGAMON, MainView, or similar performance-monitoring tools. Exposure to IMS modernization, APIs, or z/OS Connect REXX or other scripting/automation experience Experience with large-scale IMS database migrations or consolidation. Experience with data replication or data integration solutions Experience in regulatory or compliance-driven environments, including SOX or PCI Experience with ISPW or ServiceNow Experience with Visio
