Senior SQL Engineer

SMART TECH SKILLS LLC

Senior SQL Engineer

Boston, MA
Full Time
Paid
  • Responsibilities

    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.