MS SQL Developer (Senior)
Parvana • cape town, city of cape town metropolitan municipality • Posted June 26, 2026
Position Overview
Cape Town, South Africa | Posted on 18/06/2026
Location: Cape Town | Work Type: Hybrid | Job ID: J
What you will be doing:
- Design, develop, and optimize complex SQL Server database solutions. Write highly efficient, scalable, and maintainable T-SQL code, including advanced stored procedures, views, functions, and triggers.
- Deeply analyse execution plans, troubleshoot complex performance issues, and implement advanced indexing, partitioning, and query refactoring strategies to resolve critical bottlenecks in high-volume workloads.
- Design robust, scalable relational data models (OLTP/3NF) and analytical structures optimised for data integrity, low-latency data access, and seamless reporting.
- Ensure solutions reduce impact on transactional systems by optimising data access patterns and separating operational and reporting workloads.
- Define and enforce strict standards for namin...