Senior Microsoft SQL Developer

Creative Solutions Services, LLC; Mechanicsville (VA); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Creative Solutions Services, LLC in Mechanicsville, VA is seeking a Senior Microsoft SQL Developer to support modernization of an enterprise tolling platform. You will develop, optimize, and modernize T-SQL components in a high-availability SQL Server on Azure VM, collaborating with solution architects, cloud engineers, API developers, and testers.

This role requires 10+ years IT, 7–10+ years SQL Server, and strong experience with Always On, SSIS, Databricks, and CI/CD via Azure DevOps and

Qualifications

• Minimum of 10 years of IT experience.
• 7–10+ years of SQL Server development in enterprise environments.
• Advanced T-SQL development and performance tuning.
• Experience SQL Server on Azure VM (IaaS).
• Hands-on Always On availability groups support.
• Modernizing database code and schemas incl. legacy SQL.
• ETL development using SSIS and Databricks.
• Collaborating with .NET Core/C# teams.
• CI/CD deployment via Azure DevOps & GitHub.
• Experience in Agile/Scrum environments.
• Cloud-based, high-availability SQL workloads.

Responsibilities

• Develop and optimize T-SQL queries, procedures, functions, and views.
• Perform performance tuning with indexing and query optimization.
• Modernize SQL components while supporting legacy code.
• Support new features aligned with microservices modernization.
• Collaborate with .NET Core/C# developers for data access.
• Modernize database models for modular, scalable architecture.
• Maintain high availability using Always On availability groups.
• Create migration scripts, ETL logic, and integration via SSIS/Databricks.
• Ensure PCI compliance and data retention rules.
• Share SQL changes through CI/CD pipelines using Azure DevOps and GitHub.
• Participate in Agile ceremonies and deliver within sprints.

Skills

T-SQL

SQL Server

Azure VM SQL

Performance tuning

Always On

SSIS ETL

Databricks

CI/CD

Azure DevOps

GitHub CI/CD

Agile/Scrum

Tools

Azure DevOps

GitHub

Databricks

SSIS

Job description

Title: Senior Microsoft SQL Developer

Location: Mechanicsville, VA - Hybrid

Duration: 12 months, with possible extension.

Interview: Both Phone & In-person

Note:

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.

Position Summary

The Senior Microsoft SQL Developer will support the modernization of an enterprise tolling transaction platform undergoing a partial rewrite using microservices 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 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.
• Participate in Agile ceremonies and deliver assigned work within established sprint cycles.

Required Skills

• Minimum of 10 years of IT experience
• 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 Always On 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.
• Experience modernizing SQL workloads in cloud-hosted environments.

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.
• Knowledge of PCI compliance and database security requirements.