CI/CD GitHub Azure DevOps SQL Server C# Analyst

Coolsoft LLC
Mechanicsville, United States of America
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Mechanicsville, United States of America

Tech stack

API
Agile Methodologies
Azure
C Sharp (Programming Language)
Databases
Continuous Integration
Data Integration
ETL
Data Retention
Database Models
Database Security
Github
Infrastructure as a Service (IaaS)
Microsoft SQL Server
PCI Data Security Standards
Performance Tuning
Scrum
Query Optimization
Standard Sql
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
T-SQL
Virtual Machines
Alwayson
.NET Core
System Availability
Database Optimization
Enterprise Integration
Terraform
Domain Driven Design
Databricks
Microservices

Job description

The Senior Microsoft SQL Developer will support the modernization of an enterprise tolling transaction platform undergoing a partial rewrite using micro services 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., * Develop and optimize T-SQL queries, stored procedures, functions, and viewsto support new application capabilities.

  • Perform advanced performance tuning, indexing strategies, and queryoptimization for a business-critical SQL environment.
  • Modernize existing SQL components while supporting legacy SQL code

andstructures.

  • Support new feature development aligned with the microservices-basedapplication modernization approach.
  • Collaborate with .NET Core/C# developers to ensure efficient data accesspatterns and API/database integrations.
  • Participate in modernizing existing database models to support modular,scalable architecture.
  • Support and maintain high availability environments using Always Onavailability groups.
  • Develop migration scripts, ETL logic, and integration solutions using SSISand 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.

Requirements

  • 7-10+ years of SQL Server development experience in enterprise environments.
  • Advanced T-SQL development skills including query tuning and performanceoptimization.
  • Experience developing in SQL Server on Azure VM (IaaS) environments.
  • Hands-on experience supporting high availability architectures using AlwaysOn availability groups.
  • Experience modernizing database code and schemas, including legacy SQLsupport.
  • Experience building ETL solutions using SSIS and Databricks.
  • Experience collaborating with .NET Core/C# development teams.
  • Experience deploying SQL updates through Azure DevOps and GitHub CI/CDpipelines.
  • Ability to work effectively within Agile/Scrum teams.
  • Knowledge of PCI compliance and database security requirements.

Preferred Skills

  • 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 modernizing SQL workloads in cloud-hosted environments.

Apply for this position