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.MANDATEMonitor 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.DESCRIPTIONRESPONSIBILITIES AND OBLIGATIONSOperational Database AdministrationEnsure 24 / 7 support for production and non-production database environments.Monitor database performance and system health, including reporting and tuningDevelop, 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 environmentDevelop, implement and monitor production schema changes.Write and optimise ad-hoc SQL and PL / SQL queries for reporting and analytics.System Configuration and Performance ManagementEnsure 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 systemsLead efforts in performance tuning, schema optimisation, and access control.Project Implementation and SupportParticipate in the installation and maintenance of database servers and replication on client environmentDesign, develop, and administration of Oracle databases.Control all production migrations of Oracle schema objectsSupport and enforce security and access control as needed in the project.Assist with database design and architecture to support enterprise initiatives.STANDARD COMPLIANCE DUTIESFurthermore, 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'swritten 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 EXPERIENCERelevant Degree or Diploma in Information Technology, any related or equivalent;Minimum 8 years' experience in Oracle Application Database Administration;Minimum 5 years' experience in PL / SQL development;Strong understanding of Oracle ERP system administrationIn-depth knowledge of client-server databases and functionalityAbility to manage full database lifecycle, including patches and updatesCapability to support enterprise-wide integrations and extensionsExcellent documentation and planning skillsStrong commitment to SHEMS compliance.PERFORMANCE INDICATORSPerformance 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.CLOSING DATE : 19 September

• CDC is an employment equity employer and placement will be in accordance with our Employment Equity Plan.The appointment of candidates is subject to the verification of all credentials (employment history, educational, financial, criminal and any other checks as may be necessary).

Please note that only shortlisted candidates will be contacted, and if you have not heard from us within one month of submitting your application, please consider it unsuccessful.CDC reserves the right not to make an appointment to any advertised position.

No late applications will be considered.

All applications must be forwarded to LOCATION : GqeberhaEMPLOYMENT TYPE : PERMANENTGRADE : C5