MS SQL Developer (Senior)

Parvana; South Africa; Híbrido; ZAR 900.000 - 1.500.000; Jornada completa

Descripción de la vacante

Parvana is seeking a Senior SQL Server Data Engineer to design, optimize, and maintain scalable database solutions. You will write high-performance T-SQL, analyze complex execution plans, and implement advanced indexing and partitioning to support high-volume workloads.

You will model OLTP/3NF schemas, support ETL/ELT pipelines with SSIS/ADF/dbt, and collaborate with backend, BI, and analytics teams to ensure data integrity and accessible reporting.

Formación

• 6+ years of hands-on experience in complex T-SQL development, procs, views and execution plan analysis.
• Proven ability to diagnose and resolve severe performance bottlenecks in large SQL Server environments.
• Mastery of indexing strategies and table partitioning to optimize massive datasets.
• Deep expertise in designing normalised relational models (3NF/OLTP) with dimensional modelling understanding.
• Experience with ETL/ELT processes and data pipelines (SSIS, ADF, dbt) is highly advantageous.

Responsabilidades

• Design, develop, and optimize complex SQL Server database solutions with efficient T-SQL code.
• Analyze execution plans, troubleshoot performance issues, and apply indexing/partitioning strategies.
• Model robust relational structures (OLTP/3NF) and analytics-ready schemas for reporting.
• Separate operational and reporting workloads to protect transactional systems.
• Define standards for naming, design, and documentation; lead code reviews.
• Mentor junior developers on SQL optimization and relational modelling; collaborate with BI teams and analysts.
• Support data ingestion and ETL/ELT pipelines and integrations as needed.

Conocimientos

T-SQL

SQL performance tuning

Data modeling

OLTP/3NF design

Partitioning

Indexing

ETL/ELT

Azure Data Factory

Azure SQL

CI/CD for databases

dbt

Git

BI tools

Herramientas

SSIS

Azure Data Factory

dbt

Azure DevOps

Git

Descripción del empleo

This is a remote position.

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

About our client

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 to take advantage of their hybrid in-office / remote benefit. This company places significant investment in employee wellness, their benefits which are on top of generous basic salaries, are industry leading in their generosity. Our client is large, offering fantastic career development opportunities but also very dynamic, they track as many metrics as possible in order to continuously improve - they spare no expense on the tools to do so. Automation, AI and R&D are pillars of their business framework which ensures you should never be at risk of falling behind or getting stuck working with old legacy software. Culturally they are very cosmopolitan and diverse, you will be working with the best globally.

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 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 modelling 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.

What our client is looking for

• 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 normalised relational models (3NF/OLTP), with a strong understanding of dimensional modelling (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.

Requirements

Data Engineering / Science, Azure Data Factory (ADF), ETL/ELT, Data Pipelines, SQL Queries, SQL Server, Data Modelling, BI Teams, Investment Advisory