DB2 DBA

We are seeking an experienced Mainframe DB2 Database Administrator (DBA) to manage, support, and optimize DB2 databases in a z/OS environment.

Requirements

• Install, configure, and maintain DB2 for z/OS environments
• Perform database creation, alteration, and migration activities
• Manage tablespaces, indexes, buffer pools, and storage structures
• Monitor and tune DB2 performance using tools (e.g., Omegamon, Query Monitor)
• Analyze SQL performance and recommend optimization strategies
• Identify and resolve locking, contention, and resource issues
• Define and maintain backup/recovery strategies
• Perform database recovery, disaster recovery drills, and testing
• Support data sharing environments and ensure high availability
• Provide L2/L3 support for production incidents
• Troubleshoot DB2 abends, timeouts, deadlocks, and performance issues
• Participate in on-call rotation and critical issue resolution
• Manage DB2 security (GRANT/REVOKE, RACF integration)
• Ensure compliance with audit and regulatory requirements
• Support database changes across DEV, QA, and PROD environments
• Review and implement DDL changes and migration scripts
• Coordinate with application teams for releases and deployments

Benefits

• Competitive salary
• Medical benefits
• Paid time off
• 401k matching