VDOT Technical Lead (.Net/SQL) Programmer Analyst 4

**Job Title: Senior Microsoft SQL Developer

Job Location: Mechanicsville, VA 23116 (Hybrid)

Job Duration: 12 months

This role follows a hybrid work schedule requiring the developer to be onsite 1day per week. Only local candidates will be considered for this position.** Job Summary:

• The Microservices Technical Lead (SQL/.NET) supports the tolling modernization program by providing functional leadership, hands-on SQL and .NET engineering, and collaborative solution design.
• This individual partners closely with the PM/Scrum Master, veteran SME, and technical team to decompose the monolithic database into microservice-aligned schemas. The role includes SQL engineering, architecture participation, code reviews, documentation reviews, and strong cross-team collaboration.

Job Responsibilities:

• Lead collaborative technical design discussions for microservices, database restructuring, and API integration.
• Provide hands-on SQL engineering including schema modernization, stored procedures, views, indexing, and performance tuning.
• Support .NET API development as needed, including backend services and data access patterns.
• Guide senior engineering talent with strong,engaging technical leadership.
• Collaborate with the PM/Scrum Master to support project execution and decision-making.
• Work closely with the veteran SME for technical alignment and domain expertise.
• Build migration logic and data pipelines using Azure Data Factory (ADF).
• Ensure SQL modernization aligns with microservice boundaries and audit timelines.
• Participate in code reviews and documentation reviews.
• Collaborate with .NET, SQL, BA, QA, DevOps, Cloud, and CAB teams for cohesive delivery.
• Support compliance requirements including PCI, retention rules, and secure data handling.
• Operate effectively within delivery workflows and agile components as needed.

Required Skills:

• 10+ years of overall IT experience.
• 7+ years of SQL Server development experience.
• 5+ years of .NET/C# backend development experience.
• 3–5 years of technical lead experience guiding engineering teams.
• 3+ years of modernization or migration project experience.
• 3+ years of experience with Azure SQL on IaaS VM environments.
• 3+ years of experience building ADF pipelines and supporting ETL workloads.
• 3+ years of experience supporting delivery and agile teams.

Preferred Skills:

• 2+ years of experience in state government or transportation-related environments.
• 2+ years working in regulated or audited environments.
• 2+ years of exposure to microservices architecture concepts.

Collaboration Environment:

• This role partners closely with a full modernization project team including the PM/Scrum Master, veteran SME, .NET and SQL Developers, Business Analyst, QA, DevOps Engineer, and Cloud Engineer.
• The Lead ensures unified technical direction, promotes modernization, and supports adherence to audit timelines.

Deliverables & Success Metrics:

• Modernized SQL schemas aligned with microservice boundaries.
• High-quality T-SQL objects, optimized code, and improved performance.
• Collaborative design documentation and technical decision records.
• Successful ADF-driven migration workflows.
• Clear and consistent collaboration with PM/SM, SME, and project team.
• Positive influence on engineering culture and project momentum.
• Reliable delivery aligned with modernization timelines and audit commitments.

Skills Matrix:

• SQL Server development experience Required 7 Years
• .NET/C# backend development experience. Required 7 Years
• Experience supporting delivery and agile teams. Required 5 Years
• Technical lead experience guiding engineering teams. Required 3 Years
• Modernization or migration project experience. Required 3 Years
• Experience with Azure SQL on IaaS VM environments. Required 3 Years
• Experience building ADF pipelines and supporting ETL workloads. Required 5 Years
• Minimum of 10 years of IT experience Required 10 Years
• Experience in state government or transportation-related environments. Highly desired 2 Years
• Working in regulated or audited environments. Desired 5 Years
• Expertise with microservices architecture concepts. Desired 2 Years