SQL Database Administrator

iSpace, Inc.; Marysville (OH); On-site; USD 120,000 - 150,000; Full time

Job summary

iSpace, Inc. in Marysville, OH seeks an experienced DB2 Database Administrator with IBM DB2 for z/OS expertise to support enterprise mainframe environments.

You will administer and monitor DB2 z/OS databases, perform SQL tuning, monitor subsystems, and collaborate with application teams to drive performance improvements and reliability.

Qualifications

• 5-10 years of hands-on DB2 for z/OS DBA experience.
• Strong SQL performance tuning and execution plan analysis.
• Experience with DB2 architecture, utilities, logging, and recovery.
• Knowledge of Mainframe, z/OS, JCL, datasets, and batch processing.
• Experience with Omegamon, RMF, and SMF.
• Production support experience in large enterprise environments.
• Knowledge of SOX compliance and database security.

Responsibilities

• Administer and monitor DB2 z/OS database environments.
• Perform SQL performance tuning, query optimization, and index optimization.
• Monitor DB2 subsystem performance, including CPU, I/O, buffer pools, and locking.
• Troubleshoot performance issues using Omegamon, EXPLAIN, RMF, and SMF.
• Manage DB2 utilities, maintenance, PTFs, and version upgrades.
• Support critical production systems and ensure high availability and reliability.
• Collaborate with application teams on database enhancements and performance improvements.

Skills

DB2 for z/OS

SQL performance tuning

Mainframe and z/OS

JCL & datasets

Omegamon/RMF/SMF

Production support

SOX compliance & security

Tools

Omegamon

RMF

SMF

Job description

We are looking for an experienced DB2 Database Administrator with strong hands‑on experience in IBM DB2 for z/OS to support enterprise mainframe database environments.

Key Responsibilities:

• Administer and monitor DB2 z/OS database environments.
• Perform SQL performance tuning, query optimization, and index optimization.
• Monitor DB2 subsystem performance, including CPU, I/O, buffer pools, and locking.
• Troubleshoot performance issues using Omegamon, EXPLAIN, RMF, and SMF.
• Manage DB2 utilities, maintenance, PTFs, and version upgrades.
• Support critical production systems and ensure high availability and reliability.
• Collaborate with application teams on database enhancements and performance improvements.

Required Skills:

• 5-10 years of hands‑on DB2 for z/OS DBA experience.
• Strong SQL performance tuning and execution plan analysis.
• Experience with DB2 architecture, utilities, logging, and recovery.
• Knowledge of Mainframe, z/OS, JCL, datasets, and batch processing.
• Experience with Omegamon, RMF, and SMF.
• Production support experience in large enterprise environments.
• Knowledge of SOX compliance and database security.

Important: Hands‑on DB2 for z/OS DBA experience is required. General SQL Server, Oracle, or DB2 LUW experience alone will not be a fit.