Senior SQL Developer - Azure, Always On & ETL

Ampcus, Inc

Mechanicsville (VA)

Hybrid

USD 82,656 - 123,984

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Ampcus Inc. is seeking a Senior Microsoft SQL Developer in Mechanicsville, VA, with hybrid work on-site one day per week.

The role focuses on modernizing Microsoft SQL Server components in an Azure IaaS environment, collaborating in an Agile/Scrum team of architects, cloud engineers, and QA to deliver scalable, secure database solutions. Responsibilities include tuning, schema design, ETL development with SSIS and Databricks, and deploying changes via Azure DevOps and GitHub CI/CD.

Qualifications

7-10+ years of Microsoft SQL Server development experience in enterprise environments.
Advanced expertise in T-SQL development, including stored procedures, functions, views, and query optimization.
Strong experience with SQL Server performance tuning and indexing strategies.
Experience administering and developing SQL Server in Azure Virtual Machine (IaaS) environments.
Hands-on experience with SQL Server Always On Availability Groups.
Experience modernizing legacy SQL code and database schemas.
Experience building ETL solutions using SSIS and Databricks.
Experience collaborating with .NET Core/C# development teams.
Experience deploying database changes using Azure DevOps and GitHub CI/CD pipelines.
Experience working within Agile/Scrum development methodologies.
Strong understanding of database security, PCI compliance, and data governance.

Responsibilities

Develop, enhance, and optimize T-SQL queries, stored procedures, functions, and views.
Perform SQL performance tuning, query optimization, indexing, and execution plan analysis.
Modernize legacy SQL code and database structures while maintaining compatibility with existing applications.
Support development of new features for a modern microservices-based application architecture.
Collaborate with .NET Core/C# developers to implement data access patterns and API integrations.
Design and improve database schemas to support scalable, modular applications.
Support high-availability SQL Server environments using Always On Availability Groups.
Develop database migration scripts and ETL processes using SSIS and Databricks.
Ensure PCI security standards and data retention requirements.
Deploy database changes through Azure DevOps and GitHub CI/CD pipelines.
Participate in Agile ceremonies including sprint planning, daily stand-ups, sprint reviews, and retrospectives.
Document database designs, deployment procedures, and technical solutions.