Senior SQL Database Engineer
TSV is leading a search for a Senior SQL Database Engineer for a Health Tech client in the Prior Authorization space. The client is seeking an accomplished Senior Database Engineer with deep expertise in Microsoft Azure SQL Database, advanced T-SQL development, and hands-on database administration. Database Operations Own day-to-day operation of production Azure SQL environments (multiple client logical servers and databases): monitor availability, DTU/vCore and storage utilization, sessions, failed connections, timeouts, and deadlocks, and act on alerts before users are affected. Participate in a production support / on-call rotation; triage database-related incidents (timeouts, blocking, resource saturation, dropped connections) with IT Operations and Engineering, restore service, and lead root-cause analysis and post-incident reviews with tracked follow-up actions. Manage scheduled database operations, including automated scale-up/scale-down schedules, maintenance windows, and recurring jobs (Elastic Jobs, ADF-triggered and stored-procedure jobs); schedule batch workloads so they do not run on undersized or peak-loaded databases. Build and maintain monitoring, alerting, and dashboards using Azure Monitor, Log Analytics (KQL), Query Store, SQL auditing, and diagnostic settings; define alert thresholds and write a runbook for each alert. Plan and perform database maintenance, including index/statistics management, integrity and consistency checks appropriate to Azure SQL, and capacity management. Administer database security and access: least-privilege logins, users, and roles; Microsoft Entra ID and managed identity authentication for applications and services in place of shared administrator logins; auditing; firewall rules, VNet rules, and private endpoints, in line with HIPAA requirements. Administer Azure SQL backup retention and point-in-time restore capabilities; support restore testing, geo-recovery planning, failover strategies, and documented recovery objectives (RPO/RTO).Operate business continuity: failover groups, geo-replication, and long-term backup retention; run regular restore and failover tests against documented RPO/RTO and keep DR runbooks current. Manage database cost: track spend by server and database, right-size service tiers, apply Azure Hybrid Benefit and reserved capacity where appropriate, retire unused databases and post-migration copies, and report savings. Execute production database changes under change management with scripted, peer-reviewed, and reversible deployments (dry run, rollback plan, change log), coordinated with application release schedules. Provision and configure databases for new client onboarding and for production/UAT/sandbox environment refreshes using templates and scripts (ARM/Bicep, PowerShell, Azure CLI).Maintain operational documentation (database inventory, runbooks, incident records) and present a weekly production health and cost summary in the production issues review with Engineering, DBA, and IT Operations. Database DevelopmentDesign, develop, and maintain Azure SQL Database schemas, tables, views, indexes, and other database objects, applying sound data modeling and design practices. Develop, review, troubleshoot, refactor, and optimize complex T-SQL queries, stored procedures, user-defined functions, and triggers for performance, reliability, and maintainability. Support database changes, migrations, data integrity controls, and production deployments while minimizing risk and disruption. Partner with application developers to improve SQL access patterns, transaction handling, database design, and application performance. Apply database coding standards, peer reviews, and version-controlled change management across development and production environments. Data Integration & Pipeline DevelopmentDesign, build, operate, troubleshoot, and optimize Azure Data Factory (ADF) pipelines and ETL/ELT workflows for recurring client data ingestion. Ingest and integrate client data from flat files, APIs, databases, and cloud-based sources, including mapping, scheduling, and dependency management. Implement robust validation, transformation, error handling, retry logic, monitoring, and reconciliation to ensure accurate, timely, and recoverable client data loads. Investigate failed or delayed pipeline runs, data quality exceptions, and ingestion performance issues; implement sustainable fixes. Reporting Support (Preferred) Collaborate with Product and reporting teams to troubleshoot SQL datasets, views, and stored procedures supporting operational reporting. Support existing Tableau data sources, extracts, and dashboards when needed; Tableau experience is a plus, not a core requirement. Performance & Optimization Lead root-cause analysis of slow-running stored procedures, functions, complex queries, and high-resource database workloads; implement and verify measurable improvements. Analyze actual execution plans, Query Store data, wait statistics, indexes, statistics, parameter sensitivity, locking, and resource utilization to identify and resolve bottlenecks. Troubleshoot blocking, deadlocks, timeouts, excessive CPU/IO consumption, and concurrency issues using Azure SQL diagnostics, Query Store, DMVs, Azure Monitor, and related tools. Evaluate and tune Azure SQL service tiers, compute and storage sizing, DTU/vCore utilization, scaling strategies, and cost/performance tradeoffs. Plan and perform database maintenance, including index/statistics management, integrity and consistency checks appropriate to Azure SQL, and capacity management. Recommend resilient Azure SQL architecture using appropriate options such as elastic pools, zone redundancy, failover groups, and geo-replication where justified. Collaboration & Leadership Work cross-functionally with engineering/development and product teams to deliver high-impact solutions. Participate in code reviews and enforce database development best practices. Mentor junior developers and contribute to establishing data engineering standards. Qualifications 7+ years of professional SQL Server/Azure SQL database development and performance optimization experience, including production troubleshooting.4+ years of hands-on Azure SQL Database experience and strong practical experience developing and operating Azure Data Factory pipelines. Advanced T-SQL expertise with demonstrated success tuning complex stored procedures, functions, execution plans, indexing, and high-volume workloads. Strong Azure SQL DBA skills in monitoring, troubleshooting, routine maintenance, security and access management, high availability, backup/restore, and disaster recovery. Ability to make informed Azure SQL infrastructure and architecture decisions based on performance, scalability, availability, security, and cost. Proven ability to design and maintain reliable client data ingestion pipelines in ADF with appropriate validation, error handling, and operational monitoring. Hands-on experience with Azure SQL performance tools, including Query Store, execution plans, DMVs, indexing/statistics diagnostics, and Azure Monitor. Demonstrated ability to evaluate Azure SQL configuration, compute/service tier sizing, resiliency options, and cost/performance implications.3+ years in a production database operations or DBA role with on-call and incident response responsibility for business-critical, 24x7 systems. Hands-on experience with Azure Monitor, Log Analytics/KQL, alerting, and SQL auditing for proactive monitoring and incident investigation. Scripting and automation with PowerShell and/or Azure CLI (and ARM/Bicep templates) for routine operations, scaling, and provisioning. Experience securing Azure SQL in a regulated environment (HIPAA/PHI), including Entra ID authentication, managed identities, least-privilege access, auditing, and network isolation. Soft SkillsStrong analytical, problem-solving, and troubleshooting skills. Excellent communication and collaboration across technical and business teams. Detail-oriented and committed to quality, scalability, and performance. Ability to work independently while contributing to a larger team effort. Calm and methodical underproduction pressure, with clear written incident communication to both technical and non-technical stakeholders. Able to balance planned development work with unplanned operational priorities and to communicate trade-offs early. Must be available for on-call and weekend rotations.