DB2 Mainframe Database Administrator

Role Overview Accenture is seeking a Database Administrator – DB2 for z/OS (CL9) to support and optimize mission-critical mainframe environments. This role is responsible for the administration, performance tuning, security, availability, recovery, and continuous improvement of DB2 for z/OS databases supporting enterprise applications.

The successful candidate will work across the full database lifecycle, including installation support, database design, performance optimization, backup and recovery, release management, capacity planning, and production support. This role requires strong expertise in DB2 for z/OS, MVS/zOS, CICS, VSAM, JCL, SQL, and REXX , along with the ability to troubleshoot complex technical issues and drive operational excellence in high-availability environments.

Key Responsibilities Database Administration & Support- Administer and maintain DB2 for z/OS database environments.

• Create, modify, and manage DB2 databases, tablespaces, indexes, partitions, and related database objects.
• Monitor database health, availability, storage utilization, and capacity requirements.
• Manage database security, user access, privileges, and authorization controls.
• Perform database refreshes and data migrations between production and non-production environments.
• Support application deployments, release activities, and version control processes. Performance Monitoring & Optimization- Monitor and analyze database performance metrics.
• Identify and resolve bottlenecks affecting application and batch performance.
• Perform SQL tuning and optimization.
• Analyze access paths, locking issues, buffer pools, and resource utilization.
• Provide recommendations for database and application performance improvements.
• Support workload management and capacity planning activities. Backup, Recovery & Availability- Define and maintain backup and recovery strategies.
• Execute database recovery procedures during incidents and outages.
• Ensure compliance with Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Support disaster recovery testing and business continuity initiatives.
• Monitor database integrity and ensure high availability of critical business applications. Mainframe Operations Support- Support environments utilizing: DB2 for z/OS z/OS / MVS CICS VSAM JCL REXX Batch processing
• Troubleshoot production issues and coordinate resolution with infrastructure, application, and support teams.
• Support scheduled maintenance activities and on-call rotations when required. Quality Assurance & Governance- Review SQL code and database implementations before production deployment.
• Ensure adherence to database standards, policies, and best practices.
• Maintain accurate operational documentation and technical procedures.
• Participate in change management and release governance processes.
• Conduct root cause analysis and implement preventive improvements. Stakeholder Management- Collaborate with developers, architects, infrastructure teams, and business stakeholders.
• Provide technical guidance on database design and SQL development.
• Participate in client workshops, technical reviews, and project meetings.
• Communicate risks, issues, and recommendations to management. Required Qualifications:- Bachelor's degree or Technical Diploma in Computer Science, Information Technology, Engineering, or a related field.
• Proven years of experience as a DB2 for z/OS Database Administrator.
• Strong experience administering DB2 for z/OS in enterprise production environments.
• Experience supporting large-scale mainframe applications and mission-critical workloads.
• Strong understanding of: DB2 for z/OS z/OS / MVS CICS VSAM JCL SQL REXX
• Experience in database performance monitoring and tuning.
• Experience with backup, recovery, and disaster recovery processes.
• Strong analytical and troubleshooting skills.
• Excellent communication and stakeholder management capabilities. Preferred Qualifications- Experience with DB2 V12 or later.
• Experience using: IBM DB2 Administration Tool DB2 Data Studio DB2 Query Monitor OMEGAMON DB2 SQL Performance Analyzer IBM Optim Query Workload Tuner TMON
• Knowledge of database automation using SQL or REXX.
• Experience with Control-M scheduling.
• Exposure to Oracle database administration.
• Experience supporting financial services, insurance, government, or utilities environments.
• IBM DB2 certifications or equivalent mainframe certifications.