Job Title: Senior Microsoft SQL Developer.
Location(s): Mechanicsville, VA
(Hybrid: Onsite 1 day per week)
Position SummaryWe are seeking a Senior Microsoft SQL Developer to support the modernization of a mission-critical enterprise transaction platform undergoing a partial rewrite using microservices and modular architecture. This role is responsible for developing, optimizing, and modernizing Microsoft SQL Server components within a high-availability Azure Virtual Machine (IaaS) environment. Working as part of an Agile/Scrum team, the developer will collaborate with architects, cloud engineers, application developers, and QA engineers to deliver scalable, secure, and high-performing database solutions.
Key Responsibilities- Develop, enhance, and optimize T-SQL queries, stored procedures, functions, and views.
- Perform SQL performance tuning, query optimization, indexing, and execution plan analysis.
- Modernize legacy SQL code and database structures while maintaining compatibility with existing applications.
- Support development of new features for a modern microservices-based application architecture.
- Collaborate with .NET Core/C# developers to implement efficient data access patterns and API integrations.
- Design and improve database schemas to support scalable, modular applications.
- Support high-availability SQL Server environments using Always On Availability Groups.
- Develop database migration scripts and ETL processes using SSIS and Databricks.
- Ensure compliance with PCI security standards and data retention requirements.
- Deploy database changes through Azure DevOps and GitHub CI/CD pipelines.
- Participate in Agile ceremonies including sprint planning, daily stand-ups, sprint reviews, and retrospectives.
- Document database designs, deployment procedures, and technical solutions.
Required Qualifications- 7-10+ years of Microsoft SQL Server development experience in enterprise environments.
- Advanced expertise in T-SQL development, including stored procedures, functions, views, and query optimization.
- Strong experience with SQL Server performance tuning and indexing strategies.
- Experience administering and developing SQL Server in Azure Virtual Machine (IaaS) environments.
- Hands-on experience with SQL Server Always On Availability Groups.
- Experience modernizing legacy SQL code and database schemas.
- Experience building ETL solutions using SSIS and Databricks.
- Experience collaborating with .NET Core/C# development teams.
- Experience deploying database changes using Azure DevOps and GitHub CI/CD pipelines.
- Experience working within Agile/Scrum development methodologies.
- Strong understanding of database security, PCI compliance, and data governance.
Preferred Qualifications- Experience with Terraform or other Infrastructure as Code (IaC) tools.
- Experience working with microservices architectures.
- Knowledge of Domain-Driven Design (DDD).
- Experience supporting high-volume, high-transaction database environments.
- Experience modernizing SQL Server workloads hosted in cloud environments.
Work Environment- Hybrid work schedule with one onsite day per week.
- Only local candidates will be considered.
Contract Details- 12-month contract with possible extension.
- Senior-level opportunity.
- Competitive hourly rate.
Skills:Skill Required / Desired Amount of Experience Expertise Rating Move SQL Server development experience in enterprise environments. Required 7 Years dvanced T-SQL development skills including query tuning and performance optimization Required 5 Years Experience developing in SQL Server on Azure environments. Required 5 Years Hands-on experience supporting high availability architectures using Always On availability groups Required 5 Years Experience modernizing database code and schemas, including legacy SQL support. Required 5 Years Experience collaborating with .NET Core/C# development teams. Required 5 Years Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines. Required 5 Years bility to work effectively within Agile/Scrum teams. Required 5 Years Experience modernizing SQL workloads in cloud-hosted environments. Required 5 Years Experience building ETL solutions using SSIS and Databricks. Desired 5 Years Knowledge of PCI compliance and database security requirements. Desired 5 Years Experience with Terraform or infrastructure-as-code to support SQL deployments. Desired 3 Years Experience working with microservices architectures and domain-driven design. Desired 5 Years Knowledge of scaling strategies for high-transaction SQL environments. Desired 5 Years Minimum of 10 years of IT experience Required 10 Years
