SQL Developer

Ovation Healthcare

United States

Remote

USD 83,000 - 132,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health benefits
HSA contributions
Paid time off
401(k) plan

Job summary

Ovation Healthcare is hiring a mid-level MSSQL Developer/DBA to manage SQL Server and Azure SQL databases, ETL pipelines and SSRS reports. You will work remotely with senior engineers, own assigned databases, and ensure production changes are safe with rollback plans, including PHI/PII handling under HIPAA requirements.

The role emphasizes T-SQL skills, ETL expertise, and migration work toward Microsoft Fabric and Azure Data Factory, with a strong focus on security and reliability.

Qualifications

  • 3–5 years of hands-on MS SQL Server development and administration in production.
  • Strong T-SQL skills, including stored procedures, functions and transactions.
  • Experience with ETL pipelines, SSRS reports and Azure SQL services.
  • HIPAA awareness and ability to handle PHI/PII data securely.

Responsibilities

  • Design, develop and maintain T-SQL procedures, functions, views and tables.
  • Build and support ETL pipelines and reporting workloads.
  • Manage backups, maintenance, security and performance tuning.
  • Support migration to Microsoft Fabric and Azure Data Factory.
  • Ensure least-privilege access and HIPAA-compliant data handling.

Skills

MS SQL Server
T-SQL
ETL pipelines
Azure SQL
SSRS reporting
PowerShell
Fabric/Azure DF
SQL Server Admin

Tools

SSMS
Azure Data Studio
GitHub Copilot
JIRA

Job description

About the Job

Welcome to Ovation Healthcare!


At Ovation Healthcare, we’ve been making local healthcare better for more than 40 years. Our mission is to strengthen independent community healthcare. We provide independent hospitals and health systems with the support, guidance and tech-enabled shared services needed to remain strong and viable. With a strong sense of purpose and commitment to operating excellence, we help rural healthcare providers fulfill their missions.


The Ovation Healthcare difference is the extraordinary combination of operations experience and consulting guidance that fulfills our mission of creating a sustainable future for healthcare organizations. Ovation Healthcare’s vision is to be a dynamic, integrated professional services company delivering innovative and executable solutions through experience and thought leadership, while valuing trust, respect, and customer focused behavior.


We’re looking for talented, motivated professionals with a desire to help independent hospitals thrive. Working with Ovation Healthcare, you will have the opportunity to collaborate with highly skilled subject matter specialists and operations executives, in a collegial atmosphere of professionalism and teamwork.


Ovation Healthcare’s corporateheadquartersis located in Brentwood, TN. For more information, www.ovationhc.com.


Summary:


Ovation Healthcare is hiring a mid-level MSSQL Developer / DBA to develop, support and maintain the SQL Server and Azure SQL databases and ETL pipelines that power our Revenue Cycle Management (RCM) operations. You will write and tune T-SQL, build and support ETL pipelines, handle day-to-day database administration, resolve production issues, support enterprise reporting, and help migrate legacy ETL workflows to Microsoft Fabric and Azure.


You will work alongside senior engineers who set standards and handle top-tier escalations, while owning assigned databases, tickets and changes end to end. The right candidate brings a careful, “first-time right” approach to production changes, always prepares a rollback plan, and asks the right questions to turn incomplete requests into clear requirements. You will handle healthcare data (PHI/PII) under HIPAA requirements.


Duties and Responsibilities:



  • Design, write and maintain T‑SQL stored procedures, functions, views and tables that support applications, ETL pipelines and reporting

  • Build, maintain and troubleshoot ETL pipelines that extract, transform and load healthcare and financial data into SQL Server, including data validation, error handling and job scheduling

  • Manage backups and restores, SQL Agent jobs, index and statistics maintenance, user access and permissions, and capacity monitoring across SQL Server and Azure SQL

  • Diagnose and resolve performance issues, blocking, deadlocks, failed jobs and data inconsistencies; escalates complex issues to senior staff with a clear summary of findings

  • Author, test, peer-review and execute production data scripts, with a rollback script prepared before every data modification or schema change

  • Review execution plans, indexes and stored procedures to refactor inefficient T‑SQL and prevent recurring issues

  • Build, modify and troubleshoot SQL Server Reporting Services (SSRS) reports, subscriptions and underlying datasets

  • Support the conversion of legacy ETL processes built on PowerShell and stored procedures into Microsoft Fabric and Azure, and provide operational support after migration

  • Apply least-privilege access, protect PHI/PII under HIPAA, and follow team standards for source control, code review and change management in Azure DevOps; track work in JIRA


Knowledge, Skills and Abilities:



  • 3–5 years of hands‑on MS SQL Server database development and administration in a production environment

  • Strong T‑SQL skills: set‑based queries, stored procedures, functions, views, CTEs and transactional logic

  • Experience writing parameterized dynamic SQL (sp_executesql) safely, and using WHILE loops and cursors for iterative and batch processing, with judgment on when a set‑based approach is the better choice

  • Proven experience building and supporting ETL pipelines that use SQL Server as the backend, including staging, transformation logic, incremental loads, data validation and failure recovery

  • Working knowledge of database administration: backup/restore, SQL Agent jobs, index and statistics maintenance, security and permissions, and monitoring

  • Solid understanding of explicit transaction management (BEGIN TRAN, COMMIT, ROLLBACK), error handling (TRY…CATCH) and backout script patterns

  • Experience using DMVs, Query Store, Extended Events and execution plans to troubleshoot performance issues

  • Understanding of isolation levels, locking and blocking, and indexing strategies

  • Experience with Azure SQL Database or Azure SQL Managed Instance

  • Experience developing and supporting SSRS reports, including parameters and datasets

  • Hands‑on experience using AI‑assisted development tools: Claude Code, Codex or GitHub Copilot

  • Proficiency with SSMS, Azure Data Studio, Git‑based version control and JIRA

  • Clear written and verbal communication; able to explain technical findings in plain language to business partners


Preferred Qualifications:



  • Experience with PowerShell scripting for database automation

  • Practical experience with Microsoft Fabric (Data Factory pipelines, Warehouses/Lakehouses) or Azure Data Factory

  • Experience with high availability and disaster recovery (Always On availability groups, log shipping, geo‑replication)

  • Experience in healthcare, Revenue Cycle Management or another regulated industry handling PHI/PII

  • Microsoft Certified: Azure Database Administrator Associate (DP-300) or Fabric Analytics Engineer Associate (DP-600)


Working Conditions and Physical Requirements:



  • This is a remote position.

  • Reliable high‑speed internet connection is required for all remote/hybrid positions.

  • Must have access to stable Wi‑Fi with sufficient bandwidth to support video conferencing, cloud‑based tools, and other online work‑related activities.

  • Collaboration in virtual settings and participation in team meetings.

  • Ability to sit for extended periods at a desk and work on a computer.

  • A HIPAA‑compliant work environment is required, including a secure workspace free from unauthorized access or interruptions, no use of public Wi‑Fi unless connected through a secure company‑provided VPN, and compliance with all applicable HIPAA privacy and security regulations.


#LI‑Remote


Travel Requirements:



  • Dependent on business and client need


Benefits

The base compensation range for this position is:


$82,555.42 - $132,088.67


Compensation ranges could be hourly or salary depending upon the exempt status of the posted position.


Beginning compensation is determined based on objective factors such as location, qualifications, skills, certifications, and experience. Typically, a candidate is hired in the lower to midpoint of the range; the top end of the range is reserved for candidates with extensive specialized experience and mastery within the role. Compensation may increase over time based on performance, experience, and tenure.


Compensation is only part of Ovation’s total compensation package. Some additional benefits offered to full‑time associates are:



  • Comprehensive health and wellness benefits such as medical, dental, vision, life insurance, short and long‑term disability coverage

  • HSA with employer contributions, flexible spending accounts for health care, and dependent care accounts

  • Wellness platform with premium incentives

  • Employee assistance support and additional voluntary supplemental plans including accident, critical illness, hospital indemnity, and child disability insurance

  • Robust and flexible paid time off offerings and company paid holidays

  • 401(k) plan with discretionary employer match opportunities

  • Professional development opportunities

  • Company issued equipment

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Developer
SQL Developer

QHR Health, LLC dba Ovation Healthcare • United States

Remote
USD 83,000 - 132,000
Health benefits
401(k) plan
Paid time off
+1
Azure Application Developer
Azure Application Developer

Ovation Healthcare • United States

Remote
USD 116,000 - 186,000
Health benefits
401(k) plan
Paid time off
+2
Azure Application Developer
Azure Application Developer

QHR Health, LLC dba Ovation Healthcare • United States

Remote
USD 116,000 - 186,000
Health benefits
HSA with employer contributions
Paid time off
+3
Database Administrator (Hybrid - Greensboro, NC)
Database Administrator (Hybrid - Greensboro, NC)

QHR Health, LLC dba Ovation Healthcare • Greensboro (NC)

Hybrid
USD 95,000 - 142,000
Health & wellness benefits
HSA with employer contributions
401(k) plan with match
+1
EO, Client Operations Representative
EO, Client Operations Representative

Ovation Healthcare • United States

Remote
USD 28,000 - 42,000
Comprehensive health and wellness
HSA with employer contributions
Wellness platform with premiumincenti
+3
Specialist, Cash Posting
Specialist, Cash Posting

Ovation Healthcare • United States

Remote
USD 41,000 - 61,000
Health benefits
HSA contributions
Wellness platform
+4
Senior Consultant, Clinical Solutions
Senior Consultant, Clinical Solutions

QHR Health • United States

Remote
USD 113,000 - 170,000
Comprehensive health and wellness bene
HSA with employer contributions
Wellness platform with incentives
+5
Team Lead, Coding
Team Lead, Coding

Ovation Healthcare • United States

Remote
USD 61,000 - 92,000
Comprehensive health and wellness plan
HSA with employer contributions
Wellness platform with incentives
+2
Systems Engineer
Systems Engineer

Ovation Healthcare • Greensboro (NC)

Hybrid
USD 88,000 - 132,000
Health insurance
HSA contributions
Wellness program
+2
PA, Scheduler
PA, Scheduler

QHR Health • United States

Remote
USD 37,000 - 56,000
Health and wellness benefits
HSA with employer contributions
Flexible spending accounts
+6