Database Administrator

Accenture; Gauteng; On-site; ZAR 500 000 - 700 000; Full time

Job summary

A leading company is seeking a skilled Database Administrator to join their BAS Technical team in Centurion. The role involves administering and optimizing databases on DB2 for z/OS mainframe, ensuring high performance and reliability. Candidates should have strong experience in database management and relevant certifications. This position offers the opportunity to work with the National Treasury, contributing to critical financial systems.

Qualifications

• At least 3 years of experience as a DB2 DBA in an IBM z/OS environment.
• Working knowledge of Mainframe (MVS), DB2 for z/OS, Windows OS.

Responsibilities

• Administering, optimizing, monitoring, and fine-tuning databases on DB2 for z/OS mainframe.
• Designing, implementing, and maintaining databases, backup/recovery, and configuration management.

Skills

Database Optimization & Tuning

Database Performance Management

IBM z/OS

SQL

CICS

Education

z/OS DB2 DBA Certification

Tools

DB2 v11

DB2 v12

DB2 v13

Performance Monitor

CONTROL-M

SQL Performance Analyser

DB2 Administrator Tool for z/OS

Job description

Client & Project : We are seeking a new talent to join the BAS Technical team in Centurion.

The project is for the National Treasury, a government agency responsible for managing the country's finances and economic policies.

Responsibilities :

As a Database Administrator, you will be responsible for administering, optimizing, monitoring, and fine-tuning databases on DB2 for z/OS mainframe.

Your duties include designing, implementing, maintaining databases, backup/recovery, and configuration management across multiple teams or clients.

Additional responsibilities involve installing DBMS, contributing to procedure and documentation modifications for problem resolution and daily maintenance, engaging with teams for key decisions, and providing solutions to issues within your team and beyond.

Mastery of IBM DB2 Database Administration is essential.

Advanced skills in IBM z/OS, Database Optimization & Tuning, and Database Performance Management, along with intermediate skills in IBM Db2 QMF and JCL, are recommended.

You will develop strategies for database performance optimization, conduct regular monitoring and analysis, collaborate on database solutions, and stay updated with the latest in database administration.

You will also provide technical guidance, manage TSO user-ids and privileges, monitor production reports, support end-users in MVS environments, assist with Release Management, review SQL code, perform standby duties, and analyze/setup DB2 tables and VSAM files.

Minimum Requirements :

• z/OS DB2 DBA Certification
• At least 3 years of experience as a DB2 DBA in an IBM z/OS environment
• Working knowledge of Mainframe (MVS), DB2 for z/OS, Windows OS, SQL, CICS, and JCL

Preferred Skills :

• DB2 v11, v12, or v13 in a z/OS environment
• Relevant certifications
• Understanding of database management tools such as Performance Monitor, Schedulers (CONTROL-M, R, O, T), TDB2 Query Monitor, SQL Performance Analyser, OPTIM Query Workload Tuner, DB2 Administrator Tool for z/OS, Log Analysis Tools, QMF, CICS DBUG Tool, TMONIDZ, SQL, Rexx scripting for automation