Parvana - MS SQL Developer (Senior)

Developer is needed in Cape Town, South Africa.

Client: Parvana

Location: Cape Town, WC, za

Contract: Freelance

Job Description

Location: Cape Town | Work Type: Hybrid | Job ID: J107208

Our client is a global investment advisory firm focusing on long-term value creation through investment strategies. They work with a diverse group of institutional partners and pride themselves on their collaborative, sustainable, inclusive culture and performance. You are welcome to go into the office daily or take advantage of their hybrid in-office/remote benefit. This company places significant investment in employee wellness, with industry-leading benefits on top of generous basic salaries. They offer fantastic career development opportunities and continuously improve their processes by tracking numerous metrics, leveraging automation, AI, and R&D. The work environment is cosmopolitan and diverse, fostering collaboration with the best professionals globally.

Requirements

• 6+ years of deep, hands-on experience in complex T-SQL query development, advanced stored procedures, views, user-defined functions, and execution plan analysis.
• Proven track record of diagnosing and resolving severe performance bottlenecks related to locking, blocking, deadlocks, and IO/memory optimization in large-scale SQL Server environments.
• Mastery of indexing strategies (clustered, non-clustered, columnstore, filtered) and table partitioning to optimize massive datasets.
• Deep expertise in designing highly normalized relational models (3NF/OLTP), with a strong understanding of dimensional modeling (star/snowflake schemas) as a secondary benefit.
• Experience with ETL/ELT processes and data pipeline tools (e.g., SSIS, Azure Data Factory, dbt) is highly advantageous but considered a secondary requirement to core database development.
• Familiarity with Azure SQL, Git, Azure DevOps, CI/CD pipelines for databases, or BI tools like Power BI/Tableau is a plus.

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 analyze 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 optimized for data integrity, low-latency data access, and seamless reporting.
• Ensure solutions reduce impact on transactional systems by optimizing data access patterns and separating operational and reporting workloads.
• Define and enforce strict standards for naming conventions, database design, and documentation; lead code reviews and champion SQL development best practices.
• Mentor junior developers and engineers on advanced SQL optimization and relational modeling practices. Work closely with backend application developers, BI teams, and business analysts to support data requirements.
• Assist with and maintain existing data ingestion processes, providing SQL support for ETL/ELT pipelines and integrations where necessary.

Additional Information

Requirements include expertise in Data Engineering / Science, Azure Data Factory (ADF), ETL/ELT, Data Pipelines, SQL Queries, SQL Server, Data Modelling, BI Teams, and Investment Advisory.