DB2 SQL Database Administrator

We are seeking an experienced DB2 SQL Database Administrator (DBA) Level II to support enterprise mainframe database environments. The ideal candidate will have strong hands-on experience with IBM DB2 for z/OS, SQL performance tuning, database administration, and production support.

The candidate will work closely with application teams to support database onboarding, upgrades, performance optimization, and ongoing maintenance while ensuring high availability, reliability, and security of critical production systems., * Serve as the primary DBA contact for application onboarding, upgrades, and major enhancements.

• Monitor and optimize DB2 subsystem performance, including CPU, I/O, buffer pools, locking, and SQL queries.
• Perform SQL performance tuning, query optimization, and index analysis.
• Analyze and resolve database performance bottlenecks using Omegamon, EXPLAIN, RMF, SMF, and native DB2 utilities.
• Plan and execute DB2 maintenance activities, including PTFs, service packs, and version upgrades.
• Perform database administration, monitoring, troubleshooting, and recovery activities.
• Collaborate with application and infrastructure teams to recommend database solutions and improvements.
• Ensure database availability, reliability, security, and compliance with SOX and audit requirements.
• Proactively identify performance risks and opportunities to improve database operations.

• 5-10 years of hands-on experience as an IBM DB2 for z/OS Database Administrator in large enterprise environments.
• Strong knowledge of DB2 z/OS architecture, subsystems, database utilities, logging, and recovery.
• Extensive experience in SQL performance tuning, query optimization, execution plan analysis, and index optimization.
• Hands-on experience with DB2 monitoring and performance tools such as Omegamon, EXPLAIN, RMF, and SMF.
• Strong experience supporting critical production database environments with 24x7 availability requirements.
• Experience with mainframe operations, including z/OS concepts, datasets, JCL, batch processing, and job scheduling.
• Experience with DB2 maintenance, upgrades, PTFs, and database utilities.
• Knowledge of database security best practices, SOX compliance, and audit processes.
• Strong troubleshooting, analytical, communication, and cross-functional collaboration skills.
• Experience supporting large-scale enterprise projects., * Experience supporting manufacturing or automotive industry database environments.
• Experience working with application teams on database performance improvements and system enhancements.