CI/CD GitHub Azure DevOps SQL Server C# Analyst

COOLSOFT; Mechanicsville (VA); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

COOLSOFT in Mechanicsville, VA is seeking a Senior Microsoft SQL Developer to modernize an enterprise tolling platform. You will develop, optimize, and modernize SQL components within a high-availability SQL Server environment on Azure VMs, collaborating with solution architects, cloud engineers, API developers, and testers to ensure performance and scalability.

The role emphasizes Agile/Scrum practices and requires 7-10 years of SQL Server experience, T-SQL optimization, and expertise with

Qualifications

• 7-10 years of SQL Server development experience in enterprise environments.
• Advanced T-SQL development skills including query tuning and performance optimization.
• Experience developing in SQL Server on Azure VM (IaaS) environments.
• Hands-on experience supporting high availability architectures using AlwaysOn availability groups.
• Experience modernizing database code and schemas, including legacy SQL support.
• Experience building ETL solutions using SSIS and Databricks.
• Experience collaborating with .NET Core/C# development teams.
• Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines.
• Ability to work effectively within Agile/Scrum teams.
• Knowledge of PCI compliance and database security requirements.

Responsibilities

• Develop and optimize T-SQL queries, stored procedures, functions, and views to support new application capabilities.
• Perform advanced performance tuning, indexing strategies, and query optimization for a business-critical SQL environment.
• Modernize existing SQL components while supporting legacy SQL code and structures.
• Support new feature development aligned with the microservices-based application modernization approach.
• Collaborate with .NET Core/C# developers to ensure efficient data access patterns and API/database integrations.
• Participate in modernizing existing database models to support modular, scalable architecture.
• Support and maintain high availability environments using Always On availability groups.
• Develop migration scripts, ETL logic, and integration solutions using SSIS and Databricks.
• Ensure PCI compliance requirements are followed and implement data retention rules as required.
• Contribute SQL-related changes through CI/CD pipelines using Azure DevOps and GitHub workflows.

Skills

Agile / SCRUM

CI/CD

GitHub

Azure DevOps

SQL Server

C#

Tools

SSIS

Databricks

Azure VM

Job description

CI/CD GitHub Azure DevOps SQL Server C# Analyst

(Jobs in Mechanicsville, VA)

Requirement id 158725

Job title Analyst

Job location in Mechanicsville, VA

Skills required Agile / SCRUM, CI/CD, GitHub, Azure DevOps SQL Server C#

Open Date 24-Jul-2026

Close Date

Job type Contract

Duration 11 Months

Compensation DOE

Status requirement ---

Job interview type ---

Email Recruiter:coolsoft

Job Description Analyst: Agile / SCRUM, CI/CD, GitHub, Azure DevOps SQL Server C#

Start date : 08/03/2026

End Date : 06/30/2027

Submission deadline:

Client Info : VDOT

Note:

*Agency Interview Type:Both Phone and In Person

*Work Arrangement:Hybrid

Description:

The Senior Microsoft SQL Developer will support the modernization of an enterprise tolling transaction platform undergoing a partial rewrite using micro services and modularization. This role is a critical part of the Agile/Scrum project team and is responsible for developing, optimizing, and modernizing SQL components within a business-critical, high-availability SQL Server environment running on Azure Virtual Machines (IaaS). The developer will collaborate with solution architects, cloud engineers, API developers, and testers to ensure high performance, scalability, and maintainability of the database platform, reporting to the Development Manager.

Key Responsibilities:

• Develop and optimize T-SQL queries, stored procedures, functions, and viewsto support new application capabilities.
• Perform advanced performance tuning, indexing strategies, and queryoptimization for a business-critical SQL environment.
• Modernize existing SQL components while supporting legacy SQL code andstructures.
• Support new feature development aligned with the microservices-basedapplication modernization approach.
• Collaborate with .NET Core/C# developers to ensure efficient data accesspatterns and API/database integrations.
• Participate in modernizing existing database models to support modular,scalable architecture.
• Support and maintain high availability environments using Always Onavailability groups.
• Develop migration scripts, ETL logic, and integration solutions using SSISand Databricks.
• Ensure PCI compliance requirements are followed and implement data retention rules as required.
• Contribute SQL-related changes through CI/CD pipelines using Azure DevOps and GitHub workflows.
• Participate in Agile ceremonies and deliver assigned work within established sprint cycles.

Required Skills:

• 7--10 years of SQL Server development experience in enterprise environments.
• Advanced T-SQL development skills including query tuning and performanceoptimization.
• Experience developing in SQL Server on Azure VM (IaaS) environments.
• Hands-on experience supporting high availability architectures using AlwaysOn availability groups.
• Experience modernizing database code and schemas, including legacy SQLsupport.
• Experience building ETL solutions using SSIS and Databricks.
• Experience collaborating with .NET Core/C# development teams.
• Experience deploying SQL updates through Azure DevOps and GitHub CI/CDpipelines.
• Ability to work effective within Agile/Scrum teams.
• Knowledge of PCI compliance and database security requirements.

Preferred Skills:

• Experience with Terraform or infrastructure-as-code to support SQL deployments.
• Experience working with microservices architectures and domain-driven design.
• Knowledge of scaling strategies for high-transaction SQL environments.
• Experience modernizing SQL workloads in cloud-hosted environments.

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.

Call502-379-4456 Ext 100for more details. Please provide Requirement id: 158725 while calling.

EOE Protected Veterans/Disability