Senior Database Administrator - IBM DB2/z/OS

Job Summary :

We are looking for an experienced Senior IBM Db2 for z/OS Database Administrator (DBA) to manage, maintain, and optimize mission-critical Db2 databases running on IBM z/OS.

The ideal candidate will possess deep expertise in database administration, performance tuning, backup & recovery, security, and high availability within large enterprise environments.

Experience in financial services or payment systems is an added advantage.

Key Responsibilities :

- Administer and maintain IBM Db2 for z/OS databases across development, testing, and production environments.

- Monitor, troubleshoot, and optimize database performance using SQL tuning, EXPLAIN plans, catalog analysis, and performance monitoring tools.

- Design and implement database structures, indexing strategies, and data models to improve scalability and performance.

- Plan and execute backup, recovery, disaster recovery (DR), and database migration activities.

- Configure and manage database security, user access, auditing, and compliance using RACF, ACF2, or Top Secret.

- Perform capacity planning and ensure database availability, reliability, and optimal resource utilization.

- Support high-volume OLTP systems and mission-critical production environments.

- Collaborate with application development teams to establish database standards, optimize queries, and resolve performance bottlenecks.

- Manage incident resolution, root cause analysis, and production support activities.

- Participate in 24x7 on-call support and maintenance activities as required.

Required Skills :

- Strong experience in IBM Db2 for z/OS Administration

- Expertise in SQL Performance Tuning, EXPLAIN plans, and Catalog Analysis

- Backup, Recovery, and Disaster Recovery (DR) planning and execution

- Database Security Administration using RACF, ACF2, or Top Secret

- Production Support and Performance Troubleshooting

- Database Design, Data Modeling, and Index Optimization

- Capacity Planning and Performance Monitoring

- Experience supporting High Availability and high-volume Transaction Processing Systems

- Hands-on experience with :

1. BMC MainView

2. BMC Query Monitor

3. BMC Catalog Manager

4. BMC Utilities

Preferred Skills :

- IBM Q Replication (Db2 for z/OS to Db2 for z/OS)

- Db2 Data Sharing and Sysplex environments

- Db2 Connect

- Experience managing Very Large Tables (VLTs)

- Experience in Banking, Financial Services, or Payments domain

Ideal Candidate :

- The ideal candidate is a seasoned Senior Db2 for z/OS DBA with extensive experience in enterprise-scale mainframe environments.

- They should have strong expertise in database administration, performance optimization, security, replication, backup & recovery, and production support, along with the ability to manage highly available, mission-critical systems.