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