Senior Mainframe DB2 DBA (z/OS) – Hybrid 12‑Month Contract

Alliance of Professionals & Consultants, Inc.; Chandler (AZ); Hybrid; USD 72,000 - 79,000; Full time

Job summary

Alliance of Professionals & Consultants, Inc. seeks a seasoned Mainframe Db2 DBA to manage IBM Db2 for z/OS in large-scale production environments.

You will administer databases, tune performance, and collaborate across development, operations, and security teams in a hybrid work model. This 12-month contract requires hands-on DB2 for z/OS expertise, strong SQL skills, and experience with Db2 utilities, backups, and disaster recovery.

Qualifications

• Hands-on experience with IBM Db2 for z/OS in large mainframe environments.
• Experience administering Db2 objects including databases, tablespaces, tables and indexes.
• Proficient in Db2 utilities (REORG, RUNSTATS, RECOVER, LOAD, COPY).
• Skilled in SQL performance tuning and access path review.
• Experience with backup, recovery, and disaster recovery.
• Familiarity with JCL and batch job execution for Db2 maintenance.
• Ability to work across development, operations, and security teams.

Responsibilities

• Administer Db2 for z/OS across development, test, and production environments.
• Maintain Db2 objects: databases, tablespaces, tables, indexes, and views as needed.
• Perform database maintenance using Db2 utilities (REORG, RUNSTATS, COPY, RECOVER, LOAD).
• Analyze and tune SQL; review access paths and indexing strategies.
• Monitor database health, capacity, and space utilization; manage growth.
• Support backup, recovery, and disaster recovery activities for Db2 databases.
• Troubleshoot Db2 issues, SQL problems, performance degradation, and production incidents.
• Assist with database schema changes and controlled deployment processes.
• Document procedures and maintain operational standards.

Skills

IBM Db2 for z/OS

Db2 administration

SQL performance

JCL

z/OS knowledge

Production support

Backup/Recovery

Job description

Alliance of Professionals & Consultants, Inc. seeks a seasoned Mainframe Db2 DBA to manage IBM Db2 for z/OS in large-scale production environments.

You will administer databases, tune performance, and collaborate across development, operations, and security teams in a hybrid work model. This 12-month contract requires hands-on DB2 for z/OS expertise, strong SQL skills, and experience with Db2 utilities, backups, and disaster recovery.