Mainframe Programmer

Mainframe System DBA – Job Description

Role Overview

The Mainframe System DBA is responsible for administering, maintaining, and optimizing DB2 databases and mainframe subsystems on z/OS, ensuring availability, performance, security, and compliance.

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 Skills

Strong Mainframe & DB2 a...