Website South African National Roads Agency (SANRAL)
SANRAL seeks to enhance your travel and road experience by strategically planning, designing, constructing, and maintaining the national road network for social development and economic growth in SA.
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.
