Mainframe DBA

Mainframe DBA (CREQ
250895)

We are seeking an experienced Mainframe DB2 Database Administrator (DBA) to manage, support, and optimize DB2 databases in a z/OS environment. The role involves ensuring high availability, performance tuning, supporting database design, and handling production incidents while working closely with application, infrastructure, and support teams.

• Install, configure, and maintain DB2 for z/OS environments
• Perform database creation, alteration, and migration activities
• Manage table spaces, 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

• Work closely with application developers, system programmers, and infrastructure teams
• Provide guidance on database design, indexing strategies, and SQL best practices