Mainframe DBA

Role - Mainframe DBA
Location - Cleveland, OH

Type - Full Time

Job Description

Skill: Mainframe System DBA

Must Have Technical/Functional Skills:

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

Roles & 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