Job Description
We're Hiring: Mainframe DB2 DBA
\n
📍 Location: Chandler, AZ / Plano, TX / Charlotte, NC / Jersey City, NJ (Hybrid)
\n
💼 Job Type: Contract
\n
We are looking for 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.
\n
\n
Key Responsibilities:
\n
- \n
- Administer and support DB2 databases across development, testing, and production environments.
- Manage DB2 objects, including tablespaces, tables, indexes, views, and databases.
- Perform database maintenance using DB2 utilities such as REORG, RUNSTATS, COPY, RECOVER, LOAD, and REBUILD INDEX.
- Conduct SQL performance tuning, access path analysis, and indexing optimization.
- Monitor database performance, capacity, availability, and space utilization.
- Manage database backup, recovery, and disaster recovery activities.
- Troubleshoot database issues, locking, contention, and production incidents.
- Develop and maintain JCL for DB2 utilities and maintenance processes.
- Support DB2 upgrades, migrations, application deployments, and production implementations.
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
Required Skills:
\n
- \n
- Strong hands-on experience with IBM DB2 for z/OS.
- Expertise in DB2 Database Administration and SQL Performance Tuning.
- Strong knowledge of DB2 utilities, backup/recovery, and database maintenance.
- Experience with JCL and working knowledge of z/OS.
- Knowledge of tablespaces, indexes, partitions, DB2 catalog, and locking concepts.
- Experience supporting large-scale production mainframe environments.
- Strong troubleshooting and production incident management skills.
\n
\n
\n
\n
\n
\n
\n
\n
\n
Preferred Skills:
\n
- \n
- IBM DB2 Administration Tool and OMEGAMON for DB2.
- DB2 Query Monitor or similar performance monitoring tools.
- REXX, TSO/ISPF, and SDSF.
- DB2 Data Sharing / Parallel Sysplex environments.
\n
\n
\n
\n
\n