Oracle Applications Database Administrator

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
- Develop, manage and maintain robust backup and recovery procedures. Monitor database performance and system health, including reporting and tuning.
- DESCRIPTION**RESPONSIBILITIES AND OBLIGATIONS**

**Operational Database Administration**
- 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.
- 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.

**STANDARD COMPLIANCE DUTIES**

**Furthermore, the incumbent has to be aware that**:

- You are aware of and have access to the CDC’s SHEMS;
- You are aware of your responsibilities and duties as laid out in the CDC’s SHEMS;
- You are aware that you work in a safe and environmentally friendly manner;
- You ensure that the company’s housekeeping standards are maintained throughout your area of responsibility;
- You report any unsafe conditions or acts which you cannot rectify yourself to your SHE representative or to the Senior SHE Project Manager as soon as possible;
- You report all SHE incidents which occur within your area of responsibility promptly and in the correct format;
- You are totally familiar with your responsibilities in terms of the CDC’s emergency plan;
- You communicate to the Senior SHE Project Manager any required changes to the SHEMS prior to implementing these changes;
- You timeously complete and correctly record any corrective action which needs to be taken in order to rectify a SHE matter;
- You give full co-operation to, and participate in (as required), the CDC’s internal and external SHEMS audits.

**You have the authority to**:

- Immediately stop any person(s) on CDC property from committing an unsafe or destructive act or omission;
- Take whatever immediate steps you deem necessary to prevent injury or environmental damage when confronted with an unsafe or destructive condition.

**Additionally, ensure that**:

- During your period of employment and subsequent thereto, you shall keep confidential and shall not make use of, directly or indirectly, and shall not disclose any of the CDC’s trade secrets or confidential information or those of its subsidiary or associate companies or those of other persons who have made disclosures to the CDC under conditions of confidentiality, other than to persons authorised by the CDC or those employed by the CDC who are required to know such secrets or to have such information for the purpose of their employment with the CDC.
- You shall not, without the written permission of the CEO, be directly or indirectly employed for gain in any business or pursuit other than that of the CDC. Such permission will be granted only if the CEO is satisfied that the activity is not in conflict with the CDC’s interests, and that the Employee’s ability to fulfil his/her duties to the CEO satisfaction will not be impaired.
- It is conditional that you and/or no immediate relative or member of my household be employed by an organisation in direct competition with the CDC, without the CDC’s written approval. The CDC reserves the right to enquire as to the place of employment of my spouse or any member of my household.
- You will abide by the CDC Code of Conduct and Ethics Policy which seeks to codify the expected ethical behavior from me, to meet the ideal of good corporate governance.

**QUALIFICATION AND EXPERIENCE**
- Relevant Degree or Diploma in Information Technology, any related or equivalent;
- Minimum 8 years' experience in Oracle Application Database Administration;
-