DB2 for z/OS DBA — Hands-on Mainframe Performance Lead

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

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.