Database Administrator Specialist

Accenture in South Africa; Midrand; On-site; ZAR 520,000 - 820,000; Full time

Job summary

Accenture in South Africa is seeking an experienced DB2 DBA for z/OS environments to administer BAS systems and support DB2/CICS/VSAM workloads on the mainframe. Responsibilities include release management, tuning, and ensuring high availability for production databases.

You will work in a collaborative team, providing guidance on SQL coding, monitoring performance, and leading database support activities for production and development environments.

Qualifications

• Minimum 3 years of experience as DB2 DBA or Senior Operator in a z/OS environment.
• Working knowledge of Mainframe (MVS), DB2 for z/OS, Windows OS, SQL, CICS, REXX and JCL.
• Strong database optimization and tuning skills.

Responsibilities

• Authorize TSO user-ids and grant privileges to production databases.
• Monitor production reports and improve throughput of BAS reports.
• Provide end-user support for the MVS environment.
• Identify problems and escalate with lead time to avert crises.
• DB2 performance and tuning suggestions.
• Release management and version control tasks when required.
• Peer review procedural documents.
• Supervise small DBA team if required.
• Attend client meetings and workshops representing the project.

Skills

DB2 DBA

z/OS knowledge

Mainframe

SQL language

CICS

Education

Technical Diploma in relevant field

Tools

DB2 for z/OS

REXX

JCL

CICS

SQL

QMF

OPTIM

CONTROL-M

VSAM

Job description

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 our 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 ataccenture.com.

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 our 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 ataccenture.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.

OVERALL, PURPOSE OF JOB:

Perform Database Administration functions with administrator rights

Performs Release Management and Version Control function

Support both the BAS production environment users and the development environment on DB2 for z/OS, MVS and CICS. Provide reports and recommendations to supervisor and management, on system performance and improvements.

Provide guidance to developers on sql coding. Report risks and Database unavailability to Supervising DBA.

MAIN RESPONSIBILITIES/TASKS:

Day-to-Day Activities:

Authorization of TSO user-ids and granting of the relevant privileges to specific tables within certain production departments’ databases.

Monitoring of production reports to ensure that all scheduled reports not exceed the agreed execution time and to improve the throughput of reports on the BAS system.

To provide support to end users of the MVS environment.

Working effectively as part of the team and seek to support team’s goals.

Identifying problems and bringing them to supervisor’s attention with sufficient lead in time to avert crises.

DB2 performance and tuning suggestions

Release Management functionality

Administration Responsibilities:

Database Quality Assurance and reviews of all SQL Code for programs destined for release to production.

Periodically perform standby duty – Respond to any DB2/CICS/VSAM problems experienced by production departments, as well as the maintenance team members.

Extents setup and analysis of DB2 tables and VSAM files in Production and the continuous monitoring and rectification thereof.

Monitoring and suggest possible optimization ideas of online transactions.

Continuous improvement of any procedures used within platform support and operations support.

Creation and setup of new DB2/CICS/VSAM objects whether a new department is implementing the BAS system.

Monitoring of VSAM splits and scheduling of VSAM and database reorganizations whenever the need arises.

Setup and perform database refreshes from production database tables to non-production databases.

Creation of new database tables, table spaces and indexes as well as altering the structure of existing database tables as agreed with senior DBA.

Perform release management and version control tasks when required.

Peer review other team members procedural documents.

Supervision Responsibilities:

Able to Supervise small DBA team if required

Complete weekly status feedback and reporting

Assist team members in DBA/Release Management task

Attend client meetings and workshops representing the project

KNOWLEDGE AND SKILLS:

Required:

Minimum 3 years’ experience as 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

Preferred Skills:

DB2 V12 or higher in a z/OS environment

Understanding of a database management tools e.g. Performance monitor, schedulers, e.g.

CONTROL-M/R/O/T

DB2 Query Monitor for zOS

DB2 SQL Performance Analyser

OPTIM query Workload Tuner

DB2 Administrator Tool for zOS

DB2 for zOS

DB2 Log Analysis Tool for zOS

QMF for Workstation

QMF for zOS

CICS DBUG Tool

TMON

DB2 Data studio

DB2 Omegamon

DB2 IDZ and IDAA

SQL and/or Rexx coding to automate routing tasks.

A DBA with experience in Oracle is an advantage.

A minimum of 2 years of experience in relevant related skills.

Expert proficiency in Database Management.

Expert proficiency in Database Optimization & Tuning.

Technical Diploma in relevant field of studies.