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

Focused HR Solutions, LLC; Richmond (VA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Focused HR Solutions, LLC is seeking a Senior Microsoft SQL Developer to modernize and optimize a high-availability SQL Server environment on Azure. You will collaborate with solution architects, cloud engineers, API developers, and testers to ensure performance, scalability, and maintainability of the database platform.

The role emphasizes hands-on development, T-SQL optimization, and integration with .NET Core/C# projects within an Agile framework.

Qualifications

• 7–10+ years of SQL Server development experience in enterprise environments.
• Advanced T-SQL development with query tuning and performance optimization.
• Experience developing SQL Server on Azure VM (IaaS).
• Hands-on support for high availability using Always On.
• Modernizing database code and schemas, including legacy SQL support.
• Collaborating with .NET Core/C# development teams.
• Deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines.
• Ability to work effectively within Agile/Scrum teams.
• Modernizing SQL workloads in cloud-hosted environments.
• ETL solutions using SSIS and Databricks.
• Knowledge of PCI compliance and database security requirements.
• Terraform or IaC for SQL deployments.
• Microservices architectures and domain-driven design.
• Scaling strategies for high-transaction SQL environments.

Responsibilities

• Develop and optimize T-SQL queries, stored procedures, functions, and views to support new application capabilities.
• Perform advanced performance tuning, indexing, 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 modernization approach.
• Collaborate with .NET Core/C# developers to ensure efficient data access patterns and API/database integrations.
• Modernize database models to support modular, scalable architecture.
• 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.
• Contribute SQL-related changes through CI/CD pipelines using Azure DevOps and GitHub workflows.
• Participate in Agile ceremonies and deliver assigned work within sprints.

Skills

SQL Server development

T-SQL optimization

Azure SQL / Azure VM

Always On HA

ETL with SSIS/Databricks

CI/CD with Azure DevOps & GitHub

Agile/Scrum

Database modernization

SQL performance tuning

Cloud workloads modernization

Job description

• Candidate will work a hybrid work schedule - 1 day or more on-site in Richmond, VA each week.

• 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.

Required/Desired Skills

Below is the job description - Resumes due ASAP -

SQL Server development experience in enterprise environments. - Required - 7 Years

Advanced T-SQL development skills including query tuning and performance optimization - Required - 5 Years

Experience developing in SQL Server on Azure environments. - Required - 5 Years

Hands-on experience supporting high availability architectures using Always On availability groups - Required - 5 Years

Experience modernizing database code and schemas, including legacy SQL support. - Required - 5 Years

Experience collaborating with .NET Core/C# development teams. - Required - 5 Years

Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines. - Required - 5 Years

Ability to work effectively within Agile/Scrum teams. - Required - 5 Years

Experience modernizing SQL workloads in cloud-hosted environments. - Required - 5 Years

Experience building ETL solutions using SSIS and Databricks. - Desired - 5 Years

Knowledge of PCI compliance and database security requirements. - Desired - 5 Years

Experience with Terraform or infrastructure-as-code to support SQL deployments. - Desired - 3 Years

Experience working with microservices architectures and domain-driven design. - Desired - 5 Years

Knowledge of scaling strategies for high-transaction SQL environments. - Desired - 5 Years

Minimum of 10 years of IT experience - Required - 10 Years

Description

Position Summary

The 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 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 effectively within Agile/Scrum teams.
• Knowledge of PCI compliance and database security requirements.

Preferred Skills

• Experience 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.