Senior Microsoft SQL Developer at Asterism IT Solutions LLC Senior Microsoft SQL Developer at Asterism IT Solutions LLC in Mechanicsville, Virginia Posted in 10 days ago.

Type:

full-time

Title:

Senior Microsoft SQL Developer Location:

Mechanicsville, VA 23116 -

Hybrid Onsite Requirement:

1 day per week

Duration:

12 months, with possible extension

Work Authorization:

USC / Green Card only Please provide

DL COPY & PASSPORT NUMBER FOR GC CANDIDATES ONLY

) Local Candidates Only Position Summary 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. 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. Key Responsibilities Lead technical design discussions for microservices, database restructuring, and API integrations .

Perform hands-on SQL development including:

Schema modernization Stored procedures Views Indexing Query optimization Performance tuning Support .NET/C# backend and API development as needed. Guide engineering teams and provide technical leadership. Work closely with SMEs and project leadership on architecture and delivery decisions. Build migration logic and ETL pipelines using Azure Data Factory (ADF) . Align SQL modernization efforts with microservice boundaries and migration timelines. Participate in code reviews and technical documentation reviews. Collaborate across SQL, .NET, BA, QA, DevOps, Cloud, and CAB teams . Support compliance requirements including PCI, data retention, audit, and secure data handling . Participate in Agile delivery activities and support project execution. Required Qualifications 10+ years of overall IT experience. 7+ years of Microsoft SQL Server development experience. 5+ years of .NET / C# backend development experience. 3-5 years of technical lead experience. 3+ years of modernization or migration project experience. 3+ years of experience with Azure SQL in IaaS VM environments . 3+ years of experience building Azure Data Factory (ADF) pipelines and supporting ETL workloads. 3+ years of experience working with Agile delivery teams. Strong experience with SQL performance tuning, schema design, stored procedures, views, indexing, and data migration. Strong communication and cross-functional collaboration skills. Preferred Qualifications 2+ years of state government or transportation industry experience. 2+ years working in regulated or audited environments. 2+ years of exposure to microservices architecture. Experience with PCI or other compliance-driven environments.