The DB2 and IMS platforms are critical components of the overall Claims processing within UHC. The job will span across both DB2 and IMS platforms. A zSystems DBA is a support person for the zSystems DB2/IMS applications. The role includes performing tasks focusing on stability and the performance of both the applications and the DB2/IMS system. The DBA consults, supports, and plans with the application teams regarding the execution and deployment of all changes. Application deployments involve off-hour work, including nights and weekends. Regarding proactive analysis of database concerns, the DBA is an application resource. Part of the DBA role is providing on-call support (rotating), incident queue, and batch abend support for DBA jobs.
Requirements
zSystems DB2/IMS DBA minimum skills
· 7 + years of IBM hardware and software. (z/OS, IMS, CICS, z/OS DB2, RACF, BMC Mainview, BMC Change Manager and Catalog Manager, QMF, Spufi) · 7 + years of working with IBM utilities, JCL, access methods, and file structures · 7 + years of programming languages such as REXX, COBOL, and C-list · 7 + years of SQL experience · 5 + years of working with DB2 Database Objects (as a Developer or DBA) · 5 + years of DB2 Application Design and/or DB2 Development · 5 + years of working with DB2 utilities (BMC and/or IBM) · Knowledge of Replication desirable. · Programming languages such as REXX, COBOL, PYTHON, and C-list are desirable · Experience with Db2 V13 is desirable · Basic knowledge of Workload Manager (WLM) usage and maintenance · Knowledge of system monitoring and performance tuning for computer operations, programming staff, and end users · Basic knowledge of access and security administration, as related to and implemented in DB2 · Experience resolving complex problems logically and methodically, and good judgment to involve and communicate with vendors, internal teams and management · Ability to determine architectural and design best practices and guide proper use of new features. Using AI to create and maintain documentation, including schema diagrams, data dictionaries, and table/column descriptions. · Ability to work without supervision · Ability to use AI tools to analyze capacity planning data and provide recommendations and implement solutions. · Ability to use M365 Copilot AI to recap meetings and draft emails · Ability to stay educated in the role of AI for a Db2 DBA.
zSystems DB2/IMS DBA Responsibilities ·
Database administrator for assigned DB2 zSystems applications · Database administrator for assigned IMS applications · Backup support for IMS System support · DB consultant to the application developers · Weekend and nighttime support of application deployments and system changes · Rotating on-call support (team of 6 people) · Incident queue support · Batch abend support for all DBA jobs · Manage the space and performance of the application DBs
