HealthAsyst - SQL Server Developer - Database Programming & Performance Tuning (3-6 yrs)

About Company :

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 bene- ts to healthcare technology companies.

Founded : 1999.

Location : Anjaneya Techno Park, HAL Old Airport Road, Bangalore.

Products : CheckinAsyst, RadAsyst.

IT Services : Product Engineering, Custom Development, QA & Testing, Integration, Maintenance, Managed Services.

https://www.healthasyst.com/about-us/.

Job Description :

Minimum : 3 + year experience on :

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

Employee Benefits :

HealthAsyst provides the following health, and wellness benefits to cover a range of physical and mental well-being for its employees.

- Bi-Annual Salary Reviews.

- 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 ProgramHealthAsyst 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 for certifications/higher education up to 1 lakh.

- Flexible Benefits Plan - covering a range of components like.

- National Pension System.

- Internet/Mobile Reimbursements.

- Fuel Reimbursements.

- Professional Education Reimbursements.

- Flexible working hours.

- 3 Day Hybrid Model.