DATABASE ADMINISTRATOR: ORACLE

 POST 25/06 : DATABASE ADMINISTRATOR: ORACLE REF NO: 3/2/1/2022/424 Office of the Chief Registrar of Deeds 

SALARY : R744 255 per annum (Level 11), (all-inclusive package to be structured in accordance with the rules for MMS) 

CENTRE : Pretoria 

REQUIREMENTS : A National Diploma in Information Technology / Computer Science / Information Management (NQF Level 6). 3 years’ junior management experience in Oracle database administration, Oracle database concepts and facilities. Knowledge of database software installation and maintenance. Knowledge of Data extraction, transformation and loading. Knowledge of specialized data handling (very large databases with data types such as images and documents). Knowledge of database backups and recovery. Knowledge of database security and authentication. Database capacity planning and performance monitoring, troubleshooting, and tuning. Knowledge of transactional databases. Coaching and Mentoring (Though leadership) skills. Technical report writing skills. Presentation skills. Analytical skills. Problem solving skills. Communication skills. Project Management skills. Computer literate. A valid Driver’s license. 

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 and 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. 

ENQUIRIES : Ms L Gama Tel No: (012) 338 7229 or Ms P Hlatshwayo Tel No: (012) 338 7376 

APPLICATIONS : Please ensure that you send your application to Private Bag x918, Pretoria, 0001 or Hand deliver it to the Office of the Chief Registrar of Deeds at Cnr Bosman and Pretorius, Pretoria, 0001 before the closing date as no late applications will be considered. 

NOTE : Coloured, Indian and White Females and Coloured, Indian and White Males and Persons with disabilities are encouraged to apply.

Closing date 22 July 2022 at 16:00