Mainframe Db2 Database Administrator

System One, Inc.; Salt Lake City (UT); On-site; USD 100,000 - 140,000; Full time

Job summary

System One, Inc. is seeking a z/OS Mainframe Db2 Database Administrator (DBA) to join a large enterprise production environment. You will manage IBM Db2 for z/OS, design and tune databases, and support production systems.

The role requires knowledge of Endevor, COBOL, JCL, REXX, CICS, and VSAM, as well as Db2 utilities (RUNSTATS, REORG, COPY, RECOVER, LOAD, UNLOAD). On-site five days a week with rotating on-call coverage.

Qualifications

• Experience in mainframe database administration, maintenance and production support in a large enterprise environment.
• Experience managing IBM Db2 for z/OS databases, including design, performance monitoring and tuning, backup and recovery, security and production support.
• Experience with Db2 utilities and administration activities, including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
• Ability to work on site five days a week; rotating 24/7 on‑call availability.

Responsibilities

• Provide production support for Db2 for z/OS in a large enterprise.
• Monitor and tune Db2 performance and SQL access paths.
• Manage Db2 utilities: RUNSTATS, REORG, COPY, RECOVER, LOAD, UNLOAD.
• Collaborate with mainframe teams using Endevor, COBOL, JCL, REXX, CICS, and VSAM.
• Participate in on-call rotations for production environment.

Skills

Db2 for z/OS

SQL performance tuning

Mainframe production support

Database design

Runstats & Reorg

Backup & Recovery

Security & production support

Performance issue analysis

Db2 utilities usage

Tools

Endevor

COBOL

JCL

REXX

CICS

VSAM

Job description

z/OS Mainframe Db2 Database Administrator / Mainframe DBA / Db2 DBA

• - Experience in mainframe database administration, maintenance and production support in a large enterprise production environment, including work on modernization or database transformation projects.
• - Experience managing IBM Db2 for z/OS databases, including database design, performance monitoring and tuning, backup and recovery, security and production support.
• - Working knowledge of mainframe technologies, including Endevor, COBOL, JCL, REXX, CICS, and VSAM, and an understanding of how applications interact with Db2 databases.
• - Experience with Db2 utilities and administration activities, including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
• - Experience analyzing and resolving Db2 performance issues, including SQL performance and access path concerns.
• - Experience using mainframe debugging and diagnostic tools.
• - Availability to take part in a rotating 24/7 on‑call support schedule for a production environment.

*** no C2C with 3rd parties - W2 candidates only

*** Must be able to work on site 5 days a week - no remote work

#M1

#LI-DP1.

Ref: #404-IT Pittsburgh