Oracle Database Administrator (DBA)

About the position

Oracle Database Administrator (DBA)

We are seeking a skilled and experienced Oracle Database Administrator (DBA) at an intermediate to senior level to manage, secure, and optimize mission-critical Oracle database environments. The ideal candidate will possess deep expertise in Oracle technologies, including performance tuning, high availability (HA), backup and recovery strategies, and PL/SQL development.

This role is essential in ensuring the availability, reliability, and scalability of Oracle database systems across development, testing, and production environments.

Key Responsibilities:

Database Administration & Management:

• Install, configure, and upgrade Oracle Database software and related components (e.g., Oracle Grid Infrastructure, Oracle Enterprise Manager).
• Manage Oracle databases across versions such as 12c, 19c, and 21c.
• Conduct routine maintenance including patching, space management, data refreshes, and reorganizations.
• Implement and manage Oracle Real Application Clusters (RAC), Data Guard, and ASM environments.
• Support Oracle Exadata environments where applicable.

Performance Tuning & Optimization:

• Monitor and analyze database performance using tools like AWR, ADDM, and OEM.
• Tune SQL queries and PL/SQL code for optimal performance.
• Resolve performance bottlenecks involving CPU, memory, disk I/O, and wait events.
• Work with development teams to improve application query performance.

Backup, Recovery & Disaster Recovery:

• Design and implement backup and recovery strategies using RMAN and Oracle Data Pump.
• Perform database restores and participate in disaster recovery testing.
• Ensure compliance with Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).

Security & Compliance:

• Manage user accounts, roles, and privileges.
• Implement security features such as Transparent Data Encryption (TDE), auditing, and data masking.
• Ensure adherence to data protection regulations (e.g., GDPR, POPIA, PCI-DSS).

Automation & Scripting:

• Develop and maintain shell scripts, SQL scripts, and PL/SQL procedures to automate database tasks.
• Utilize Oracle Scheduler or other orchestration tools for job automation and alerts.

Support & Troubleshooting:

• Provide 2nd/3rd-level support for Oracle database-related incidents and service requests.
• Collaborate with infrastructure and application teams to resolve issues.
• Participate in an on-call rotation for after-hours and weekend support.

Required Qualifications & Skills:

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Oracle Certified Professional (OCP) certification - strongly preferred.
• ITIL Foundation certification - advantageous.

Experience:

• Minimum 5 years' hands-on experience as an Oracle DBA.
• Demonstrated experience managing large-scale, high-availability, mission-critical databases.
• Experience with Oracle RAC, Data Guard, ASM, and Linux/UNIX environments (e.g., Red Hat, Oracle Linux, Solaris).
• Exposure to Oracle Cloud Infrastructure (OCI) is a plus.

Technical Skills:

• Strong proficiency in SQL and PL/SQL development.
• In-depth experience with RMAN, Data Pump, OEM, AWR/ADDM, and SQL*Plus.
• Solid understanding of Oracle internals, partitioning, and indexing strategies.
• Familiarity with monitoring tools such as OEM, Nagios, or Zabbix.
• Understanding of database security and compliance practices.
• Exposure to DevOps practices and CI/CD pipelines for database changes.
• Experience managing Oracle databases in hybrid cloud environments.
• Familiarity with other RDBMS platforms such as MySQL, PostgreSQL, or SQL Server.

Location:

• Johannesburg, Gauteng

Workplace Type:

• Hybrid

Job Type:

• Contract

Experience Type:

• Senior

We encourage you to apply - Kivara Rajgopal on [Email Address Removed] or via [Phone Number Removed];

Desired Skills:

• Oracle
• Database
• Linux
• Unix
• SQL
• ITIL
• Redhat

Desired Qualification Level:

• Degree