M - 7/24 - 804326 - Sr SQL Developer - Richmond, VA (Hybrid - Local to Richmond candidates only)

Torrey Holistics; Richmond (VA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Torrey Holistics is seeking a Senior Microsoft SQL Developer to modernize and optimize SQL components in a critical Azure VM-based environment. You will collaborate with solution architects, cloud engineers, and API teams to ensure high performance and maintainability of the transaction platform.

You will drive database modernization efforts, implement ETL with SSIS and Databricks, and contribute to CI/CD pipelines using Azure DevOps and GitHub within an Agile framework.

Qualifications

• 7–10+ years of SQL Server development in enterprise environments.
• Advanced T-SQL development with query tuning and performance optimization.
• Experience developing SQL Server on Azure VM (IaaS).
• Hands-on HA support with AlwaysOn availability groups.
• Modernizing database code and schemas, including legacy SQL.
• Collaboration with .NET Core/C# teams for data access.
• CI/CD deployments via Azure DevOps and GitHub workflows.
• Experience modernizing SQL workloads in cloud environments.
• ETL development with SSIS and Databricks.

Responsibilities

• Develop and optimize T-SQL queries, procedures, functions and views to support new capabilities.
• Perform advanced performance tuning, indexing strategies and query optimization for a high‑transaction SQL environment.
• Modernize database components while accommodating legacy code and structures.
• Collaborate with .NET Core/C# developers to ensure efficient data access patterns.
• Support high availability using Always On and manage migrations/scripts and ETL logic.
• Develop CI/CD pipelines with Azure DevOps and GitHub for SQL deployments.
• Participate in Agile/Scrum ceremonies and deliver within sprint cycles.

Skills

SQL Server development

Advanced T-SQL

Azure SQL on VM

Always On availability groups

Database modernization

ETL with SSIS & Databricks

CI/CD with Azure DevOps & GitHub

Agile/Scrum

C# .NET integration

PCI compliance knowledge

Terraform / IaC

Tools

Azure DevOps

GitHub

SSIS

Databricks

Terraform

Job description

** Candidate will work a hybrid work schedule - 1 day or more on-site in Richmond, VA each week.Candidate must currently be local to Richmond, VA area – NO Relocation Allowed. Candidate must provide VA driver’s license as proof of residency. Candidates NOT located IN RICHMOND, VA area will NOT be considered and should not be submitted. **** In-Person interview Required. **** All remote work must be completed in the United States. **Our direct client has an opening for a Sr SQL Developer # 804326. This position is for 12+ months, with option of extension, and will be worked hybrid in Richmond, VA - 1 day or more on-site in Richmond, VA each week.If you are interested, please submit the following:YOUR CURRENT RESUMEYOUR HOURLY RATEBelow is the job description – Resumes due ASAP –Required/Desired Skills:SQL Server development experience in enterprise environments. - Required - 7 YearsAdvanced T-SQL development skills including query tuning and performance optimization - Required - 5 YearsExperience developing in SQL Server on Azure environments. - Required - 5 YearsHands-on experience supporting high availability architectures using Always On availability groups - Required - 5 YearsExperience modernizing database code and schemas, including legacy SQL support. - Required - 5 YearsExperience collaborating with .NET Core/C# development teams. - Required - 5 YearsExperience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines. - Required - 5 YearsAbility to work effectively within Agile/Scrum teams. - Required - 5 YearsExperience modernizing SQL workloads in cloud-hosted environments. - Required - 5 YearsExperience building ETL solutions using SSIS and Databricks. - Desired - 5 YearsKnowledge of PCI compliance and database security requirements. - Desired - 5 YearsExperience with Terraform or infrastructure-as-code to support SQL deployments. - Desired - 3 YearsExperience working with microservices architectures and domain-driven design. - Desired - 5 YearsKnowledge of scaling strategies for high-transaction SQL environments. - Desired - 5 YearsMinimum of 10 years of IT experience - Required - 10 YearsDescription:Position SummaryThe Senior Microsoft SQL Developer will support the modernization of anenterprise tolling transaction platform undergoing a partial rewrite usingmicroservices and modularization. This role is a critical part of theAgile/Scrum project team and is responsible for developing, optimizing, andmodernizing SQL components within a business-critical, high-availability SQLServer environment running on Azure Virtual Machines (IaaS). The developer willcollaborate with solution architects, cloud engineers, API developers, andtesters to ensure high performance, scalability, and maintainability of thedatabase platform, reporting to the Development Manager.Key ResponsibilitiesDevelop 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 Skills7–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 effectively within Agile/Scrum teams.Knowledge of PCI compliance and database security requirements.Preferred SkillsExperience with Terraform or infrastructure-as-code to support SQLdeployments.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.