Senior Microsoft SQL Developer

Key Responsibilities

·         Lead collaborative technical design discussionsfor microservices, database restructuring, and API integration.

·         Provide hands-on SQL engineering includingschema modernization, stored procedures, views, indexing, and performancetuning.

·         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 supportproject execution and decision-making.

·         Work closely with the veteran SME for technicalalignment and domain expertise.

·         Build migration logic and data pipelines usingAzure Data Factory (ADF).

·         Ensure SQL modernization aligns withmicroservice boundaries and audit timelines.

·         Participate in code reviews and documentationreviews.

·         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 workflowsand agile components as needed.

Required Skills

·         10 years of overall IT experience.

·         7 years of SQL Server development experience.

·         5 years of .NET/C# backend developmentexperience.

·         3–5 years of technical lead experience guidingengineering teams.

·         3 years of modernization or migration projectexperience.

·         3 years of experience with Azure SQL on IaaS VMenvironments.

·         3 years of experience building ADF pipelinesand supporting ETL workloads.

·         3 years of experience supporting delivery andagile teams.

Preferred Skills

·         2 years of experience in state government ortransportation-related environments.

·         2 years working in regulated or auditedenvironments.

·         2 years of exposure to microservicesarchitecture concepts.

Collaboration Environment

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

Deliverables & Success Metrics

·         Modernized SQL schemas aligned with microserviceboundaries.

·         High-quality T-SQL objects, optimized code, andimproved 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.

Work Environment & Arrangement

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.

• Contract Length: 12 months, with possible extension.

• CAI Skill Level: Level 4 (Senior Developer).

Salary : $70 - $75