Database System Engineer

Client Overview

Our clients' areas of focus include developing robust digital public health delivery platforms, improving data-driven governance, and empowering healthcare professionals.

Initiative Highlight

The Accessible Medical Records via Integrated Technologies (AMRIT) platform is a groundbreaking integrated health technology platform that supports clinical excellence for over 2 crore beneficiaries.

Job Summary

The Database Specialist will be responsible for managing and maintaining core databases that power platforms like AMRIT. This role involves ensuring high availability, performance, security, and reliability of databases while supporting day-to-day operations, deployments, and data-driven decision-making. The Database Specialist will collaborate with application developers, infrastructure teams, and business stakeholders to design, optimize, and troubleshoot database systems that support healthcare delivery at scale.

Key Responsibilities:

• Install, configure, upgrade, and maintain relational database systems (e.g., MySQL, SQL Server, Oracle as applicable) both on-premises and on cloud (AWS RDS, Aurora, Azure SQL, GCP Cloud SQL)
• Monitor database performance and tune queries, indexes, and configurations to ensure optimal response times using tools like CloudWatch, Performance Insights, Grafana, or pgAdmin
• Ensure data security, integrity, backup, and recovery processes are in place and regularly tested using both traditional and cloud-native approaches (snapshots, automated backups, cross-region replication)
• Automate routine database maintenance and deployment tasks using CI/CD pipelines, Terraform, or AWS-native services
• Support deployments by reviewing database scripts, migrations, and data patches for both on-prem and cloud environments
• Troubleshoot database-related issues in production and non-production environments, including performance bottlenecks, connectivity issues, and cloud integration errors
• Collaborate with developers to design efficient database schemas, optimize queries, and implement best practices for scalable cloud-based applications
• Implement and monitor disaster recovery and high-availability strategies such as clustering, replication, multi-AZ, and failover setups in cloud platforms
• Maintain comprehensive documentation for database configurations, processes, and cloud runbooks
• Assist in building data governance frameworks and ensure compliance with organizational and regulatory standards (HIPAA, DISHA, etc.)
• Support reporting and analytics teams with optimized queries and data pipelines from cloud databases

Desirable Qualification & Experience:

Qualifications:

• Bachelor's/Master's degree in Computer Science, Information Technology, or a related field

Experience:

• Strong hands-on experience with MySQL (experience in SQL Server/Oracle is a plus)

• Expertise in database monitoring and observability tools (e.g., pgAdmin, Prometheus, Grafana, CloudWatch, New Relic, Performance Insights)

• Deep understanding of query optimization, indexing strategies, and performance tuning in high-transaction environments

• Experience with backup, recovery, replication, clustering, and failover strategies (on-premises and cloud)

• Familiarity with Linux environments, shell scripting, and automation tools (Ansible, Terraform, CI/CD pipelines)

• Good understanding of APIs, application-database interactions, and deployment workflows in microservices-based architectures

• Hands-on experience with cloud-based databases such as AWS RDS, Aurora, Azure SQL, or GCP Cloud SQL — including provisioning, scaling, security, and monitoring

• Knowledge of data governance, compliance standards, and healthcare data privacy regulations (like GDPR, DPDPA) is an advantage

• Prior exposure to healthcare or health-tech systems is a plus