Senior .NETSQL Technical Lead

Position: /SQL Technical Lead

Contract Length: 12 months

Extension: Potential for extension

Schedule: Hybrid 1 day on-site per week

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

We are seeking an experienced /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 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 /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 /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.

Required Experience:

Senior IC