Oracel Dba

3 weeks ago


Johannesburg, South Africa University Of Fort Hare Full time

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. #J-18808-Ljbffr


  • Oracel DBA

    4 weeks ago


    Johannesburg, South Africa University of Fort Hare Full time

    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...