TT
VDOT Technical Lead (.Net/SQL) Programmer Analyst 4
Talent Technical Services, Inc
- 🇺🇸 United States
- Hybrid
- Staff / Principal
- 1 day ago
- $75 – $90 / hour
- Microservices
- SQL
- .NET
- Azure Data Factory
- Devops
- Agile
- C#
- Azure SQL
- ETL
- T-SQL
1 day ago
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.
- 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.
- 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.
- 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, DevOps Engineer, and Cloud Engineer.
- The Lead ensures unified technical direction, promotes modernization, and supports adherence to audit 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
VDOT Technical Lead (.Net/SQL) Programmer Analyst 4 · Talent Technical Services, Inc