Sr.DB Developer

HealthAsyst; Bengaluru; Hybrid; INR 1,500,000 - 2,800,000; Full time

Benefits offered by this job

Bi-Annual Raises

Hybrid Model

Market Pay

Group Mediclaim (GMC) Insurance

Wellness Program

Job summary

HealthAsyst in Bengaluru seeks an experienced SQL Server Developer to design, implement, and optimize database solutions for healthcare IT applications. 4–6 years of experience, strong T-SQL skills, and expertise in performance tuning are required.

The role offers a three-day hybrid work model and competitive compensation. Responsibilities include production support, data modeling, ETL collaboration, and implementing scalable database designs with SQL Server 2019/2022.

Qualifications

• Experience in SQL Server development and performance tuning.
• Strong database design and data modeling skills.
• Proficiency with T-SQL, DDL/DML, and scripting.
• Experience with SQL Server 2019/2022 in OLAP/OLTP environments.
• Production support experience and automation.
• ETL tools and data warehousing familiarity.

Responsibilities

• Handle production support and automate support activities where possible.
• Design and code database tables to store application data.
• Monitor performance and tune complex queries using execution plans.
• Refactor legacy designs and optimize data models.
• Collaborate on data flow, data modeling, and ETL processes.

Skills

SQL Server

Performance Tuning

Indexing

Schema Design

T-SQL

Stored Procedures

Data Modeling

ETL

Tools

SSIS

SSRS

SQL Profiler

Perfmon

Pssdiag

Extended Events

Job description

HealthAsyst® is an IT service and product company. It is a leading provider of IT services to some of the largest healthcare IT vendors in the United States. We bring the value of cutting-edge technology through our deep expertise in product engineering, custom software development, testing, large-scale healthcare IT implementation and integrations, on-going maintenance and support, BI & Analytics, and remote monitoring platforms. As a true partner, we help our customers navigate a complex regulatory landscape, deal with cost pressures, and offer high-quality services. As a healthcare transformation agent, we enable innovation in technology and accelerate problem-solving while delivering unmatched cost benefits to healthcare technology companies. HealthAsyst is now a Great Place to Work-Certified™ & our product has also been consistently recognized for high customer credibility by Gartner, Capterra etc.

Job Description

Exp-4-6 Years

SQL Server Development/Programming, Performance Tuning, Indexing, Schema Design, TSQL(DDL & DML) scripts, stored procedures, functions and other database objects.

Scripting and Code management.

Minimum : Minimum 3+ years' Experience on-

Experienced in Database Design and Modelling. ER Diagram.

Ability to understand Business requirements and design database accordingly

Good in performance tuning especially tuning complex queries, procedure.

Strong understanding of database design, troubleshooting, and management.

Experienced in handling production support responsibilities, improving the support activities using automation tools where ever applicable.

Designing and coding database tables to store the application’s data

Memory utilization, and alert log file for MSSQL Server.

Refactoring of Old Design/code.

Minimum: Minimum 2+ years' Experience on-

Modernizing the old code, Advance Database coding, best practice.

Code review and SQL query tuning

Basic on Project Architecture level and data flow knowledge.

Must have experience with-

SQL Server 2019 & 2022 and T-SQL in both OLAP and OLTP environments

Experience in support in MS SQL Server environments. Must have experience on Tracing/debugging tool like SQL Profiler.

Database Tuning/optimization and Monitoring, Performance tuning strategies and implementation.

Design databases, ensuring high availability, business continuity, scalability, stability, security, performance and reliability to support business applications using MSSQL Server.

Monitoring, tuning and performance optimization of OS/Storage/DB configuration/databases and related parameters like, table space utilization, CPU utilization, Hard Disk Utilization,

Performance tuning and query optimization experience using execution plans and performance tuning tools (e.g., Perfmon, Pssdiag, Profiler, Extended Events and DMVs)

Good To Have:

Experience with an agile development methodology, preferably Scrum.

SSIS, SSRS other ETL, Good data Analysis skills and reporting knowledge.

Experience in Data Modelling, Database design and well versed with SQL Server best practices

Understand reporting requirements and map to Data Models

Engage with ETL Developers to create or design extracts that feed visualizations

Hands on experience in ETL tools for data flow transfer and management, Should have command on DDL and DML.

Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.

Worked in Data Warehousing, Data Modeling

Data modeling to visualize database structure

Design, plan, and develop programs to optimally extract, transform, and load data between data sources

What you will get :

Bi-Annual Salary Reviews

Three Day Hybrid Model

Market competitive pay

GMC (Group Mediclaim) : Provides Insurance coverage of Rs. 3 lakhs + a corporate buffer of 2 Lakhs per family. This is a family floater policy, and the company covers all the employees, spouse, and up to two children

Employee Wellness Program - HealthAsyst offers unlimited online doctor consultations for self and family from a range of 31 specialties for no cost to employees. And OPD consultations with GP Doctors are available in person for No Cost to employees

GPA (Group Personal Accident) : Provides insurance coverage of Rs. 20 lakhs to the employee against the risk of death/injury during the policy period sustained due to an accident

GTL (Group Term Life) : Provides life term insurance protection to employees in case of death. The coverage is one time of the employee’s CTC

Employee Assistance Program : HealthAsyst offers completeconfidential counselling services to employees & family members for mental wellbeing

Sponsored upskills program : The company will sponsor up to 1 Lakh for certifications/higher education/skill upskilling.

Flexible Benefits Plan – covering a range of components like