Oracel DBA (Oracle Database Administrator)
Permanent
JHB
Information Technology
Gauteng , JHB - Eastern Suburbs
MTS's well established international client in the Warehousing and Logistics sector is looking for a skilled OCA certified Oracle DBA with 5+ years experience in large enterprise environments.
Candidates must have expertise in Oracle versions 12c, 19c, and 21c, and strong knowledge of Oracle RAC, Data Guard, RMAN, OEM, and PL / SQL development.
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 (Real Application Clusters)
- Oracle Data Guard (disaster recovery and high availability)
- Oracle RMAN (backup and recovery)
- Oracle Enterprise Manager (OEM)
- PL / SQL development (packages, triggers, procedures)
- Shell scripting for task automation
- 3+ years working in environments with complex business logic and high volumes of stored procedures
- Management of operations on virtualized and distributed infrastructures
- Management of operations on environment with clustering, replication, load balancer
- Experience with performance tuning and advanced diagnostics (AWR, ASH, SQL Tuning Advisor)
- Exposure to functional / business workflows, ideally in logistics, 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 (primarily 12c / 19c / 21c) across development, testing, and production environments.
- Act as the database specialist for business projects using Oracle databases, focusing on both infrastructure and understanding of business logic.
- Collaborate with developers, analysts, and business users to understand stored procedures, schemas, and underlying application workflows.
- Ensure high availability, performance, and security of Oracle database systems within the enterprise.
- Install, configure, patch, and upgrade Oracle database software across multiple environments (Azure and OnPrem).
- Design and implement database architecture, including tablespaces, partitions, indexes, and schemas.
- Monitor and optimize database performance using tools like AWR, ASH, and Oracle Enterprise Manager.
- Implement backup and recovery strategies using RMAN and Oracle Data Pump.
- Ensure database security, auditing, and compliance with company policies and regulations.
- Handle database replication, high availability (Oracle RAC), and disaster recovery strategies (Data Guard).
- Perform capacity planning and manage database storage across large enterprise environments.
- Automate routine DBA tasks using Shell or PL / SQL scripts.
- Realize periodical tuning of the databases to maintain I / O performance.
- Analyse, interpret, and debug complex PL / SQL stored procedures, packages, and triggers.
- Work closely with application teams to align database logic with business processes.
- Understand end‑to‑end business workflows supported by Oracle systems, especially in the Logistics / Supply Chain domain.
- Translate functional requirements into optimized database queries or procedures.
- Participate in application development or modernization projects by providing database‑level insights.