DataBricks Database Administrator (DBA)

Curana Health, Inc.

74d

About The Position

At Curana Health, we’re on a mission to radically improve the health, happiness, and dignity of older adults—and we’re looking for passionate people to help us do it. As a national leader in value-based care, we offer senior living communities and skilled nursing facilities a wide range of solutions (including on-site primary care services, Accountable Care Organizations, and Medicare Advantage Special Needs Plans) proven to enhance health outcomes, streamline operations, and create new financial opportunities. Founded in 2021, we’ve grown quickly—now serving 200,000+ seniors in 1,500+ communities across 32 states. Our team includes more than 1,000 clinicians alongside care coordinators, analysts, operators, and professionals from all backgrounds, all working together to deliver high-quality, proactive solutions for senior living operators and those they care for. If you’re looking to make a meaningful impact on the senior healthcare landscape, you’re in the right place—and we look forward to working with you.

Requirements

• Minimum 5 years working with SQL Server, DataBricks, and related technologies
• Strong proficiency in development of T-SQL Script writing, testing, and debug in large software application systems
• Can explain in complete detail the tradeoffs between a common table expression, temp table, table variables in query performance
• Can explain in complete detail the life of a transaction as it pertains to SQL Server and DataBricks
• Understands Memory Optimized tables
• Demonstrated ability to create SSIS Projects, familiarity with Azure Data Factory, and DBT
• Experience with T-SQL, MDX, DAX, Python, PySpark
• Should be able to Read C# code and understand object-oriented principles
• Familiarity with Databricks Unity Catalog
• Familiarity with PowerShell scripting
• Has familiarity with Microsoft Azure and provisioning of SQL Server Databases
• Understanding of HIPAA, SOC 2, or other compliance frameworks relevant to healthcare data
• Bachelor’s degree from an accredited college or university or equivalent experience

Responsibilities

• Modernize the data warehouse environment by migrating the platform to Azure Databricks
• Architect, design, install, create architecture documentation, and perform operational support for all database environments
• Determine appropriate indexing for new stored procedures and poorly performing queries
• Modify/Create/maintain and optimize ETL processes within SSIS, ADF, and DBT
• Perform capacity planning required to create and maintain the databases
• Implement security for all the Databases
• Manage Delta Lake architecture, versioning, and time travel
• Monitor performance and health of data pipelines and cluster with tools like Datadog, Azure Monitor, or Grafana
• Provide support for multiple applications using Microsoft SQL RDBMS Platforms, SQL Server 2012, 2016, SQL Server Reporting Services and SQL Server Integration Services, High Availability (Clustering & Replication) as well as our new DataBricks platform
• Perform Tuning and Optimization; troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, index management and statistics
• Provide application development support – DDL implementation and maintenance, code review Includes DDL/Schema changes implementation in development, test, and production systems
• Perform and/or coordinate installations, upgrades, and patches to Microsoft SQL products and tools
• Provide On-call Support during off- hours for Production, test and development DBs based on criticality

What This Job Offers

• Education Level: Bachelor's degree