Database Administrator

Accenture; Midrand; On-site; ZAR 40 000 - 80 000; Full time

Job summary

Join a forward-thinking company as a Database Administrator in a dynamic team focused on optimizing database performance for a key government project. This role involves mastering IBM DB2 on z/OS, collaborating with cross-functional teams, and providing innovative solutions to enhance database operations. You'll be responsible for administering and fine-tuning databases, ensuring optimal performance, and guiding team members through technical challenges. With opportunities for professional growth and a chance to make a significant impact on national financial management, this position is perfect for those passionate about database technology and eager to contribute to meaningful projects.

Qualifications

• Master proficiency in IBM DB2 Database Administration is required.
• Minimum 3 years' experience as DB2 DBA in an IBM z/OS environment.
• Working knowledge of Mainframe (MVS), DB2 for z/OS, SQL, and JCL.

Responsibilities

• Administer, optimize, and monitor databases on DB2 for z/OS mainframe.
• Design, implement, and maintain new databases and perform backup/recovery.
• Collaborate with teams to design and implement database solutions.

Skills

IBM DB2 Database Administration

Database Optimization & Tuning

Database Performance Management

IBM z/OS

SQL

Job Control Language (JCL)

CICS

Mainframe (MVS)

Education

z/OS DB2 DBA Certification

3+ years experience as DB2 DBA

Tools

DB2 Query Monitor for zOS

DB2 SQL Performance Analyser

OPTIM query Workload Tuner

DB2 Administrator Tool for zOS

DB2 Log Analysis Tool for zOS

QMF for Workstation

QMF for zOS

CICS DBUG Tool

TMON

IDZ

Job description

Client & Project: We are seeking for a new talent to join the BAS Technical team in Centurion. The project is for 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 finetuning 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 also engage with multiple teams and contribute to key decisions. Furthermore, you will provide solutions to problems for your immediate team and across multiple teams. Master proficiency in IBM DB2 Database Administration is required. Advanced proficiency in IBM z/OS, Database Optimization & Tuning, and Database Performance Management, as well as intermediate proficiency in IBM Db2 Query Management Facility (QMF) and Job Control Language (JCL), are recommended.
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.
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.
Assist with Release Management functionality
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.
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.

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 or v12 or v13 in a z/OS environment Certification
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
IDZ
SQL and/or Rexx coding to automate routing tasks.