[Hiring] SQL Developer @Ovation Healthcare

Role Description

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
• 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; escalate 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

Qualifications

• 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.

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