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.