Your part in the ongoing success of our department, in supporting frontline services will see you responsible for a variety of work, including, but not limited to:
- Implement and maintain smooth operation and physical design of databases, monitoring performance and conducting regular reviews to optimise queries for maximum efficiency and meet users’ requirements.
- Manage and optimise databases to ensure the availability and reliability of critical organisational actual and future ETL processes to ensure optimisation and best practices.
- Review database design and integration of systems to anticipate future storage and performance needs and make recommendations regarding enhancements and/or improvements to support sustainability of the systems.
- Provide technical support to users, troubleshooting user-reported issues, and conducting training sessions to educate users on database usage best practices and troubleshooting techniques.
- Identify security vulnerabilities and implement measures to safeguard the database against unauthorised access, data breaches, and other security threats.
- Resolve challenges related to integrating the database with other systems, applications, or third-party services, including data mapping, transformation, and synchronisation.
- Implement data security procedures, and best practices to protect sensitive information, and generate regular reports on performance, usage, and security compliance for senior management and stakeholders.
- Perform routine maintenance tasks, such as database backups, index rebuilding, and statistics gathering to ensure data reliability and minimise downtime to meet functional and organisational requirements.