Sr.DB Developer

HealthAsyst®; Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Bi-Annual Salary Reviews

Flexible working hours

Three Day Hybrid Model

GMC Insurance Rs. 3 lakhs + family 2 L

Employee Wellness Program

Upskills Sponsorship up to 1 Lakh

Group Term Life Insurance

Professional Education Reimbursement

Job summary

HealthAsyst is seeking a SQL Server Developer to design, tune, and optimize databases supporting healthcare IT solutions. You will work on tuning complex queries, indexing strategies, and T-SQL development across OLAP and OLTP environments.

The role requires experience with MS SQL Server 2019/2022, database design, and production-support activities, with an emphasis on performance, reliability, and scalability. Hybrid work model with market-competitive pay is offered.

Qualifications

• 4–6 years of SQL Server development and performance tuning.
• Experience in database design, ER modeling and business requirement mapping.
• Strong knowledge of SQL Server 2019 & 2022 in OLAP/OLTP environments.
• Experience with tracing/debugging tools like SQL Profiler.
• Ability to modernize old code and optimize complex queries.
• Experience in production support and automation where applicable.
• Knowledge of data modeling and data warehousing concepts.

Skills

SQL Server Development

Performance Tuning

Indexing & Schema Design

T-SQL (DDL & DML)

Stored Procedures & Functions

Production Support

Code Review & Refactoring

Data Modeling

OS/Storage/DB Monitoring

ETL/Data Warehousing Basics

Job description

About HealthAsyst

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.
• Project level Data Auditing.
• 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
• Flexible working hour
• 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 complete confidential 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

• National Pension System.
• Internet/Mobile Reimbursements.
• Fuel Reimbursements.
• Professional Education Reimbursement