Technical Lead (.NET/SQL) Programmer Analyst 4

Technical Lead (.NET/SQL) Programmer Analyst 4The Virginia Department of Transportation (VDOT) is seeking a Technical Lead specializing in.NET and SQL to support its tolling modernization program. This senior-level role combines hands-on SQL Server and.NET engineering with technical leadership, database modernization, migration planning, and cross-team collaboration. The successful candidate will help modernize a monolithic database into microservice-aligned schemas, improve performance, support API development, and guide technical delivery.Lead technical design and engineering activities for VDOT's tolling modernization program. Help decompose a monolithic database into microservice-aligned schemas. Design, develop, and optimize SQL Server database objects, including schemas, stored procedures, views, and indexes. Support .NET/C# API development, backend services, and data access patterns. Build migration logic and data pipelines using Azure Data Factory (ADF). Ensure database modernization aligns with microservice boundaries, project requirements, and audit timelines. Participate in code reviews, documentation reviews, and technical decision-making. Coordinate with project leadership, subject matter experts, developers, business analysts, QA, DevOps, cloud, and CAB teams. Support PCI compliance, data retention, and secure data handling requirements. Contribute to Agile delivery workflows and successful project execution.Guide engineering team members and promote effective technical practices. Collaborate with the project manager/Scrum Master and veteran subject matter expert to maintain technical alignment. Troubleshoot technical issues and support database performance improvements. Review code and documentation for quality, consistency, and maintainability. Coordinate technical dependencies across project teams. Produce technical documentation and decision records. Support reliable migration workflows and delivery milestones.