Database Administrator

Accenture; Midrand; On-site; ZAR 500 000 - 650 000; Full time

Job summary

A leading global consulting firm in Midrand is seeking an experienced Database Administrator to manage and optimize DB2 databases on z/OS mainframe. The successful candidate will engage with various teams, ensuring high performance and availability of database services. They should have significant experience in database tuning and collaboration to implement effective solutions. Required qualifications include DB2 DBA Certification and substantial experience in IBM z/OS environments. This role offers a dynamic work environment focused on best practices in database management.

Benefits

Health insurance

Professional development opportunities

Flexible working hours

Qualifications

• z/OS DB2 DBA Certification required.
• Minimum 3 years of experience in an IBM z/OS environment essential.
• Strong understanding of MVS architectures and batch operations mandatory.

Responsibilities

• Administer and optimize databases on DB2 for z/OS mainframe.
• Perform database functions, including design, implementation, and maintenance.
• Monitor and analyze database performance for improvements.
• Collaborate with teams for effective database solutions.

Skills

DB2 optimization

Database tuning

Problem-solving

Collaboration

Education

z/OS DB2 DBA Certification

Minimum 3 years' experience as DB2 DBA

Tools

IBM DB2

JCL

SQL

CONTROL-M/R/O/T

Job description

Responsibilities

As a Database Administrator, you will be responsible for administering, optimizing, monitoring, and fine‑tuning databases on DB2 for z/OS mainframe. You will perform various related database functions across multiple teams or clients, including designing, implementing, and maintaining new databases, backup/recovery, and configuration management. Additionally, you will install database management systems (DBMS) and provide input for the modification of procedures and documentation used for problem resolution and day‑to‑day maintenance. You will engage with multiple teams, contribute to key decisions, provide solutions to problems across teams, and master proficiency in IBM DB2 database administration. Advanced proficiency in IBM z/OS, database optimization & tuning, database performance management, and intermediate proficiency in IBM Db2 Query Management Facility (QMF) and Job Control Language (JCL) are required.

• Develop and implement innovative strategies for optimizing database performance and tuning.
• Conduct regular database performance monitoring and analysis to identify areas for improvement.
• Collaborate with cross‑functional teams to design and implement database solutions that meet business requirements.
• Stay up‑to‑date with the latest trends and advancements in database administration to ensure best practices are followed.
• Provide technical guidance and support to team members on database‑related issues.
• Authorize TSO user‑ids and grant the relevant privileges to specific tables within certain production departments’ databases.
• Monitor production reports to ensure that all scheduled reports do not exceed the agreed execution time and improve the throughput on the BAS system.
• Provide support to end users of the MVS environment.
• Assist with Release Management functionality.
• Database Quality Assurance and review 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 maintenance team members.
• Extents setup and analysis of DB2 tables and VSAM files in production and continuous monitoring and rectification thereof.

Job Qualifications

Required:

• z/OS DB2 DBA Certification
• Minimum 3 years’ experience as DB2 DBA in an IBM® z/OS environment
• Working knowledge of Mainframe (MVS), DB2 for z/OS, Windows operating systems, SQL, CICS and JCL
• Batch operations and MVS architectures

Preferred Skills

• DB2 v11/v12/v13 in a z/OS environment Certification
• Understanding of database management tools e.g. Performance Monitor, schedulers such as CONTROL‑M/R/O/T
• DB2 Query Monitor for z/OS
• DB2 SQL Performance Analyzer
• OPTIM Query Workload Tuner
• DB2 Administrator Tool for z/OS
• DB2 Log Analysis Tool for z/OS
• QMF for Workstation
• QMF for z/OS
• CICS DBUG Tool
• TMON
• IDZ
• SQL and/or Rexx coding to automate routing tasks.