> Markdown version of [/jobs/ext/1821044-technical-lead-ii_microsoft-sql-server](https://www.wearedevelopers.com/jobs/ext/1821044-technical-lead-ii_microsoft-sql-server). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Technical Lead - II_Microsoft SQL Server

- **Company:** SR Partners LLC
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Microsoft Azure, Big Data, Cloud Computing, Cloud Database, Code Review, Databases, Information Engineering, Data Infrastructure, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Systems, Data Warehousing, Database Development, Database Security, Dimensional Modeling, Apache Hive, Microsoft SQL Server, SQL Azure, Performance Tuning, Query Optimization, SQL Stored Procedures, SQL Databases, Transact-SQL, Database Optimization, Apache Spark, Data Lakes, Pyspark, Data Pipelines, Databricks
- **Published:** July 31, 2026
- **Apply:** https://www.dice.com/job-detail/cdfa94bd-ff81-4839-b71e-151d49cbffc7

## About the Role

10+ years of experience as a Database Developer or similar role.

Strong expertise in SQL Server and Azure SQL.

Advanced proficiency in T-SQL, including performance tuning and query optimization.

Hands-on experience with Databricks and Apache Spark.

Solid understanding of data warehousing concepts, dimensional modeling, and SCD.

Experience working in Azure cloud environments. Strong analytical, problem-solving, and communication skills. "

## Description

Microsoft SQL Server SQL, Azure SQL, Azure DataBricks SQL Administrator "Job Summary We are seeking a highly skilled Senior Database Developer with deep expertise in SQL Server and Azure SQL and hands-on experience with Databricks to design, develop, optimize, and maintain scalable data solutions. The ideal candidate will play a key role in building performant data models, supporting analytics and reporting needs, and collaborating with data engineers, analysts, and application teams in a cloud-based environment., Design, develop, and maintain complex SQL Server and Azure SQL databases.

Write and optimize advanced T-SQL queries, stored procedures, functions, and views.

Perform query tuning, indexing strategies, and performance optimization for large-scale datasets.

Implement best practices for database security, data integrity, and reliability. Cloud & Data Platform

Develop and manage data solutions in Azure SQL Database.

Work with Databricks (Apache Spark) to support data transformations, analytics, and large-scale data processing.

Integrate Azure SQL with Databricks using Delta Lake, Spark SQL, and PySpark/SQL where applicable.

Support cloud-based data architectures and hybrid data environments. Data Modeling & Warehousing

Design and maintain relational and dimensional data models.

Implement Slowly Changing Dimensions (SCD) and other data warehousing patterns.

Support ETL/ELT processes and collaborate with data engineering teams. Collaboration & Leadership

Partner with application developers, data engineers, BI teams, and stakeholders to understand data requirements.

Provide guidance and mentoring to junior developers.

Participate in code reviews and enforce database development standards.

Troubleshoot production issues and provide root cause analysis.


## Related Videos

- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)

## Related Articles

- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)