DATABASE ADMINISTRATOR
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
By continuing, you agree to our Terms & Privacy Policy.
DATABASE ADMINISTRATOR (ORACLE APPLICATIONS) ICT & RESEARCH - ICT
ACCOUNTABILITY
To provide comprehensive support, configuration, and maintenance of Oracle databases and related systems (ERP and Documentum ECM) to ensure high performance, availability, security, and integrity of CDC’s enterprise systems. This role is central to both daily operations and strategic project implementations involving Oracle technologies.
MANDATE
KEY PERFORMANCE AREAS
- Ensure 24/7 support for production and non-production database environments.
- Monitor database performance and system health, including reporting and tuning.
- Develop, manage and maintain robust backup and recovery procedures.
- Perform regular system housekeeping and space monitoring.
- Upload and apply patches to ensure up-to-date system functionality.
- Provide support for all Oracle system customisations, extensions, modifications and integrations, to the Oracle environment.
- Develop, implement and monitor production schema changes.
- Write and optimise ad-hoc SQL and PL/SQL queries for reporting and analytics.
System Configuration and Performance Management
- Ensure optimal configuration of Oracle ERP and related systems from a DBA perspective.
- Develop and maintain database documentation and version control.
- Monitor space in the database and in the operational systems
- Lead efforts in performance tuning, schema optimisation, and access control.
Project Implementation and Support
- Participate in the installation and maintenance of database servers and replication on client environment
- Design, develop, and administration of Oracle databases.
- Control all production migrations of Oracle schema objects
- Support and enforce security and access control as needed in the project.
- Assist with database design and architecture to support enterprise initiatives.
COMPETENCIES AND REQUIREMENTS
Educational Qualifications
Essential
- Degree in Information Technology (NQF 7), any related field or equivalent
Preferred
- None
Experience
Essential
- 8 years' experience in Oracle Application Database Administration
- 5 years’ experience in PL/SQL development
Preferred
- None
Competencies
Essential
- Strong understanding of Oracle ERP system administration
- In-depth knowledge of client-server databases and functionality
- Ability to manage full database lifecycle, including patches and updates
- Capability to support enterprise-wide integrations and extensions
- Excellent documentation and planning skills
- Strong commitment to SHEMS compliance
Preferred
- None
Licences, Registrations & Certifications
Essential
- None
Preferred
- None
DESCRIPTION
PERFORMANCE MANAGEMENT
Performance is monitored regularly at both an individual and a team level, in accordance with the CDC’s performance management system and control measures relevant to the position.
COMPLIANCE AND ETHICS
The incumbent is required to:
- Uphold the CDC’s Code of Conduct and Ethics Policy, demonstrating ethical behaviour and contributing to good corporate governance.
- Actively participate in and adhere to the CDC’s , Information Security and IT Service Management System (SHEMS) policies and procedures. This includes a responsibility for identifying and reporting potential risks and incidents related to safety, security, and quality, and for contributing to the ongoing improvement of the CDC's SHEMS.
- Be familiar with and adhere to the CDC emergency preparedness plans.
- Maintain confidentiality regarding CDC trade secrets and Information Security policies.
- Obtain prior written permission for any business or pursuit outside of the CDC that may conflict with the CDC’s interests, including immediate family members working for a direct competitor, adhering to the CDC’s Conflict of Interest Policy.
This job description outlines the primary responsibilities and key performance areas of the role. It is not intended to be an exhaustive list of all duties and tasks.