Senior SQL Developer - Azure VM, ETL, PCI, Hybrid

Datasoft Technologies, Inc.; Mechanicsville (VA); Hybrid; USD 100,000 - 140,000; Full time

Benefits offered by this job

Paid Holidays/PTO

Medical/Dental Insurance

Accident/Critical Illness Insurance

Life Insurance

401(K)

Job summary

DataSoft Technologies seeks a Programmer Analyst 4 to enhance a mission-critical SQL Server platform in Azure IaaS. You will craft and optimize T-SQL, build ETL pipelines with SSIS and Databricks, and modernize database components within an Agile team.

The role requires 7–10+ years of enterprise SQL experience, collaboration with .NET Core/C# developers, and hands-on Always On availability. Hybrid onsite work 1 day/week in Mechanicsville, VA.

Qualifications

• 7–10+ years of SQL Server development in enterprise environments.
• Advanced T-SQL development including query tuning and performance optimization.
• Experience developing in SQL Server on Azure VM (IaaS) environments.
• Hands-on experience with high availability using Always On.
• Experience modernizing database code and schemas, including legacy SQL support.
• ETL design with SSIS and Databricks.
• Experience collaborating with .NET Core/C# teams.
• Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines.
• Ability to work effectively in Agile/Scrum teams.
• Knowledge of PCI compliance and database security requirements.

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

T-SQL

Azure VM (IaaS)

Always On

ETL (SSIS)

Databricks

.NET Core/C#

Azure DevOps

GitHub CI/CD

Agile/Scrum

PCI compliance

Tools

SSIS

Databricks

Terraform

Azure DevOps

CI/CD tooling

Job description

DataSoft Technologies seeks a Programmer Analyst 4 to enhance a mission-critical SQL Server platform in Azure IaaS. You will craft and optimize T-SQL, build ETL pipelines with SSIS and Databricks, and modernize database components within an Agile team.

The role requires 7–10+ years of enterprise SQL experience, collaboration with .NET Core/C# developers, and hands-on Always On availability. Hybrid onsite work 1 day/week in Mechanicsville, VA.