Sr.DB Developer

Posted 19 Days Ago
Be an Early Applicant
Bengaluru, Karnataka, IND
In-Office
Senior level
Healthtech • Information Technology • Software
The Role
Develops and optimizes Microsoft SQL Server databases for healthcare applications. Responsibilities include database design and modeling, T-SQL development, stored procedures, indexing, query and performance tuning, troubleshooting, monitoring, production support, code modernization, auditing, high availability, scalability, and reliability. The role also supports data warehousing, ETL, reporting, and collaboration with application and ETL developers.
Summary Generated by Built In
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

Skills Required

  • 4-6 years of experience in SQL Server development and programming
  • At least 3 years of experience in database design, data modeling, and ER diagrams
  • At least 2 years of experience modernizing legacy code and applying advanced database coding practices
  • Strong experience with SQL Server 2019 and 2022
  • Proficiency in T-SQL, including DDL, DML, stored procedures, functions, and database objects
  • Experience with both OLAP and OLTP environments
  • Experience with database performance tuning, query optimization, indexing, execution plans, and tuning tools
  • Experience using SQL Profiler or comparable tracing and debugging tools
  • Experience monitoring and tuning operating system, storage, and database configurations
  • Experience supporting Microsoft SQL Server production environments
  • Knowledge of database high availability, business continuity, scalability, security, stability, and reliability
  • Ability to translate business requirements into database designs
  • Experience with code reviews, troubleshooting, refactoring, and database auditing
  • Experience with ETL, data warehousing, data modeling, and reporting requirements
  • Experience with SSIS, SSRS, or other ETL tools
  • Experience with Agile development, preferably Scrum
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Bengaluru
566 Employees
Year Founded: 1999

What We Do

HealthAsyst is a healthcare technology company that develops innovative IT solutions and services to enhance patient safety and simplify healthcare delivery. Its mission is to make healthcare more affordable, accessible, and efficient while serving as a trusted technology partner. Founded by Umesh Bajaj, the company provides technology-focused support for healthcare organizations and works to improve the way care is delivered.

Similar Jobs

Zscaler Logo Zscaler

Technical Success Manager

Cloud • Information Technology • Security • Software • Cybersecurity
Easy Apply
Hybrid
Bangalore, Bengaluru, Karnataka, IND
8697 Employees

Ericsson Logo Ericsson

Data Scientist

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
3 Locations
88000 Employees

Ericsson Logo Ericsson

Devops Engineer

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
5 Locations
88000 Employees

Ericsson Logo Ericsson

Senior Software Architect

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
5 Locations
88000 Employees

Similar Companies Hiring

Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account