- Design, develop, implement, test, and maintain SQL databases
- Write SQL queries, views, procedures, and triggers for integration with other applications
- Create comprehensive database documentation
- Collaborate effectively with colleagues across the organisation
- Maintain and develop expertise in database technologies
- Contribute to the administration of the organisation's databases
- Understanding of MS SQL Server/Oracle or other database concepts from studies or work experience
- Knowledge of building, maintaining, and interrogating SQL databases in MS SQL, MySQL/MariaDB, Oracle, or PostgreSQL
- Experience ensuring database integrity in complex multi-project environments
- Ability to design database objects for efficient storage and performance
- Expertise in writing SQL queries, stored procedures, triggers, and DML
- Experience with ETL (Extract, Transform, Load) processes
- Strong organizational and documentation skills
- Ability to write clear requirement and specification documents
- Self-motivated with the ability to work effectively both independently and in a team
- Oracle PL/SQL knowledge
- Experience with multiple database platforms (PostgreSQL, MS SQL, Oracle, MySQL/MariaDB, AWS RDS)
- Background in Business Intelligence/Reporting tools
- Knowledge of PL/SQL, T-SQL, or other SQL procedural programming language extensions