Sign upLog in
Database Administrator Jobs in Arizona

IMS Application DBA

Expert In Recruitment Solutions

  • Chandler, AZ
  • 9 days ago

    Highlights

    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. Experience with database definition, allocation, dataset management, REORGs, and space management.

    Numbers & Facts

    LocationChandler, AZ

    Description

    IMS Application DBA
    • 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

    Similar Jobs