Database Engineer
Database developer who owns and evolves the data layer of a cloud-hosted healthcare SaaS platform: designing and tuning SQL Server stored procedures, T-SQL reporting warehouses, and multi-tenant schema deployments, while partnering with .NET developers (Entity Framework) and migrating legacy T-SQL logic into modern .NET services.
- Compensation
- Not disclosed
- Location
- Bengaluru, India
- Work setup
- Onsite
- Seniority
- Not specified
- Employment
- Contract
- Experience
- 4+ years
- Category
- Devops
- Posted
Skills
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 — ORM-generated SQL, N+1 detection, migrations
- Git-based workflow — pull requests, code review for SQL, branching strategies
- Strong debugging skills — tracing data flow from application through ORM to stored procedures
Nice to have
- Data warehousing — star/snowflake schemas, reporting aggregation
- C# / .NET basics — reading service/repository code and data access layer patterns
- Healthcare domain — HL7, clinical data models, HIPAA compliance
- Azure Pipelines or Jenkins for database CI/CD
- AWS services (Lambda, S3, SQS) for data integration scenarios
- MongoDB (document store syncing to SQL Server)
- Experience migrating stored procedure logic into application-layer code (DDD, Clean Architecture)
- Terraform for infrastructure provisioning
Full description
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 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
- Entity Framework 6 or EF Core — understanding ORM-generated SQL, N+1 detection, migrations
- Git-based workflow — pull requests, code review for SQL, branching strategies
- Strong debugging skills — tracing data flow from application through ORM to stored procedures