Senior SQL Developer

• Local to Richmond/Mechanicsville, VA only please
• This is a hybrid position with 1 day/week onsite
• We are not considering Corp - to - Corp (C2C) arrangements for this position

Description:

Our client is seeking an experienced Microsoft SQL Developer. 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.

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.

Skills:

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 Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration! #

ASTIT Job Type:

Contract Pay:

$70.00 - $75.00 per hour

Benefits:

401(k) Dental insurance Health insurance Vision insurance Application Question(s): Are you a U.S. Citizen or Permanent Resident? How many years of experience do you have with developing in SQL Server on Azure environments? How many years of experience do you have with deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines? How many years of experience do you have with building ETL solutions using SSIS and Databricks? How many years of hands-on experience do you have supporting high availability architectures using Always On availability groups? How many years of experience do you have with SQL Server development in enterprise environments?

Location:

Mechanicsville, VA 23116 (Required)

Work Location:

Hybrid remote in Mechanicsville, VA 23116