DB2 Mainframe Database Administrator

Primary Responsibilities:

• Manage and provide ongoing support for DB2 databases operating on Mainframe z/OS systems.
• Continuously monitor database performance metrics and execute tuning procedures to optimize operations.
• Oversee database object backups, recovery processes, and routine maintenance activities to ensure data integrity.
• Collaborate with application development teams to enhance SQL performance and implement database modifications.
• Run essential DB2 utilities including REORG, RUNSTATS, LOAD, and RECOVER to maintain database health.
• Diagnose and troubleshoot database-related issues, resolving incidents within production environments promptly.
• Maintain database security protocols, uphold system availability, and ensure the integrity of data assets.
• Assist with application deployment, migration projects, and release management activities.
• Perform capacity planning and manage storage resources to support database growth and performance.
• Develop comprehensive documentation, Standard Operating Procedures (SOPs), and deliver Level 2 and Level 3 production support.

Technical Expertise Required:

• Proficiency in Database Administration for DB2 on Mainframe environments.

Desired Skills and Experience:

• Familiarity with Database Technologies, specifically DB2 on Mainframe systems.