Senior .NET/SQL Technical Lead

Candidates should bring experience across several of the following technologies and concepts: NET / C# | SQL Server | T-SQL | Azure SQL | Azure IaaS | Azure Data Factory (ADF) | ETL | REST APIs | Microservices | Database Modernization | Data Migration | Performance Tuning | DevOps | CI/CD | Agile . The ideal candidate will be comfortable leading technical design discussions, developing and reviewing code, modernizing complex SQL environments, guiding experienced engineers, and collaborating across application development, database, QA, DevOps, cloud, and business teams.

Position: Senior .NET/SQL Technical Lead
Contract Length: 12 months

Extension: Potential for extension

Location: Mechanicsville, VA

Schedule: Hybrid –1 day on-site per week

Interview Process: May include virtual and/or on-site interviews

Pay Rate: $74.00 per hour on W2 

Important Note: Candidates must live near the work location and be able to consistently meet the on-site requirement.

Position Overview

We are seeking an experienced Senior .NET/SQL Technical Lead to provide hands-on technical leadership for a large-scale application and database modernization initiative.

This position combines .NET/C# backend development, advanced SQL Server engineering, microservices architecture, API integration, Azure SQL, and Azure Data Factory (ADF). The Technical Lead will play a key role in transforming a legacy, monolithic application and database environment into a modern, microservices-aligned architecture.

This is a hands-on technical leadership role, not a purely managerial one. The ideal candidate will be comfortable leading technical design discussions, developing and reviewing code, modernizing complex SQL environments, guiding experienced engineers, and collaborating across application development, database, QA, DevOps, cloud, and business teams.
Key Responsibilities

• 
  Lead collaborative technical design discussions involving microservices architecture, database modernization, API integration, and application design.
  
• 
  Provide hands-on SQL Server engineering, including database schema modernization, stored procedures, views, indexing, query optimization, and performance tuning.
  
• 
  Help decompose legacy monolithic database structures into modern schemas aligned with microservice boundaries.
  
• 
  Design, develop, and support .NET/C# backend services and REST APIs, including application services, integrations, and data-access components.
  
• 
  Provide technical leadership, mentorship, and direction to senior developers and engineering team members.
  
• 
  Participate in architecture discussions and help establish technical standards and modernization approaches.
  
• 
  Design and develop Azure Data Factory (ADF) pipelines supporting ETL, data migration, and transformation workloads.
  
• 
  Develop migration logic and strategies for transitioning data from legacy environments to modernized platforms.
  
• 
  Work with Azure SQL environments, including SQL Server running within Azure IaaS/VM environments.
  
• 
  Participate in code reviews, technical documentation reviews, solution-design reviews, and technical decision-making.
  
• 
  Collaborate with project leadership, technical SMEs, .NET and SQL developers, business analysts, QA, DevOps, and cloud engineering teams.
  
• 
  Identify technical risks, dependencies, performance concerns, and architectural challenges and help drive them toward resolution.
  
• 
  Ensure modernization efforts align with established security, compliance, data-retention, and audit requirements.
  
• 
  Support secure data-handling practices and compliance requirements within regulated environments.
  
• 
  Contribute to Agile ceremonies, planning activities, technical estimation, and overall project delivery.
  
• 
  Promote engineering best practices and help maintain consistent technical direction across the modernization initiative.
  

Required Qualifications

• 
  10+ years of overall IT/software engineering experience.
  
• 
  7+ years of SQL Server development experience.
  
• 
  7+ years of .NET/C# backend development experience.
  
• 
  Advanced hands-on experience with T-SQL, stored procedures, views, indexing, schema design, query optimization, and performance tuning.
  
• 
  5+ years of experience with Azure Data Factory (ADF) pipelines, ETL, and data migration workloads.
  
• 
  5+ years of experience working with Agile development and delivery teams.
  
• 
  3+ years of technical lead experience providing technical direction and guidance to engineering teams.
  
• 
  3+ years of application, database, or platform modernization/migration experience.
  
• 
  3+ years of experience with Azure SQL, including SQL Server hosted within Azure IaaS/VM environments.
  
• 
  Experience designing, developing, or supporting REST APIs and backend services.
  
• 
  Experience modernizing legacy applications and databases into more scalable, service-oriented architectures.
  
• 
  Strong understanding of relational database architecture, data-access patterns, and application integration.
  
• 
  Experience participating in technical design, architecture, code review, and engineering decision-making.
  
• 
  Strong problem-solving, troubleshooting, and analytical skills.
  
• 
  Excellent communication skills with the ability to work effectively across technical and non-technical teams.
  

Preferred Qualifications

• 
  2+ years of hands-on experience with microservices architecture concepts and design patterns.
  
• 
  Experience decomposing monolithic applications or databases into microservice-aligned components.
  
• 
  5+ years of experience working within regulated, audited, or compliance-driven environments.
  
• 
  Experience with security, audit, data-retention, or PCI-related requirements.
  
• 
  Experience supporting large-scale enterprise modernization initiatives.
  
• 
  Experience working within complex public-sector, transportation, financial, or similarly regulated technology environments.
  
• 
  Familiarity with modern DevOps, CI/CD, cloud, and automated deployment practices.
  

Technical Environment
Candidates should bring experience across several of the following technologies and concepts:

.NET / C# | SQL Server | T-SQL | Azure SQL | Azure IaaS | Azure Data Factory (ADF) | ETL | REST APIs | Microservices | Database Modernization | Data Migration | Performance Tuning | DevOps | CI/CD | Agile
Collaboration Environment
The Senior .NET/SQL Technical Lead will work as part of a cross-functional modernization team consisting of technical leadership, software developers, database engineers, business analysts, QA professionals, DevOps engineers, cloud engineers, and project leadership.

The Technical Lead will help maintain a unified technical direction across the team, facilitate technical decision-making, and ensure application and database modernization efforts remain aligned with project objectives, security standards, and delivery timelines.

The successful candidate should be comfortable working with both deeply technical team members and project/business stakeholders.
Key Deliverables & Measures of Success
Success in this role will include:

• 
  Modernized SQL database schemas aligned with microservices architecture and service boundaries.
  
• 
  High-quality and maintainable T-SQL objects, stored procedures, views, and database components.
  
• 
  Improved database and application performance through effective optimization and tuning.
  
• 
  Scalable and maintainable .NET/C# backend services and API integrations.
  
• 
  Successful ADF-driven data migration and ETL workflows.
  
• 
  Well-defined technical designs, architecture documentation, and technical decision records.
  
• 
  Effective code reviews and consistent engineering standards.
  
• 
  Strong collaboration across development, database, QA, DevOps, cloud, and project teams.
  
• 
  Identification and resolution of technical risks and dependencies.
  
• 
  Reliable delivery against modernization milestones, security requirements, and audit commitments.