Job Description
Position: SQL Developer (Ref: 18553)
Location: Mechanicsville, VA USA, 23116
Salary: DOE
Duration: 11 Months 4 Days - Contract
Openings: 1
Deadline: 07/31/2026
Description:
Work Arrangement: Hybrid (Onsite 1 day per week)
Location: Mechanicsville, VA area
Local candidates only
We are seeking a Senior Microsoft SQL Developer to support the modernization of an enterprise tolling transaction platform undergoing a partial rewrite using microservices and modularization.
In this role, you will be a critical part of an Agile/Scrum project team, responsible for developing, optimizing, and modernizing SQL components within a business-critical, high-availability SQL Server environment hosted on Azure Virtual Machines (IaaS). You will work closely with solution architects, cloud engineers, API developers, and QA testers to ensure high performance, scalability, and maintainability of the database platform.
Key Responsibilities
T-SQL Development & Optimization: Write and tune complex T-SQL queries, stored procedures, functions, and views to support new application capabilities and high-transaction workloads.
Performance Tuning: Perform advanced performance tuning, indexing strategies, and query optimization in a business-critical SQL Server environment.
Modernization & Support: Modernize existing SQL components and database models to support modular, scalable architecture while maintaining legacy SQL code and structures.
Integration & Microservices: Collaborate with .NET Core/C# developers to implement efficient data access patterns and seamless API/database integrations.
ETL & Data Pipelines: Build and support data migration scripts, ETL logic, and integration solutions using SSIS and Databricks.
High Availability & Security: Maintain high-availability environments using Always On Availability Groups, ensure PCI compliance, and enforce data retention rules.
DevOps Integration: Deploy SQL database updates via CI/CD pipelines utilizing Azure DevOps and GitHub workflows.
Qualifications & Required Experience
7+ Years of enterprise-level SQL Server development experience.
Azure IaaS Experience: Hands-on experience developing and maintaining SQL Server running on Azure VMs.
High Availability: Proven experience supporting High Availability architectures (Always On Availability Groups).
Modernization & Legacy Code: Experience refactoring and modernizing legacy database code and schemas for microservices/domain-driven architectures.
ETL Expertise: Hands-on experience developing ETL solutions using SSIS and Databricks.
Development Collaboration: Strong background collaborating with .NET Core/C# development teams.
CI/CD Pipelines: Experience delivering database updates using Azure DevOps or GitHub workflows.
Compliance & Security: Knowledge of PCI compliance standards and database security protocols.
Agile Workflows: Strong familiarity working within Agile/Scrum sprint frameworks.
Preferred Skills
Infrastructure as Code (IaC) experience using Terraform for SQL deployments.
Experience with scaling strategies in high-transaction environments.
Required / Desired Skills
SQL Server development experience in enterprise environments. Required - 7 Years
Advanced 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
Ability 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. Required - 5 Years
Knowledge of PCI compliance and database security requirements. Required - 5 Years
Experience with Terraform or infrastructure-as-code to support SQL deployments. Required - 3 Years
Experience working with microservices architectures and domain-driven design. Required - 5 Years
Knowledge of scaling strategies for high-transaction SQL environments. Required - 5 Years
IT experience Required - 10 Years