Senior Microsoft SQL Developer

Astyra Corporation; Mechanicsville (VA); Hybrid; USD 95,000 - 120,000; Full time

Job summary

Astyra Corporation in Mechanicsville, VA is seeking a Senior Microsoft SQL Developer for a 1-year contract with possible extension. This hybrid role requires local presence in Mechanicsville, VA and excludes Corp-to-Corp arrangements.

The candidate will lead SQL/.NET efforts, modernize databases into microservice-aligned schemas, and collaborate with cross-functional teams to deliver secure, compliant data solutions.

Qualifications

• 10+ years IT experience with SQL Server and .NET
• Strong background in SQL Server development and API data access
• Experience leading engineering teams in delivery and modernization projects
• Familiar with Azure SQL on IaaS and ADF pipelines
• Knowledge of regulated/audited environments and PCI-like controls

Responsibilities

• Lead technical design discussions for microservices database restructuring.
• Provide hands-on SQL engineering: schema modernization, procedures, views, indexing.
• Assist .NET API development with data access patterns.
• Mentor senior engineers and drive technical leadership across teams.
• Collaborate with PM/Scrum Master to support project execution and decisions.
• Coordinate with SME and cross-functional teams for aligned delivery.
• Develop migration logic and data pipelines using Azure Data Factory.
• Ensure modernization aligns with microservice boundaries and audit timelines.
• Participate in code reviews and documentation reviews.

Skills

SQL Server

C# / .NET

Agile / Delivery

Technical Leadership

Modernization / Migration

Azure SQL IaaS

ADF ETL pipelines

IT Experience 10+ years

State gov / transportation

Regulated environments

Microservices concepts

Job description

Senior Microsoft SQL Developer

*This is a 1-year contract position with possible extension

*Hybrid – Local to Mechanicsville, VA only, please

*We are not considering Corp-to-Corp (C2C) arrangements for this position

Description

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.

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.

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.

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/Knowledge/Experience

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

Required Skills / Knowledge / Experience

• 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