Database Engineer

Netsmart; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Netsmart in Bengaluru is seeking a Database Developer to own and evolve the data layer of a cloud-hosted healthcare SaaS platform. You will design and optimize stored procedures, build reporting pipelines, and collaborate with .NET developers on data access patterns.

The role focuses on SQL Server, multi-tenant schemas, performance tuning, and HIPAA data compliance, with CI/CD for database changes and DACPAC deployments.

Qualifications

• 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, 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.

Responsibilities

• 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.

Skills

SQL Server

T-SQL

Performance tuning

Database design

Entity Framework

EF Core

Git

Debugging

Tools

EF Core

SSDT

SQL Server Data Tools

Git

Job description

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

Good-to-Have

• Data warehousing — star/snowflake schemas, reporting aggregation
• C# / .NET basics — ability to read service/repository code and understand 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

Netsmart is proud to be an equal opportunity workplace and is an affirmative action employer, providing equal employment and advancement opportunities to all individuals.

We celebrate diversity and are committed to creating an inclusive environment for all associates.

All employment decisions at Netsmart, including but not limited to recruiting, hiring, promotion and transfer, are based on performance, qualifications, abilities, education and experience.

Netsmart does not discriminate in employment opportunities or practices based on race, color, religion, sex (including pregnancy), sexual orientation, gender identity or expression, national origin, age, physical or mental disability, past or present military service, or any other status protected by the laws or regulations in the locations where we operate.

Netsmart desires to provide a healthy and safe workplace and, as a government contractor, Netsmart is committed to maintaining a drug‑free workplace in accordance with applicable federal law.

Pursuant to Netsmart policy, all post‑offer candidates are required to successfully complete a pre‑employment background check, which is provided at Netsmart’s sole expense.

Have you ever been to a doctor’s office and submitted your information electronically? Had a telehealth video visit with a therapist? Or scheduled a follow‑up visit with your provider through a mobile app? These are just a few examples of how you may have used healthcare technology software in your life as a consumer.

Many people view the operating system of healthcare as the electronic health record, but at Netsmart we have a comprehensive platform of solutions and services we offer for our clients.

At Netsmart, we provide our post‑acute and human services clients with advanced technology to better serve the individuals and patients in their care.

Our Netsmart team is vision driven, cause connected and passionate about opportunity. A combination of inspiration through our client work paired with the ability to innovate and explore fuels the success of our associates and company as a whole.

Netsmart is focused on providing a candidate experience that mirrors our associate experience.

The CandE Winners – Talent Board

We are proud to be named one of Ingram’s Best Companies to Work For.

If you require accessibility assistance or accommodation for a disability when navigating our website or completing the application process, please contact 1-800-842-1973, option 4 or [e-mail] for assistance.

US Applicants: Learn more about your EEO rights under the law (en Español).

Netsmart’s