MS SQL Server Developer
Company: Niraah Solutions
Location: City of Johannesburg, Gauteng (Hybrid)
Type: Full-time / Contract | Level: Mid-Senior
Domain: Banking / Financial Services
About the role
We’re hiring an on-prem MS SQL Server Developer to build high-quality databases and ETL processes, design data warehouses, and optimise performance across mission-critical SQL Server environments.
Key responsibilities
- Database development & optimisation: Design schemas, write T-SQL (procedures, functions, triggers), tune queries, indexing, partitions, and troubleshoot performance.
- ETL/ELT: Build and maintain SSIS packages (incremental/delta loads, error handling, scheduling via SQL Agent); ensure data quality and reconciliation.
- Data warehousing & BI: Implement star/snowflake models, data marts; develop SSRS reports and (nice to have) SSAS tabular/multidimensional; support Power BI dashboards.
- Controls & deployment: Apply RBAC and data governance; contribute to version control and basic CI/CD for database changes.
Required skills & experience
- Strong SQL Server (2012-2019+) and T-SQL expertise.
- Proven SSIS experience for file/database integrations.
- Hands-on performance tuning (execution plans, stats, indexing).
- Data modelling (Kimball) and warehouse design.
- Experience in banking/financial data environments.
Nice to have
- SSAS (tabular/multidimensional), SSRS, Power BI.
- Teradata exposure.
- DevOps basics (Git, pipelines), PowerShell scripting.
- Certifications (e.g., MCSA/MCSE: SQL Server, Azure Fundamentals/Data-optional).
Eligibility
?? Only candidates with valid South African work authorisation or permanent residency will be considered.
Apply
Email your CV to [Email Address Removed] with subject “MS SQL Server Developer – Johannesburg” and include notice period and availability.
Desired Skills:
- MS SQL
- MS SQL Server
- tsql
- SSIS
- database modelling
- stored procdures
- performance tuning
- triggers
- Data Warehousing
- Banking
- Visual Studio
Desired Work Experience:
- 5 to 10 years
Desired Qualification Level:
- Degree
About The Employer:
Niraah Solutions (Pty) Ltd is a South Africa-based technology consulting and services company with delivery teams in South Africa and India. We specialize in Enterprise Architecture, Data Analytics, AI & Automation, Cloud, and Human Capital Solutions for banking, financial, and enterprise clients. Our focus is on delivering intelligent, scalable, and cost-effective technology solutions that drive measurable business value through innovation, strategy, and execution.