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.