Oracel DBA (Oracle Database Administrator)

Data Centrix; Johannesburg; On-site; ZAR 650,000 - 850,000; Full time

Job summary

A well-established international client in the Warehousing and Logistics sector is looking for an OCA-certified Oracle DBA with over 5 years of experience. Candidates must have expertise in Oracle versions 12c, 19c, and 21c, along with comprehensive knowledge of Oracle RAC, Data Guard, RMAN, and PL/SQL development. This role includes responsibilities such as database administration, ensuring high availability, and optimizing performance across environments.

Qualifications

• 5+ years of experience as an Oracle Database Administrator (DBA) in large enterprise environments.
• Strong working knowledge of Oracle versions 12c, 19c, and/or 21c.
• Experience managing operations on virtualized, distributed infrastructures.

Responsibilities

• Provide expert-level administration and support for Oracle databases.
• Ensure high availability, performance, and security of Oracle database systems.
• Monitor and optimize database performance using AWR, ASH, and OEM.

Skills

Oracle RAC

Data Guard

RMAN

PL/SQL development

Performance tuning

Shell scripting

Education

Degree in Information Technology or Computer Science

Oracle Certified Associate (OCA)

Oracle Certified Professional (OCP)

ITIL Practitioner (V3) / ITIL Specialist (V4)

Job description

SUMMARY :

MTS's well-established international client in the Warehousing and Logistics sector is seeking a skilled OCA-certified Oracle DBA with over 5 years of experience in large enterprise environments. Candidates should have expertise in Oracle versions 12c, 19c, and 21c, with strong knowledge of Oracle RAC, Data Guard, RMAN, OEM, and PL/SQL development.

POSITION INFO : Requirements :

• Degree in Information Technology or Computer Science
• Oracle Certified Associate (OCA) – Oracle Database 12c or 19c - Required
• Oracle Certified Professional (OCP) – Oracle Database 12c or 19c - Advantage
• 5+ years of experience as an Oracle Database Administrator (DBA) in large enterprise environments
• Strong working knowledge of Oracle versions 12c, 19c, and/or 21c
• ITIL Practitioner (V3) / ITIL Specialist (V4)
• Hands-on experience with Oracle RAC, Data Guard, RMAN, OEM, PL/SQL development, and Shell scripting
• At least 3 years of experience working with complex business logic and high volumes of stored procedures
• Experience managing operations on virtualized, distributed infrastructures, including clustering, replication, and load balancing
• Proficiency in performance tuning and diagnostics (AWR, ASH, SQL Tuning Advisor)
• Exposure to functional/business workflows, ideally in supply chain or ERP systems
• Familiarity with DevOps practices, version control, and Agile methodologies is a plus

Overall Responsibilities :

• Provide expert-level administration and support for Oracle databases (12c/19c/21c) across development, testing, and production environments.
• Serve as the database specialist for business projects, focusing on both infrastructure and business logic understanding.
• Collaborate with developers, analysts, and business users to understand stored procedures, schemas, and application workflows.
• Ensure high availability, performance, and security of Oracle database systems.
• Install, configure, patch, and upgrade Oracle database software across environments (Azure and On-Premise).
• Design and implement database architecture, including tablespaces, partitions, indexes, and schemas.
• Monitor and optimize database performance using tools like AWR, ASH, and OEM.
• Implement backup and recovery strategies with RMAN and Data Pump.
• Maintain database security, auditing, and compliance.
• Manage database replication, high availability (RAC), and disaster recovery (Data Guard).
• Perform capacity planning and manage storage for large enterprise environments.
• Automate routine tasks using Shell or PL/SQL scripts.
• Periodically tune databases to maintain optimal I/O performance.
• Analyze, debug, and optimize complex PL/SQL procedures, packages, and triggers.
• Work closely with application teams to align database logic with business processes.
• Understand end-to-end workflows supported by Oracle systems, especially in logistics and supply chain domains.
• Translate functional requirements into optimized database queries or procedures.
• Participate in application development or modernization projects by providing database insights.

This job posting is active and open for applications.