Senior SQL Engineer

Benefits:

• Competitive salary

Location
Remote

Experience Level
Senior Level (5+ Years SQL Engineering Experience)


Position Overview
The Senior SQL Engineer will lead the design, optimization, support, and continuous improvement of mission-critical SQL Server environments supporting healthcare operations. This role is responsible for database architecture, performance tuning, ETL development, production support, CI/CD integration, and data governance. The ideal candidate combines deep SQL Server expertise with strong analytical, troubleshooting, and stakeholder management skills to deliver scalable, secure, and high-performing data solutions.


Key Responsibilities


Database Architecture & Development

• Design, architect, and optimize SQL Server databases supporting high-volume healthcare systems.
• Develop advanced T-SQL solutions including stored procedures, triggers, views, functions, and indexing strategies.
• Design scalable database structures supporting operational and analytical workloads.
• Drive database architecture decisions including normalization, partitioning, and schema evolution.

Performance Tuning & Optimization

• Lead SQL Server performance tuning initiatives.
• Analyze execution plans, query performance, and database workloads.
• Optimize database structures, indexing strategies, and SQL code.
• Identify and resolve bottlenecks impacting system performance and availability.
• Monitor database performance and recommend long-term improvements.

ETL & Data Integration

• Design, develop, and support ETL processes using SSIS and custom frameworks.
• Manage data ingestion, transformation, and delivery processes.
• Support integration of healthcare data across multiple applications and platforms.
• Ensure data quality, consistency, and integrity throughout data movement processes.

DevOps & Database Deployments

• Collaborate with DevOps teams to support CI/CD pipelines for database deployments.
• Implement version control, automated deployments, rollback procedures, and release management processes.
• Support database modernization and automation initiatives.
• Utilize Git, Jenkins, and related DevOps tools.

Production Support & Operations

• Support production SQL Server environments and mission-critical applications.
• Troubleshoot and resolve database, application, and integration issues.
• Monitor overnight jobs, scheduled tasks, and automated processes.
• Manage incident response, root cause analysis, and corrective actions.
• Support after-hours deployments and maintenance activities as needed.

Leadership & Collaboration

• Mentor junior developers and database professionals.
• Conduct code reviews and establish SQL development standards.
• Partner with business analysts and stakeholders to translate requirements into technical solutions.
• Lead technical demonstrations and solution reviews.
• Work closely with development, infrastructure, vendor, and business teams.

Governance & Documentation

• Maintain database documentation, operational procedures, and data flow diagrams.
• Support data governance, security, compliance, and audit requirements.
• Document system dependencies, support processes, and database standards.
• Participate in strategic technology planning initiatives.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field, or equivalent experience.
• 5+ years of experience in SQL Server database engineering or related roles.
• Deep expertise with: 
  • T-SQL
  • Stored Procedures
  • Triggers
  • Views
  • Query Optimization
  • Indexing Strategies
  • Execution Plan Analysis
• Experience with SQL Server performance tuning and troubleshooting.
• Experience building and supporting ETL solutions using SSIS or similar technologies.
• Experience supporting production database environments.
• Experience with CI/CD pipelines, Git, Jenkins, and automated deployment processes.
• Strong understanding of the Microsoft technology stack, including .NET and Visual Studio.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Strong written, verbal, and presentation skills.

Preferred Qualifications

• 2+ years of healthcare insurance, payer, provider, PBM, or PPO experience.
• Experience with healthcare data standards and regulatory environments.
• Experience with enterprise data warehousing solutions.
• Experience with LAMP stack technologies.
• Experience with Jira and Agile project environments.
• Experience supporting third-party healthcare integrations.
• Experience managing large-scale healthcare data platforms.

Core Skills

• Microsoft SQL Server
• T-SQL Development
• Performance Tuning
• Query Optimization
• Database Architecture
• ETL Development
• SSIS
• Data Warehousing
• Stored Procedures
• Indexing & Partitioning
• CI/CD Pipelines
• Git
• Jenkins
• .NET Technologies
• Production Support
• Database Administration
• Healthcare Data Integration
• Root Cause Analysis
• Data Governance
• Agile Methodologies
• Jira

This is a remote position.