Mainframe DB2 DBA

We're Hiring: Mainframe DB2 DBA

📍 Location: Chandler, AZ / Plano, TX / Charlotte, NC / Jersey City, NJ (Hybrid)

💼 Job Type: Contract

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.

Key Responsibilities:

\n
• Administer and support DB2 databases across development, testing, and production environments.
\n
• Manage DB2 objects, including tablespaces, tables, indexes, views, and databases.
\n
• Perform database maintenance using DB2 utilities such as REORG, RUNSTATS, COPY, RECOVER, LOAD, and REBUILD INDEX.
\n
• Conduct SQL performance tuning, access path analysis, and indexing optimization.
\n
• Monitor database performance, capacity, availability, and space utilization.
\n
• Manage database backup, recovery, and disaster recovery activities.
\n
• Troubleshoot database issues, locking, contention, and production incidents.
\n
• Develop and maintain JCL for DB2 utilities and maintenance processes.
\n
• Support DB2 upgrades, migrations, application deployments, and production implementations.
\n

Required Skills:

\n
• Strong hands-on experience with IBM DB2 for z/OS.
\n
• Expertise in DB2 Database Administration and SQL Performance Tuning.
\n
• Strong knowledge of DB2 utilities, backup/recovery, and database maintenance.
\n
• Experience with JCL and working knowledge of z/OS.
\n
• Knowledge of tablespaces, indexes, partitions, DB2 catalog, and locking concepts.
\n
• Experience supporting large-scale production mainframe environments.
\n
• Strong troubleshooting and production incident management skills.
\n

Preferred Skills:

\n
• IBM DB2 Administration Tool and OMEGAMON for DB2.
\n
• DB2 Query Monitor or similar performance monitoring tools.
\n
• REXX, TSO/ISPF, and SDSF.
\n
• DB2 Data Sharing / Parallel Sysplex environments.
\n