Sr. Microsoft SQL Developer

Accylerate; Mechanicsville (VA); On-site; USD 90,000 - 130,000; Full time

Job summary

Accylerate is seeking a Sr. Microsoft SQL Developer to support modernization of a tolling platform. The role centers on T-SQL, performance tuning, and database modernization within a high-availability SQL Server environment on Azure VM (IaaS).

The candidate will work with solution architects, cloud engineers, API developers, and testers to ensure scalable, secure data access and CI/CD deployments via Azure DevOps and GitHub within an Agile/Scrum setting.

Qualifications

• 7–10+ years of SQL Server development experience in enterprise environments.
• Advanced T-SQL development including query tuning and performance optimization.
• Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines.
• Experience on SQL Server in Azure VM (IaaS) environments.
• Experience with Always On availability groups and high-availability architectures.

Responsibilities

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

Skills

T-SQL

Query tuning

Performance optimization

High availability

Azure VM (IaaS)

Collaboration with .NET/C# teams

Agile/Scrum

Tools

SSIS

Databricks

Azure DevOps

GitHub CI/CD

Job description

Title: Sr. Microsoft SQL Developer

Duration: 12 Months Extendable

Location: Mechanicsville, VA 23116

Ideal Candidate Profile:

Seeking a Sr. Microsoft SQL Developer who 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.

Job Duties & 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.
• Participate in Agile ceremonies and deliver assigned work within established sprint cycles.

Required Skills & 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 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/CD pipelines.
• Ability to work effectively 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.