DBA SQL Level II

About the role

This position involves acting as the primary DBA contact during application onboarding, upgrades, and major enhancements. The role also includes monitoring DB2 subsystem performance and resolving performance issues.

Responsibilities

• Act as the primary DBA contact during application onboarding, upgrades, and major enhancements.
• Maintain and monitor DB2 subsystem performance (CPU, I/O, buffer pools, locking, queries).
• Analyze and resolve performance issues using tools such as Omegamon, EXPLAIN, RMF, SMF, and native DB2 utilities.
• Perform SQL performance tuning and index optimization in collaboration with application teams.
• Plan and execute DB2 maintenance activities including PTFs, service packs, and version upgrades.
• Proactively identify risks and improvement opportunities to ensure high availability and reliability.

Requirements

• 5-10 years of hands-on DB2 for z/OS (Manufacturing) DBA experience in large enterprise environments.
• Experience supporting critical production systems with 24x7 availability requirements.
• Strong experience in performance tuning, database utilities, and mainframe operations.
• Experience working on large-scale projects and coordinating with cross-functional teams.
• Deep knowledge of DB2 z/OS architecture, subsystems, utilities, logging, and recovery.
• Strong SQL tuning and execution plan analysis skills.
• Experience with monitoring tools (e.g., Omegamon) and mainframe performance metrics.
• Understanding of z/OS concepts including datasets, JCL, batch processing, and scheduling.
• Strong knowledge of SOX, audit processes, and database security best practices.

Qualifications

Must have a bachelor's degree in Computer Science, Information Technology, or a related field. Additional certifications may be required.

Skills

• DB2 for z/OS
• SQL tuning
• Mainframe operations
• Performance tuning
• Database utilities
• Monitoring tools
• SOX, audit processes, and database security

Benefits

• Medical, dental, and vision insurance
• 401(k)

Pay

$132-137k Local Candidates Only

Schedule

Onsite 4 days per week