Database Administrator: Oracle at Department of Land Reform and Rural Development

REQUIREMENTS : Minimum requirements:

• Applicants must be in a possession of a Grade 12 Certificate and a National Diploma in Information Technology / Computer Science Information Management (NQF Level 6) or related equivalent qualification. Minimum of 3 years' junior management experience in Oracle database administration, Oracle database concepts, and facilities.

DUTIES :

• Develop deeds database systems. Planning, designing and managing database. Define new and existing physical data. Prepare programs to create data. Create physical data definitions to improve performance. Migrate and maintain Deeds databases to / on cloud environment. Design database tools to monitor file growth on a daily basis. Check the availability of spaces on all databases (Development, Test and Production).
• Allocate space per file (afterhours). Add modify, delete files and files structure as per request. Determine database optimisation tools. Test and evaluate programmer and optimisation tools. Answer program queries educate programmers in the database structures. Define and initiate backup and recovery procedures. Manage the creation and implementation of the plans to ensure data integrity. Ensure that sufficient space is made available for growth.
• Allocate more disk space (done afterhours). implement database definition controls, access controls. update controls and concurrence controls etc. Monitor database usage, collecting performance statistics and tuning the database. Maintain and monitor database. Add, modify and delete field, field sizes and attributes on the database as per request. Receive the request from developer Technical Development Manager. Maintain primary and secondary keys, indexes, super descriptors. Improve and maintain database to Include rollout and upgrades. Implement and release database changes according to agreed timescales and costs. Keep the three data base (Develop, Test and Production) in synchronization.