Senior SQL Developer (Azure CI/CD) – Hybrid

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

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