Must Have Technical/Functional Skills
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