Db2 DBA ( mainframe z/OS platform )

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

Job summary

System One, Inc. is seeking an experienced z/OS Mainframe Db2 Database Administrator to maintain and support Db2 for z/OS in a large enterprise. You will design, monitor performance, implement backup/recovery, and apply security measures in a production environment.

The role requires hands-on experience with Endevor, COBOL, JCL, REXX, CICS and VSAM, plus Db2 utilities such as RUNSTATS, REORG, COPY, RECOVER, LOAD and UNLOAD. On-call rotation and on-site work five days a week are required.

Qualifications

• Experience in mainframe database administration in a large enterprise production environment.
• Experience managing IBM Db2 for z/OS databases including design, monitoring, backup & recovery.
• Familiarity with mainframe tools and application interaction with Db2.

Responsibilities

• Provide 24/7 on-call support for production mainframe Db2 databases.
• Monitor and tune Db2 performance and SQL access paths.
• Manage Db2 utilities such as RUNSTATS, REORG, COPY, RECOVER, LOAD and UNLOAD.
• Maintain security and production support for Db2 environments.

Skills

Mainframe database administration

Db2 for z/OS design & tuning

Production support

Security & recovery strategies

Tools

Endevor

COBOL

JCL

REXX

CICS

VSAM

Db2 utilities (RUNSTATS, REORG, COPY, RECOVER, LOAD, UNLOAD)

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