Senior Oracle Database Administrator (2680) needed at The South African National Roads Agency

MINIMUM REQUIREMENTS:

• A Diploma in Information Technology at an NQF level 6.
• Five (5) years of relevant experience.

Certification:

• Oracle Certified Professional (OCP) or Oracle Database Administration

ADVANTAGEOUS:

• Exposure to MongoDB and SQL Server databases.
• Experience in Oracle APEX, Oracle Spatial, and Oracle BI tools.

KEY RESPONSIBILITIES:

Database Administration and Maintenance

• Administer and maintain 8+ enterprise-grade Oracle databases, ensuring high availability, security, and performance.
• Perform daily health checks, troubleshooting, and root cause analysis of database-related incidents.
• Develop and implement best practices for database security, backup, and disaster recovery.
• Conduct regular patching, updates, and version upgrades to ensure stability and compliance.
• Automate routine database administration tasks to enhance operational efficiency.

Performance Tuning & Optimization

• Implement and maintain Oracle Data Guard, RMAN, and Fast Recovery Area (FRA) for business continuity.
• Design and manage Oracle RAC and other high-availability solutions.
• Conduct failover testing and regularly validate disaster recovery plans.
• Experience with Veeam Backup Solutions
• Experience with Oracle RMAN Merged Incremental Backups

Availability

• Implement and maintain Oracle Data Guard, RMAN, and Fast Recovery Area (FRA) for business continuity.
• Design and manage Oracle RAC and other high-availability solutions.
• Conduct failover testing and regularly validate disaster recovery plans.

Security and Compliance

• Manage Oracle database security policies, user access control, and auditing.
• Oracle Advanced Security (TDE, Data Vault, Audit Vault) experience.
• Ensure compliance with IT governance frameworks and security best practices.
• Support internal and external audit processes, ensuring database security compliance.

Stakeholder Collaboration, Support and Reporting

• Provide technical expertise and support to development, infrastructure, and application teams.
• Engage with vendors to resolve database issues.
• Document database configurations, best practices, and standard operating procedures.
• Produce monthly database reports aligned with business and audit requirements.
• Support complex integration projects.