Mainframe System DBA

Job Description

Role: 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