Mainframe DB2 DBA

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

Job Title: Mainframe DB2 DBA

Type of Engagement: 12-month contract (Not open to 3rd party C2C consultants. Visa sponsorship is not available)

Work Location:

Hybrid position in Chandler, AZ, Plano, TX, or Charlotte, NC, Jersey City, NJ (3 days office)

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 successful candidate will be responsible for the administration, performance, availability, integrity, maintenance, and recovery of Db2 databases. The role requires close collaboration with application development, systems programming, operations, security, and infrastructure teams.

Essential Job Responsibilities:

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


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


• Perform database maintenance using Db2 utilities such as REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX.


• IBM documents these utilities as core mechanisms for maintaining, reorganizing, loading, checking, copying, and recovering Db2 for z/OS data.


• Perform SQL and database performance analysis and tuning, including review of access paths and indexing strategies.


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


• Support backup, recovery, and disaster recovery activities for Db2 databases.


• Troubleshoot Db2 database problems, SQL issues, performance degradation, locking/contention, failed utilities, and production incidents.


• Support database schema changes and application implementations through controlled development, testing, and production deployment processes.


• Analyze and optimize Db2 objects to maintain database performance and availability.


• Work with application developers to review SQL and recommend improvements to SQL statements, indexes, and database design.


• Support Db2 version upgrades, maintenance, migrations, and modernization initiatives as required.


• Develop and maintain JCL required to execute Db2 utilities and database maintenance processes.


• IBM notes that Db2 online utilities can run as standard batch jobs, while stand-stand utilities run as batch jobs using JCL.


• Participate in production incident resolution, root cause analysis, and implementation of preventive actions.


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

Required Skills & Experience:

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


• Strong knowledge of: Db2 database administration


• Tablespaces, tables, indexes, partitions, views, and Db2 catalog


• SQL and SQL performance tuning


• Db2 utilities


• Backup and recovery


• Database reorganization and statistics


• Database performance monitoring and troubleshooting


• Db2 locking and concurrency concepts


• Db2 storage and space management


• Strong experience with JCL


• Good working knowledge of z/OS


• Experience supporting large, highly available production mainframe environments.


• Experience with production incident and problem management.


• Understanding of change management and controlled production implementation processes.

Big Bonus Points if you Have:

• IBM Db2 Administration Tool


• IBM OMEGAMON for Db2


• Db2 Query Monitor or equivalent performance monitoring tools


• IBM or third-party Db2 utility products


• REXX


• TSO/ISPF


• SDSF


• Db2 data sharing / Parallel Sysplex environments

Job Requisition # 40507 #LI-Hybrid #LI-WC1

A reasonable estimate of the pay range for this role is $52.00 - $57.00 per hour. The disclosed pay range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. The compensation decisions are dependent on the facts and circumstances of each case, such as skills and experience levels.

Meet APC

APC is a professional staffing and services organization focused on engaging people and positively impacting lives. As \"Professionals serving Professionals\" we take pride in providing our employees and contractors with the highest level of customer service and support. APC is committed to creating a diverse work environment and is proud to be an Equal Opportunity Employer. All qualified candidates will receive consideration without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, genetics, or veteran status.