JOB PURPOSE
To conduct day-to-day database operation of the organization’s and its compliant with relevant regulations, and optimising it for better performance
KEY PERFORMANCE AREAS
• User Support – provide support to users who may encounter issues emanating from the database.
• Database Installations, configurations and maintenance – install database management systems and configure databases as per the design.
• Backup and recovery – implement defined backup and recovery plans to ensure that the databases and systems can be recovered quickly in the event of disaster or disruptions.
• Database programming – proficiency in writing T-SQL queries to support business operations.
• Database performance optimisation – ensure optimisation of database performance and maintain high level of availability ensuring the systems are accessible to the users when required.
• Database security – implement defined database security controls, security policies and procedures.
• Data Migration – migrate data between diffferent data sources and ensure data quality, integrity and curated data are implemented successfully.
• Capacity planning – provide input into planning for future growth to meet increasing demands.
• Technical writing – maintain existing technical documentation and related technical specifications. Provide input into the policies, procedures, etc.
• Compliance and regulations – Ensure compliance with the policies, processes, procedures and applicable standards and data laws and regulations (e.g. POPIA).
• Data governance – understanding of data governance principles and concepts.
• Project management – adherence to project management standards and techniques.
• Data lake administration- administering the data lake platform.
• Cloud database administration – administering cloud-based database management system.
EDUCATION, SKILLS AND EXPERIENCE
• A relevant Degree in Information Technology or a relevant NQF level 7 equivalent qualification
• User Support – minimum three (3) year experience.
• Database Installations, configurations and maintenance – minimum three (3) year experience.
• Backup and recovery – minimum three (3) year experience.
• Database programming – minimum three (3) year experience.
• Database performance optimisation – minimum three (3) year experience.
• Database security – minimum three (3) year experience.
• Data Migration – minimum one (1) year experience.
• Capacity planning – minimum one (1) year experience.
• Technical writing – minimum one (1) year experience.
• Compliance and regulations – knowledge of applicable standards and data laws and regulations (e.g. POPIA).
• Data governance – knowledge of data governance principles and concepts.
• Project management – knowledge of project management concepts, techniques and principles.
• Data lake administration- knowledge of administering the data lake platform is an advantage.
• Cloud database administration – experience in administering cloud-based database management system is an advantage