Netsmart
Create a free account
One signup unlocks everything for this job:
- Apply to this job and track your application
- See your personalized profile match score
- Generate an AI cover letter for this role
Software Development · Unknown · Overland Park, US
Netsmart innovates electronic health records, solutions and services that are powerful, intuitive & easy-to-use. Our platform provides accurate, up-to-date information which is accessible to care teams in behavioral health, social services & post-acute.
Hiring: Engineering
What employees say
+ WLB,TechStack,Learning,Chill Onsite Leadership,Growth and team chaneg oppurnties
− Some teams have a bit micromanagement
More reviews on the company profile.
Interview experience · Senior Software Engineer
One HLD Design problem and other resume based questions. Questions about scalability ,availability and resilience. Questions abouts creational design patterns such as factory pattern. One DSA problem related to Hashmap.
Average difficulty · Bengaluru · 10 reports
More interview insightsJob description
Overview
Develop, construct, test and maintain architectures such as databases and large-scale processing systems
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
- 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
- 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)
Qualifications
- Terraform for infrastructure provisioning
Verify Engineering for this role
Free PRACTICE for Engineering adds a verified skill signal that can boost how roles like this rank for you — optional, not required to browse or apply.
Sign up — verify Engineering free →Want match scores and deeper insight? Create a free candidate profile