Chief Database Architect

About our clients

Our clients focus on building a robust digital public health delivery platform, improving data-driven governance and empowering healthcare workers.

One of our clients' most successful initiatives is AMRIT (Accessible Medical Records via Integrated Technologies). AMRIT is a first-of-its-kind integrated health technology platform that supports clinical excellence for over 2 Cr beneficiaries.

Job Summary

The Data Engineer will manage and maintain DBC's core databases powering 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 Data Engineer will work closely with application developers, infrastructure teams, and business stakeholders to design, optimize, and troubleshoot database systems supporting healthcare delivery at scale.

Key Responsibilities:

Data Management:

• 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)

Database Performance:

• Monitor database performance and tune queries, indexes, and configurations to ensure optimal response times using tools like CloudWatch, Performance Insights, Grafana, or pgAdmin

Data Security:

• 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)

Automation:

• Automate routine database maintenance and deployment tasks using CI/CD pipelines, Terraform, or AWS-native services

Deployment Support:

• Support deployments by reviewing database scripts, migrations, and data patches for both on-prem and cloud environments

Troubleshooting:

• Troubleshoot database-related issues in production and non-production environments, including performance bottlenecks, connectivity issues, and cloud integration errors

Collaboration:

• Collaborate with developers to design efficient database schemas, optimize queries, and implement best practices for scalable cloud-based applications

Disaster Recovery:

• Implement and monitor disaster recovery and high-availability strategies such as clustering, replication, multi-AZ, and failover setups in cloud platforms

Documentation:

• Maintain comprehensive documentation for database configurations, processes, and cloud runbooks

Data Governance:

• Assist in building data governance frameworks and ensure compliance with organizational and regulatory standards (HIPAA, DISHA, etc.)

Reporting:

• Support reporting and analytics teams with optimized queries and data pipelines from cloud databases

Qualifications & Experience:

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

• Experience:

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

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

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

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

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

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

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

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

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