Mainframe Db2 Database Administrator (DBA) - 26-13936

Compu-Vision Consulting Inc.

Chandler (AZ)

Hybrid

USD 120,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Compu-Vision Consulting Inc. seeks an experienced Mainframe Db2 Database Administrator (DBA) to support large-scale Db2 for z/OS environments. Hybrid work arrangement with three onsite days and two remote days weekly.

The role covers administration, performance tuning, backup/recovery, and incident support across development, testing, and production. Strong Db2, JCL, and DR experience are essential for ensuring data integrity and high availability.

Qualifications

  • Strong hands-on experience with IBM Db2 for z/OS.
  • Extensive knowledge of Db2 administration and object management.
  • Experience with Db2 utilities (REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, REBUILD INDEX).
  • Knowledge of backups, recovery, and disaster recovery procedures.
  • Experience with Db2 performance monitoring and tuning.
  • Working knowledge of JCL and IBM z/OS.

Responsibilities

  • Administer and support IBM Db2 for z/OS databases across environments.
  • Create and manage databases, tablespaces, tables, indexes, and storage definitions.
  • Monitor health, performance, space utilization, and availability.
  • Execute Db2 utilities and manage maintenance tasks.
  • Tune SQL, review access paths, and optimize performance.
  • Support backups, recovery, DR activities, and production incidents.

Skills

IBM Db2 for z/OS
SQL development
Performance tuning
Production troubleshooting
JCL

Tools

REORG
RUNSTATS
RECOVER
LOAD
UNLOAD
REBUILD INDEX
TSO/ISPF

Job description

Job Description

Job DescriptionMainframe Db2 Database Administrator (DBA)


Duration: 6–12 Months(NO BENEFITS)


Work Locations: Chandler, Arizona; Plano, Texas; Charlotte, North Carolina; Jersey City, New Jersey


Work Arrangement: Hybrid – 3 days onsite and 2 days remote per week


Job Overview


We are seeking an experienced Mainframe Db2 Database Administrator (DBA) with strong hands‑on expertise in IBM Db2 for z/OS to support large‑scale, business‑critical mainframe environments.


The ideal candidate will have extensive experience in database administration, performance tuning, maintenance, availability, backup and recovery, and production troubleshooting. This role involves close collaboration with application development, systems programming, infrastructure, security, and operations teams to ensure database reliability, performance, and data integrity.


Key Responsibilities Db2 Database Administration



  • Administer and support IBM Db2 for z/OS databases across development, testing, and production environments.


  • Create, maintain, and manage database objects, including databases, tablespaces, tables, indexes, views, and storage definitions.


  • Manage Db2 catalog objects, partitions, and database structures.


  • Monitor database health, capacity, performance, and space utilization.


  • Ensure database availability, integrity, and operational reliability.



Database Maintenance & Utilities



  • Execute and manage Db2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX.


  • Perform database reorganization, statistics collection, data loading, integrity checking, and recovery operations.


  • Develop and maintain JCL for Db2 utilities and database maintenance processes.


  • Troubleshoot utility failures and implement appropriate corrective actions.



Performance Tuning & Optimization



  • Analyze and tune SQL statements and database performance.


  • Review Db2 access paths, indexing strategies, and query execution behavior.


  • Identify and resolve performance bottlenecks, locking issues, and concurrency problems.


  • Recommend improvements to SQL statements, indexes, and database design.


  • Optimize database objects to maintain performance and availability.



Backup, Recovery & Production Support



  • Support database backup, recovery, and disaster recovery activities.


  • Troubleshoot Db2 errors, SQL issues, performance degradation, and production incidents.


  • Participate in incident resolution, root cause analysis, and preventive action implementation.


  • Support database schema changes and application deployments through controlled implementation processes.


  • Assist with Db2 upgrades, maintenance, migrations, and modernization initiatives.



Documentation & Collaboration



  • Collaborate with application developers, systems programmers, infrastructure teams, and production operations.


  • Maintain technical documentation, database standards, operational procedures, and recovery plans.


  • Follow established change management and production deployment processes.


  • Support highly available enterprise mainframe environments.



Required Qualifications



  • Strong hands‑on experience with IBM Db2 for z/OS.


  • Extensive knowledge of Db2 database administration and object management.


  • Strong understanding of tablespaces, tables, indexes, partitions, views, and the Db2 catalog.


  • Experience with SQL development support, query analysis, and performance tuning.


  • Hands‑on experience with Db2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX.


  • Knowledge of database backup, recovery, and disaster recovery procedures.


  • Experience with database performance monitoring, locking, concurrency, and troubleshooting.


  • Knowledge of Db2 storage and space management.


  • Strong experience with JCL.


  • Good working knowledge of IBM z/OS.


  • Experience supporting large‑scale, highly available production mainframe environments.


  • Experience with production incident management, problem resolution, and controlled change implementation.



Preferred Technical Skills



  • IBM Db2 Administration Tool


  • IBM OMEGAMON for Db2


  • Db2 Query Monitor or equivalent performance monitoring tools


  • IBM or third‑party Db2 utility products


  • REXX scripting


  • TSO/ISPF


  • SDSF


  • Db2 data sharing and IBM Parallel Sysplex environments


Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Mainframe DB2 Database Administrator
Mainframe DB2 Database Administrator

Veriipro • Midvale (UT)

On-site
USD 110,000 - 150,000
Senior Mainframe DBA
Senior Mainframe DBA

System One, Inc. • Salt Lake City (UT)

On-site
USD 96,000 - 152,000
Mainframe DB2 DBA
Mainframe DB2 DBA

Alliance of Professionals & Consultants, Inc. • Chandler (AZ)

Hybrid
USD 72,000 - 79,000
Mainframe Administrator
Mainframe Administrator

IPolarity LLC • Whippany (NJ)

Hybrid
USD 110,000 - 155,000
DB2 DBA
DB2 DBA

GuruSchools • Tallahassee (FL)

On-site
USD 124,000 - 179,000
Senior Mainframe Developer
Senior Mainframe Developer

Valiant Technologies LLC • Salt Lake City (UT)

On-site
USD 110,000 - 170,000
Senior Mainframe Developer
Senior Mainframe Developer

Quantum Technologies LLC • Salt Lake City (UT)

On-site
USD 110,000 - 140,000
Db2 DBA ( mainframe z/OS platform )
Db2 DBA ( mainframe z/OS platform )

System One, Inc. • Salt Lake City (UT)

On-site
USD 115,000 - 150,000
Mainframe DB2 Database Administrator - Hybrid
Mainframe DB2 Database Administrator - Hybrid

Global Payments • Atlanta (GA)

On-site
USD 110,000 - 150,000
Mainframe Db2 Database Administrator
Mainframe Db2 Database Administrator

System One, Inc. • Salt Lake City (UT)

On-site
USD 100,000 - 140,000