Database Administrator — DB2 for z/OS

Accenture in South Africa; Midrand; On-site; ZAR 700,000 - 1,200,000; Full time

Job summary

Accenture seeks a hands-on mainframe DBA to support DB2 for z/OS in BAS production and development environments. You will manage releases, version control, monitor performance, and guide developers on SQL, escalating risks of DB unavailability.

You will lead a small DBA team when needed, perform QA on SQL before release, and provide expert guidance in troubleshooting DB2, CICS, and VSAM issues within a customer-facing setting.

Qualifications

• Minimum 3 years' experience as a DB2 DBA or Senior Operator in a z/OS environment.
• Working knowledge of Mainframe (MVS), DB2 for z/OS, Windows operating systems, SQL, CICS, REXX and JCL
• Batch operations and MVS architectures

Responsibilities

• Authorise TSO user-IDs and grant relevant privileges to specific tables within production departments' databases
• Monitor production reports so scheduled reports stay within agreed execution times, and improve throughput of reports on the BAS system
• Provide support to end users of the MVS environment
• Work effectively as part of the team and support the team's goals
• Identify problems and raise them to your supervisor with enough lead time to avert crises
• Provide DB2 performance and tuning suggestions
• Perform Release Management functionality
• Perform Database Quality Assurance and review all SQL code for programs destined for release to production
• Periodically perform standby duty — responding to DB2/CICS/VSAM problems raised by production departments and by maintenance team members
• Set up and analyse extents for DB2 tables and VSAM files in production, with continuous monitoring and rectification
• Monitor online transactions and suggest optimisation opportunities
• Continuously improve procedures used within platform support and operations support
• Create and set up new DB2/CICS/VSAM objects when a new department implements the BAS system
• Monitor VSAM splits and schedule VSAM and database reorganisations as needed
• Set up and perform database refreshes from production database tables to non-production databases
• Create new database tables, table spaces and indexes, and alter the structure of existing tables as agreed with the senior DBA
• Perform release management and version control tasks when required
• Peer review other team members' procedural documents
• Supervise a small DBA team when required
• Complete weekly status feedback and reporting
• Assist team members with DBA and Release Management tasks
• Attend client meetings and workshops representing the project

Skills

Mainframe depth

DB2 for z/OS

CICS

JCL

SQL

Education

Technical Diploma in a relevant field

2 years of related skills experience

Tools

DB2 for z/OS tools

QMF for z/OS

DB2 Data Studio

TMON

Job description

The Opportunity

This is a hands‑on mainframe DBA role supporting both the BAS production environment and the development environment on DB2 for z/OS, MVS and CICS. You'll perform Database Administration functions with full administrator rights, own Release Management and Version Control, and provide reports and recommendations to your supervisor and management on system performance and improvements. You'll also be the person developers come to for guidance on SQL coding, and the person who escalates risks and database unavailability to the Supervising DBA. If you want deep mainframe work with real ownership — not ticket‑queue support — this is that role.

This Role Is a Strong Fit If You

• Are a working DB2 for z/OS DBA (or a Senior Operator ready to step up) with genuine mainframe depth
• Are fluent across the classic stack — MVS, CICS, VSAM, JCL, REXX, SQL
• Enjoy performance and tuning work, not just keeping the lights on
• Are comfortable standing in front of clients and, when needed, supervising a small team
• Automate what you can rather than repeating it

What You’ll Do

Day-to-Day

• Authorise TSO user-IDs and grant relevant privileges to specific tables within production departments' databases
• Monitor production reports so scheduled reports stay within agreed execution times, and improve throughput of reports on the BAS system
• Provide support to end users of the MVS environment
• Work effectively as part of the team and support the team's goals
• Identify problems and raise them to your supervisor with enough lead time to avert crises
• Provide DB2 performance and tuning suggestions
• Perform Release Management functionality

Database Administration

• Perform Database Quality Assurance and review all SQL code for programs destined for release to production
• Periodically perform standby duty — responding to DB2/CICS/VSAM problems raised by production departments and by maintenance team members
• Set up and analyse extents for DB2 tables and VSAM files in production, with continuous monitoring and rectification
• Monitor online transactions and suggest optimisation opportunities
• Continuously improve procedures used within platform support and operations support
• Create and set up new DB2/CICS/VSAM objects when a new department implements the BAS system
• Monitor VSAM splits and schedule VSAM and database reorganisations as needed
• Set up and perform database refreshes from production database tables to non-production databases
• Create new database tables, table spaces and indexes, and alter the structure of existing tables as agreed with the senior DBA
• Perform release management and version control tasks when required
• Peer review other team members' procedural documents

Supervision & Client Engagement

• Supervise a small DBA team when required
• Complete weekly status feedback and reporting
• Assist team members with DBA and Release Management tasks
• Attend client meetings and workshops representing the project

What You’ll Bring

Required

• Minimum 3 years' experience as a DB2 DBA or Senior Operator in a z/OS environment
• Working knowledge of Mainframe (MVS), DB2 for z/OS, Windows operating systems, SQL, CICS, REXX and JCL
• Batch operations and MVS architectures

Qualifications

• Technical Diploma in a relevant field of study
• A minimum of 2 years of experience in relevant related skills
• Expert proficiency in Database Management
• Expert proficiency in Database Optimization & Tuning

Preferred Skills

Not required to apply — but the more of these you bring, the stronger your application.

Core Platform

• DB2 V12 or higher in a z/OS environment
• DB2 for z/OS
• DB2 Administrator Tool for z/OS
• DB2 Data Studio
• DB2 IDZ and IDAA

Performance & Monitoring

• Understanding of database management tools — performance monitors, schedulers and similar
• DB2 Omegamon
• DB2 Query Monitor for z/OS
• DB2 SQL Performance Analyser
• OPTIM Query Workload Tuner
• TMON

Query, Analysis & Debugging

• QMF for z/OS
• QMF for Workstation
• DB2 Log Analysis Tool for z/OS
• CICS DBUG Tool

Scheduling & Automation

• CONTROL-M / R / O / T
• SQL and/or REXX coding to automate routine tasks

Additional Advantage

• Experience as a DBA in Oracle

About Accenture

Accenture is a leading solutions and global professional services company that helps the world's leading enterprises reinvent by building their digital core and unleashing the power of AI to create value at speed across the enterprise — bringing together the talent of our approximately 779,000 people, our proprietary assets and platforms, and deep ecosystem relationships. Our strategy is to be the reinvention partner of choice for our clients and to be the most AI-enabled, client-focused, great place to work in the world. Through our Reinvention Services we bring together our capabilities across Strategy, Consulting, Technology, Operations, Song and Industry X with deep industry expertise to create and deliver solutions and services for our clients. Our purpose is to deliver on the promise of technology and human ingenuity, and we measure our success by the 360° value we create for all our stakeholders. Visit us at accenture.com.

Accenture | Let there be change

Across industries and around the world, we're creating better experiences for people using emerging technologies and human ingenuity. Together, we can reinvent anything.