Database Administrator — DB2 for z/OS at Accenture

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

Qualification

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