IDMS Mainframe DBA

Description We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

Position Summary

This position will support IDMS database platform as both IDMS application DBA and IDMS system DBA on z/OS.

What you'll do

Implement structural changes through environments, access method analysis, application consulting Build automation to improve legacy processes Process Database Support Requests and Change requests in production and non-production environments Build and implement database backup and recovery strategies Prepare disaster recovery (DR) documentation and participate in DR activities Handle data refresh activities from one environment to other lower environments as part of periodic data refresh requests Support day to day monitoring and maintenance activities for IDMS on z/OS Handle IDMS CARS upgrades Respond to Audit requests and provide necessary documentation 24/7 on-call support rotation.

2+ years of knowledge of IDMS Database logical and physical structures such as areas, files, segments, DMCLs, DB Name tables, and the relationships between them 2+ years knowledge of Schema, Subschema, and physical database DDL compilers both in batch and online 2+ years knowledge of physical database file and in-memory data structures related to IDMS databases 2+ years knowledge of the Integrated Data Dictionary (IDD), it's use to manage logical and physical IDMS database objects and the DDDL online and batch compilers Solid understanding of IDMS program development, the compilation process and use of the IDMS runtime environment under both local mode and central version Solid understanding of database access techniques and navigation with an emphasis on locking, concurrency and impacts to large multi-system/multi-threading/multi-tasking environments in a 24x7x365 setting 2+ years knowledge of IDMS tools, utilities and reporting facilities such as but not limited to: page expand, reorg, maintain index, restructure, IDMSDBAN, IDMSLOOK, IDMSRPTS, PRINT SPACE, PRINT PAGE, etc. Solid knowledge of problem identification and mitigation techniques across a variety of scenarios and situations involving IDMS