Senior SQL Developer — Hybrid in Richmond, VA

Focused HR Solutions, LLC

Richmond (VA)

Hybrid

USD 120,000 - 150,000

Full time

3 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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.