Ms Sql Database Administrator

Role Synopsis

MS SQL Database Administrator

Key Responsibilities

• Own the day-to-day administration, monitoring, and maintenance of production and non-production databases

  (MSQL Server)

  for HIS, QMS, and other systems
• Perform regular health checks, indexing, partitioning, and performance tuning
• Proactively monitor database jobs, alerts, backups, and disaster-recovery readiness
• Optimize complex SQL queries, stored procedures, functions, and views to ensure maximum query performance and minimal resource utilization
• Design, develop, and automate operational and executive reports & dashboards using Power BI and Tableau; schedule and deliver them to clinical, finance, and leadership stakeholders
• Implement and enforce data security best practices
• Encryption at rest and in-transit, Role-Based Access Control (RBAC), masking of PHI/PII
• Regular access reviews and compliance with NABH, HIPAA-like standards, and IT audit requirements
• Respond promptly to internal and external audit observations; drive remediation and provide evidence of closure within stipulated timelines
• Collaborate closely with internal teams and integration partners for database upgrades, patching, migrations, and troubleshooting
• Document database structures, processes, and run-books; maintain up-to-date data dictionary and query library
• Provide 247 on-call support on a rotational basis for critical database incidents

Key Requirements

• 2-5 years of hands-on experience in Database Administration and performance tuning using Microsoft SQL Server

• Advanced proficiency in writing and optimizing complex SQL queries, stored procedures, triggers, and functions

• Experience in building automated reports and interactive dashboards using Power BI preferred
• Strong understanding of database security, encryption, RBAC, auditing, and healthcare data privacy requirements
• Exposure to healthcare IT systems (HIS, EMR, LIS, RIS) and integration with hospital workflows is a significant advantage
• Familiarity with high-availability solutions (Always-On, clustering, replication, log shipping) and backup/recovery strategies
• Good problem-solving skills and ability to work under pressure in a 24/7 clinical environment
• Relevant certifications (Microsoft DP-300, PostgreSQL Professional, Power BI Data Analyst) will be preferred
• Willingness to be based in Hyderabad and participate in on-call rotation

deepti.modani@carehospitals.com