Senior Microsoft SQL Developer

Job Description

Title: Senior Microsoft SQL Developer

\n

Location: Mechanicsville, VA 23116 – Hybrid

\n

Onsite Requirement: 1 day per week

\n

Duration: 12 months, with possible extension

\n

\n

Work Authorization: USC / Green Card only Please provide DL COPY & PASSPORT NUMBER FOR GC CANDIDATES ONLY)

\n

Local Candidates Only

\n

Position Summary

\n

VDOT is seeking a Senior Microsoft SQL Developer / Microservices Technical Lead to support a tolling modernization program. This role requires strong hands-on experience with SQL Server, .NET/C#, Azure SQL, Azure Data Factory, and database modernization , along with technical leadership experience.

\n

The consultant will work closely with the PM/Scrum Master, SMEs, developers, QA, DevOps, Cloud, and other stakeholders to help decompose a monolithic database into microservice-aligned schemas and support application modernization.

\n

Key Responsibilities

\n

\n
• Lead technical design discussions for microservices, database restructuring, and API integrations .
\n
• Perform hands-on SQL development including:
\n
• Schema modernization
\n
• Stored procedures
\n
• Views
\n
• Indexing
\n
• Query optimization
\n
• Performance tuning
\n
• Support .NET/C# backend and API development as needed.
\n
• Guide engineering teams and provide technical leadership.
\n
• Work closely with SMEs and project leadership on architecture and delivery decisions.
\n
• Build migration logic and ETL pipelines using Azure Data Factory (ADF) .
\n
• Align SQL modernization efforts with microservice boundaries and migration timelines.
\n
• Participate in code reviews and technical documentation reviews.
\n
• Collaborate across SQL, .NET, BA, QA, DevOps, Cloud, and CAB teams .
\n
• Support compliance requirements including PCI, data retention, audit, and secure data handling .
\n
• Participate in Agile delivery activities and support project execution.
\n

\n

Required Qualifications

\n

\n
• 10+ years of overall IT experience.
\n
• 7+ years of Microsoft SQL Server development experience.
\n
• 5+ years of .NET / C# backend development experience.
\n
• 3–5 years of technical lead experience.
\n
• 3+ years of modernization or migration project experience.
\n
• 3+ years of experience with Azure SQL in IaaS VM environments .
\n
• 3+ years of experience building Azure Data Factory (ADF) pipelines and supporting ETL workloads.
\n
• 3+ years of experience working with Agile delivery teams.
\n
• Strong experience with SQL performance tuning, schema design, stored procedures, views, indexing, and data migration.
\n
• Strong communication and cross-functional collaboration skills.
\n

\n

Preferred Qualifications

\n

\n
• 2+ years of state government or transportation industry experience.
\n
• 2+ years working in regulated or audited environments.
\n
• 2+ years of exposure to microservices architecture.
\n
• Experience with PCI or other compliance-driven environments.
\n

\n