Senior Database Administrator
First seen by Alion on Sep 11, 2026.
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.
Skills
DBA, DB2, z/OS, Database Maintenance, SQL, Database Performance Tuning, OLTP, IT Disaster Recovery