DB2/IMS System Engineer

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.        

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