> Markdown version of [/jobs/ext/4760003-sql-developer](https://www.wearedevelopers.com/jobs/ext/4760003-sql-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # SQL Developer - **Company:** Lundbeck Research USA Inc. - **Location:** New York, NY, United States (Remote available) - **Experience:** Experienced - **Salary:** $82,555 - $132,089 - **Contract:** Permanent contract - **Skills:** Data Analysis, JIRA, Microsoft Azure, Batch Processing, Code Review, Databases, Data Validation, Extract Transform Load (ETL), Database Development, Disaster Recovery, Virtual Private Networks (VPN), Job Scheduling, Log Shipping, Microsoft SQL Server, SQL Azure, Operational Databases, Windows PowerShell, Cloud Services, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Agent, Transact-SQL, Wi-Fi Technology, Azure Data Factory, GitHub Copilot, System Availability, Claude Code, Database Optimization, Backend, Git, Microsoft Fabric, SQL Server Management Studio (SSMS), Data Inconsistencies, Software Version Control - **Published:** November 17, 2026 - **Apply:** https://www.careerbuilder.com/job-details/sql-developer-new-york-ny--689b320c-68a5-4574-9365-f33233b17685 ## About the Role SQL (Structured Query Language), Healthcare, Healthcare Providers, Community Health, Hospital Systems, Thought Leadership, Consulting, Professional Services, Customer Relations, Customer/Consumer Behavior, * 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. ## 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, 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., * 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