Senior Mainframe DB2 DBA (z/OS) – Performance & Security

Veriipro; Midvale (UT); On-site; USD 110,000 - 150,000; Full time

Job summary

Veriipro is seeking an experienced Mainframe DB2 Database Administrator (DB2 DBA) with strong expertise in IBM DB2 on z/OS. The ideal candidate will administer DB2 databases, tune performance, manage utilities, ensure data integrity and security, and support COBOL programs and VSAM data integration.

Responsibilities include maintaining DB2 stability, planning and executing utilities, and collaborating with development and operations teams to optimize database solutions.

Qualifications

• Hands-on experience administering IBM DB2 on mainframe z/OS.
• Expertise in performance tuning and query optimization for DB2 databases.
• Proficiency with TSO, MVS, JCL, SDSF and ISPF; scripting with REXX.

Responsibilities

• Administer and maintain IBM DB2 databases in a mainframe z/OS environment.
• Ensure database integrity, availability, reliability, and optimal performance.
• Perform DB2 performance tuning, Explain analysis, and plan/package management.
• Manage DB2 database objects: tables, indexes, tablespaces, partitions.
• Execute DB2 utilities: LOAD, UNLOAD, IMAGE COPY, RUNSTATS, REORG, RECOVER, CHECK DATA/INDEX, REPAIR, STOSPACE, DSNCOPY.
• Support application development and COBOL/VSAM integration.

Skills

IBM DB2 on z/OS

DB2 performance tuning

TSO MVS JCL SDSF ISPF

REXX scripting

COBOL & VSAM knowledge

Tools

DB2 Master Console

DB2PDBM1

DB2PDIST

DB2I / SPUFI / DCLGEN

Job description

Veriipro is seeking an experienced Mainframe DB2 Database Administrator (DB2 DBA) with strong expertise in IBM DB2 on z/OS. The ideal candidate will administer DB2 databases, tune performance, manage utilities, ensure data integrity and security, and support COBOL programs and VSAM data integration.

Responsibilities include maintaining DB2 stability, planning and executing utilities, and collaborating with development and operations teams to optimize database solutions.