Job Title: Senior Microsoft SQL Developer - Azure SQL & Database Modernization
Location: Mechanicsville, VA 23116
Employment Type: Contract
Work Model: Hybrid (Minimum
1 day/week onsite)
Interview Process: Phone and In-Person Interview
Important Requirements
- Only local Virginia candidates will be considered.
- Hybrid schedule requiring 1 day per week onsite in Mechanicsville, VA.
Job Summary
Client is seeking an experienced
Senior Microsoft SQL Developer to support the modernization of a mission-critical enterprise tolling transaction platform. This role focuses on modernizing SQL Server components within a high-availability Azure environment while supporting a microservices-based architecture. The ideal candidate will have deep expertise in SQL Server, T-SQL optimization, Azure SQL environments, ETL development, high availability, CI/CD, and Agile software development.
Key Responsibilities
- Develop, enhance, and optimize T-SQL queries, stored procedures, functions, and views.
- Perform advanced SQL performance tuning, indexing, and query optimization.
- Modernize existing SQL code, database schemas, and legacy database components.
- Support application modernization initiatives using microservices and modular architecture.
- Collaborate with .NET Core/C# developers to optimize API and database integrations.
- Design and maintain scalable SQL Server database models.
- Support high availability environments using SQL Server Always On Availability Groups.
- Develop migration scripts, ETL solutions, and data integration processes using SSIS and Databricks.
- Implement PCI-compliant database security and data retention strategies.
- Deploy SQL database updates using Azure DevOps and GitHub CI/CD pipelines.
- Participate in Agile/Scrum ceremonies, sprint planning, and iterative development.
- Work closely with Solution Architects, Cloud Engineers, QA teams, and Development Managers.
Required Skills & Qualifications
- Minimum 10 years of overall IT experience.
- 7+ years of enterprise Microsoft SQL Server Development experience.
- 5+ years of advanced T-SQL development, query tuning, and performance optimization.
- 5+ years of experience developing SQL Server solutions in Microsoft Azure environments.
- 5+ years supporting Always On Availability Groups and high-availability architectures.
- 5+ years modernizing SQL database code, schemas, and legacy database applications.
- 5+ years collaborating with .NET Core/C# development teams.
- 5+ years deploying SQL solutions using Azure DevOps and GitHub CI/CD pipelines.
- 5+ years working within Agile/Scrum development environments.
- Strong experience supporting cloud-hosted SQL Server workloads.
Desired Skills
- 5+ years building ETL solutions using SSIS and Databricks.
- Knowledge of PCI compliance and enterprise database security.
- Experience with Terraform or Infrastructure as Code (IaC).
- Experience with Microservices Architecture and Domain-Driven Design (DDD).
- Knowledge of scaling strategies for high-transaction SQL Server environments.
- Experience modernizing enterprise SQL workloads in cloud environments.
Required Skill Matrix
๎
Skill
Required/Desired
Your Experience
SQL Server Development (Enterprise Environment)
7+ Years Required
Advanced T-SQL Development, Query Tuning & Performance Optimization
5+ Years Required
SQL Server Development in Microsoft Azure
5+ Years Required
Always On Availability Groups / High Availability
5+ Years Required
Database Modernization & Legacy SQL Support
5+ Years Required
Collaboration with .NET Core/C# Development Teams
5+ Years Required
Azure DevOps & GitHub CI/CD Pipelines
5+ Years Required
Agile / Scrum Development
5+ Years Required
Cloud-Hosted SQL Workload Modernization
5+ Years Required
SSIS & Databricks ETL Development
5+ Years Desired
PCI Compliance & Database Security
5+ Years Desired
Terraform / Infrastructure as Code
3+ Years Desired
Microservices Architecture & Domain-Driven Design
5+ Years Desired
High-Transaction SQL Scaling Strategies
5+ Years Desired
Overall IT Experience
10+ Years Required