Mainframe System DBA

PB consulting

Cleveland, OH

Posted On: Nov 18, 2026

Posted On: Nov 18, 2026

Job Overview

Experience

4 - 8 Years

Salary

Depends on Experience

Work Arrangement

On-Site

Travel Requirement

0%

Required Skills

  • Mainframe IBM Db2 DBA
  • IBM Db2 System Programming
  • IBM Db2 Architecture
  • MF z/OS
  • JCL
  • IBM Db2 Utilities
  • SMP/E
  • SQL
  • IBM Db2 Performance Tuning
  • BMC Tools
  • CA Tools
  • BSDS Maintenance
  • IBM Db2 Backup & Recovery
Job Description
Role Overview

We are looking for an experienced Mainframe System DBA with strong expertise in DB2 administration, system programming, and z/OS operations. The candidate will be responsible for DB2 subsystem administration, database maintenance, performance monitoring, troubleshooting, and system upgrades.

Required Technical Skills
  • 4–6 years of experience in Mainframe DB2 DBA or System Programming.
  • Strong knowledge of Mainframe and DB2 architecture.
  • Proficiency in JCL, TSO/ISPF, and z/OS operations.
  • Hands-on experience with DB2 commands, utilities, and SMP/E.
  • Experience with BMC, CA, and IBM DB2 tools.
  • Strong SQL and DB2 catalog analysis skills.
  • Knowledge of DB2 performance tuning, backup, and recovery.
Roles & Responsibilities
  • Manage DB2 objects, including databases, tablespaces, tables, and indexes.
  • Execute DB2 commands such as STOP, START, DISPLAY, and thread cancellation/termination.
  • Perform DB2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, and REPAIR.
  • Perform BSDS updates using DSNJU003 and DSNJU004 utilities.
  • Support DB2 upgrades, migrations, installation, and maintenance using SMP/E.
  • Monitor DB2 subsystem performance and troubleshoot system and application issues.
  • Manage DB2 security, user access, grants, and privileges.
  • Utilize IBM, BMC, and CA tools for DB2 administration and monitoring.
  • Follow ITIL processes for Incident, Problem, Change, and Configuration Management.
  • Support Disaster Recovery (DR) planning, testing, and execution.
Preferred Skills
  • Experience in production Mainframe DB2 environments.
  • Knowledge of DB2 subsystem configuration and maintenance.
  • Strong analytical, troubleshooting, and communication skills.

Job ID: PC522881


Posted By

Naincy han

Technical Recruiter