Verified Job
Engineering - Architecture
Data Engineer - Database
Engineering - Architecture
#824663
Remote / WFH
Netsmart
Job Description
We're looking for a Database Developer to own and evolve the data layer of a cloud-hosted healthcare SaaS platform. You'll design and optimize stored procedures, build reporting pipelines, tune performance in a high-concurrency environment, and collaborate with application developers on data access patterns — while also helping migrate legacy T-SQL logic into modern .NET services.
What You'll Do
• Design, develop, and optimize stored procedures, functions, views, and triggers in SQL Server
• Own database schema design, migrations, and deployments for a multi-tenant SaaS application
• Build and maintain T-SQL reporting data warehouses — aggregation logic and scheduled jobs
• Performance tune slow queries — execution plan analysis, index strategy, statistics management, blocking/deadlock resolution
• Write operational data scripts for migrations, corrections, and bulk operations
• Collaborate with .NET developers to design efficient data access patterns (Entity Framework 6 and EF Core)
• Support data flows for third-party integrations — staging tables, validation, reconciliation
• Implement audit trails, row-level security, and compliance controls for healthcare (HIPAA/PHI) data
• Participate in CI/CD for database changes — DACPAC deployments, scripted migrations, pull request reviews
Must-Have
• 4–6 years hands-on experience with SQL Server (2016+)
• Expert-level T-SQL — complex stored procedures, CTEs, window functions, dynamic SQL, temp tables, cursor optimization
• Performance tuning — execution plans, index design, Query Store, statistics, concurrency management
• Database design — normalization, denormalization for reporting, multi-tenant schema patterns
• SSDT / SQL Server Data Tools — database projects, schema compare, DACPAC deployments
What You'll Do
• Design, develop, and optimize stored procedures, functions, views, and triggers in SQL Server
• Own database schema design, migrations, and deployments for a multi-tenant SaaS application
• Build and maintain T-SQL reporting data warehouses — aggregation logic and scheduled jobs
• Performance tune slow queries — execution plan analysis, index strategy, statistics management, blocking/deadlock resolution
• Write operational data scripts for migrations, corrections, and bulk operations
• Collaborate with .NET developers to design efficient data access patterns (Entity Framework 6 and EF Core)
• Support data flows for third-party integrations — staging tables, validation, reconciliation
• Implement audit trails, row-level security, and compliance controls for healthcare (HIPAA/PHI) data
• Participate in CI/CD for database changes — DACPAC deployments, scripted migrations, pull request reviews
Must-Have
• 4–6 years hands-on experience with SQL Server (2016+)
• Expert-level T-SQL — complex stored procedures, CTEs, window functions, dynamic SQL, temp tables, cursor optimization
• Performance tuning — execution plans, index design, Query Store, statistics, concurrency management
• Database design — normalization, denormalization for reporting, multi-tenant schema patterns
• SSDT / SQL Server Data Tools — database projects, schema compare, DACPAC deployments
