SQL Developer

ovationhealthcare; United States; Remote; USD 83,000 - 132,000; Full time

Benefits offered by this job

Health insurance

401(k) with employer match

Paid time off

Professional development

Job summary

Ovation Healthcare is seeking a mid‑level SQL Server/Azure SQL specialist to develop and administer databases and data pipelines supporting healthcare revenue cycle operations.

You will own assigned systems from investigation through delivery, with exposure to ETL, reporting, and production troubleshooting, ensuring data accuracy and secure handling of health information.

Qualifications

• 3–5 years of hands-on SQL Server development and administration in production environments.
• Strong T-SQL skills including set-based queries, stored procedures, functions, views, CTEs, and transactional logic.
• Experience building and supporting SQL Server-backed ETL pipelines, including incremental loads, validation, and failure recovery.

Responsibilities

• Create and maintain T-SQL procedures, functions, views, and tables for applications, pipelines, and reporting.
• Build and troubleshoot ETL workflows, including staging, transformations, validation, scheduling, and recovery from failures.
• Administer SQL Server and Azure SQL environments, including backups, restores, jobs, permissions, maintenance, and capacity monitoring.
• Investigate performance issues, blocking, deadlocks, failed jobs, and data discrepancies; escalate complex cases with findings.
• Prepare, test, review, and execute production database changes with rollback scripts, and improve inefficient queries using execution plans and indexes.
• Maintain SSRS reports and support migration of legacy ETL processes to Fabric or Azure data services.

Skills

T-SQL

ETL development

SQL Server administration

Performance troubleshooting

Data security (health data)

Tools

Azure SQL

SSRS

Microsoft Fabric/Azure Data Factory

Job description

Role overview

Develop and administer SQL Server and Azure SQL databases and data pipelines supporting healthcare revenue cycle operations. This mid-level role combines T-SQL development, ETL support, database administration, reporting, and production troubleshooting, with ownership of assigned systems and changes from investigation through delivery.

Responsibilities

• Create and maintain T-SQL procedures, functions, views, and tables for applications, pipelines, and reporting.
• Build and troubleshoot ETL workflows, including staging, transformations, validation, scheduling, and recovery from failures.
• Administer SQL Server and Azure SQL environments, including backups, restores, jobs, permissions, maintenance, and capacity monitoring.
• Investigate performance issues, blocking, deadlocks, failed jobs, and data discrepancies; Escalate complex cases with findings.
• Prepare, test, review, and execute production database changes with rollback scripts, and improve inefficient queries using execution plans and indexes.
• Maintain SSRS reports and support migration of legacy ETL processes to Fabric or Azure data services.

Requirements

• 3–5 years of hands‑on SQL Server development and administration in production environments.
• Strong T‑SQL skills, including set‑based queries, stored procedures, functions, views, CTEs, and transactional logic.
• Experience writing safe parameterized dynamic SQL and using iterative or batch techniques where appropriate.
• Proven ability to build and support SQL Server‑backed ETL pipelines, including incremental loads, validation, and failure recovery.
• Careful production change practices, sound troubleshooting, and clear communication when requirements are incomplete.
• Ability to protect sensitive health information and follow access, source control, review, and change management standards.

Nice to have

PowerShell automation; Microsoft Fabric or Azure Data Factory; high availability and disaster recovery; experience with healthcare or other regulated data; or relevant Azure database or Fabric certifications.

Benefits and work setup

Remote role with reliable internet and a secure, HIPAA‑compliant workspace; occasional travel may depend on business needs. Listed base pay range is $82,555.42–$132,088.67. Full‑time benefits include health coverage, paid time off, holidays, a 401(k) with possible employer match, professional development, and company equipment.