Mainframe System DBA - DB2 & z/OS

Experience Required: 8 14 Years Must-Have Skills 4 6 years of Mainframe DB2 DBA or DB2 System Programmer experience. Strong knowledge of Mainframe and DB2 architecture. Proficiency in JCL and z/OS operations. Hands-on experience with DB2 utilities and SMP/E maintenance. Experience with BMC, CA, and IBM utilities. Strong SQL skills and DB2 catalog analysis. Knowledge of DB2 performance monitoring, tuning, and troubleshooting. Roles & Responsibilities Administer DB2 objects, including databases, tablespaces, tables, and indexes. Execute DB2 commands such as STOP, START, DISPLAY, and thread cancellation or termination. Run DB2 utilities, including REORG, RUNSTATS, COPY/RECOVER, LOAD/UNLOAD, and REPAIR. Perform BSDS updates using DSNJU003 and DSNJU004. Support DB2 upgrades, migrations, and SMP/E maintenance. Use BMC, CA, and IBM tools to manage and maintain the Mainframe DB2 environment. Monitor and tune database performance using DB2 catalog information and diagnostic tools. Troubleshoot DB2 system and application-related issues. Manage database grants, privileges, and security controls. Follow ITIL processes for incident, problem, change, and configuration management. Support disaster recovery (DR) planning and execution. Qualifications Bachelor’s degree in Computer Science. Strong analytical and problem-solving skills. Ability to support enterprise Mainframe DB2 environments and operational requirements.