Mainframe System Dba

Section

Details

Job Title

Mainframe System DBA

Job Type

Full Time

Client Location

Cleveland, OH

Work Arrangement

Onsite

Duration

Full Time

Pay Rate / Salary

$100-$110k/yr.

Job Summary

• We are seeking an experienced Mainframe System Database Administrator (DBA) to manage, maintain, and optimize mainframe database environments to ensure high availability, performance, security, and data integrity.
• The ideal candidate will have strong experience with IBM mainframe systems, DB2 for z/OS, database administration, performance tuning, backup and recovery, and production support.
• Responsibilities include database installation and configuration, database maintenance, capacity planning, performance monitoring, troubleshooting, disaster recovery, and implementing database security standards.
• The candidate will collaborate with mainframe system programmers, application developers, infrastructure teams, and operations teams to ensure reliable database operations and support business-critical applications.

Key Responsibilities

• Manage DB2 objects (databases, tablespaces, tables, indexes)
• Execute DB2 commands (STOP/START, DISPLAY, thread cancel/termination)
• Run DB2 utilities (REORG, RUNSTATS, COPY/RECOVER, LOAD/UNLOAD, REPAIR)
• Perform BSDS updates using DSNJU003/DSNJU004
• Support DB2 upgrades, migrations, SMP/E maintenance
• Use ISV tools (BMC, CA, IBM utilities)
• Monitor and tune performance using DB2 catalog and tools
• Troubleshoot DB2 and application issues
• Manage grants, privileges, and security
• Follow ITIL processes (Incident, Problem, Change, Configuration)
• Support DR planning and execution

Required Qualifications

4 6 years of Mainframe DB2 DBA or System Programmer experience

Strong Mainframe & DB2 architecture knowledge

Proficiency in JCL and z/OS operations

Hands-on experience with DB2 utilities and SMP/E

Experience with BMC/CA tools

Strong SQL and catalog analysis skills