Senior Microsoft SQL Server Programmer Analyst (Azure T-SQL)

SMX Services and Consulting, Inc.

$110K — $130K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 7 years of SQL Server development experience in enterprise environments
  • 5 years of advanced T-SQL development skills, with a focus on query tuning and performance optimization
  • 5 years of experience developing in SQL Server within Azure environments
  • Hands-on experience with high availability architectures using Always On availability groups
  • Proven ability to modernize database code and support legacy SQL
  • Collaborated effectively with .NET Core/C# development teams over the last 5 years
  • Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines
  • Minimum of 10 years of overall IT experience

Responsibilities

  • Develop and optimize T-SQL queries, stored procedures, functions, and views for new application capabilities
  • Perform advanced performance tuning, including indexing strategies and query optimization
  • Modernize existing SQL components while maintaining support for legacy SQL structures
  • Support new feature development aligned with a microservices-based modernization approach
  • Collaborate with .NET Core/C# developers for efficient data access and API integrations
  • Participate in the modernization of existing database models for scalability
  • Maintain high availability environments using Always On availability groups
  • Develop migration scripts, ETL logic, and integration solutions using SSIS and Databricks
  • Ensure compliance with PCI standards and implement data retention rules
  • Contribute to SQL changes through CI/CD pipelines with Azure DevOps and GitHub
  • Engage in Agile ceremonies and deliver work within sprint cycles

Benefits

  • Collaborative work environment within Agile/Scrum teams
  • Opportunities to modernize and optimize enterprise-level SQL solutions
  • Hands-on participation in high-availability architectures
  • Engagement in exciting projects involving microservices and modularization
  • Continuous learning opportunities with exposure to modern technologies such as Azure and DevOps
Full Job Description
***Only qualified Senior Microsoft SQL Server Programmer Analyst (Azure T-SQL) candidates located in the Mechanicsville, VA area will be considered due to the position requiring an onsite presence*** Required Skills: • SQL Server development experience in enterprise environments (7 Years) • Advanced T-SQL development skills including query tuning and performance optimization (5 Years) • Experience developing in SQL Server on Azure environments (5 Years) • Hands-on experience supporting high availability architectures using Always On availability groups (5 Years) • Experience modernizing database code and schemas, including legacy SQL support (5 Years) • Experience collaborating with .NET Core/C# development teams (5 Years) • Experience deploying SQL updates through Azure DevOps and GitHub CI/CD pipelines (5 Years) • Ability to work effectively within Agile/Scrum teams (5 Years) • Experience modernizing SQL workloads in cloud-hosted environments (5 Years) • Minimum of 10 years of IT experience Preferred Skills: • Knowledge of PCI compliance and database security requirements • Experience with Terraform or infrastructure-as-code to support SQL deployments • Experience working with microservices architectures and domain-driven design • Knowledge of scaling strategies for high-transaction SQL environments • Experience building ETL solutions using SSIS and Databricks About the Role: 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 Job 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 Interview Process: Both Phone and in-person

Similar Jobs

More Jobs at SMX Services and Consulting, Inc.

More Information Technology Jobs

Find similar Senior Microsoft SQL Server Programmer Analyst (Azure T-SQL) jobs: