Develop, construct, test and maintain architectures such as databases and large-scale processing systems

Job Summary

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 contemporary .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
Entity Framework 6 or EF Core — understanding ORM-generated SQL, N+1 detection, migrations
Git-based workflow — pull requests, code

📌 Data Engineer (Bengaluru)
🏢 Simple, a Netsmart solution
📍 Bengaluru