Technical Lead (.Net​/SQL) Programmer Analyst – Position

Contract Length: 12 months, with possible extension based on performance and project need. This role follows a hybrid work schedule requiring the developer to be onsite at leasdt 1 day per week.

Only local Richmond, VA candidates will be considered for this position.

The Microservices Technical Lead (SQL/.NET) supports the tolling modernization program by providing functional leadership, hands-on SQLand .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.

• 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, Dev Ops,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.

• 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 andagile teams.

• 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.

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

• 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.

• 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