SQL Developer

Job Purpose: To design, develop, implement, and maintain all application systems and associated technologies, with a strong focus on SQL database development. The incumbent is responsible for ensuring optimum performance, efficiency, and high availability of data systems and related applications for internal and external clients. Key responsibilities: SQL development and database engineering Write advanced SQL queries, stored procedures, functions, views, and triggers. Design, normalise, and implement relational database models and schemas. Perform performance tuning and query optimisation, including execution plan analysis and troubleshooting. Define and implement indexing strategies, including clustered, non-clustered, and columnstore indexes. Develop and maintain ETL pipelines and data integration processes. Apply data warehousing concepts and dimensional modelling techniques. Manage database security, permissions, and access control. Plan and execute backup, recovery, and disaster ...