Microsoft Developer at Niraah Solutions

About the position

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.