Database Administrator

Corishta Ltd.; Pune District; On-site; INR 1,500,000 - 3,000,000; Full time

Job summary

Corishta Ltd. is hiring a Database Administrator to maintain the integrity and availability of our data in Pune and Mumbai. You will keep MySQL running smoothly, ensure backups are real and restorable, and control who can access the data while collaborating with developers to optimize queries.

You will design schemas for long-term maintainability, investigate slow queries, and perform safe migrations during releases, prioritizing data quality and secure access across our environments.

Qualifications

• Four or more years administering MySQL or MariaDB in production.
• Strong understanding of indexing, query plans and transaction isolation.
• Practical experience with backup, restore and replication.
• Experience managing database access control and auditing who changes what.
• Careful, methodical working style given sensitive personal data.
• Experience with large relational datasets.
• Familiarity with AWS RDS or a comparable managed database service.
• Exposure to data protection requirements in India.

Responsibilities

• Monitor MySQL performance and tune the server configuration and indexes as the data grows.
• Own the backup strategy and regularly verify that backups can actually be restored.
• Manage database user accounts and access permissions, and review them periodically.
• Design and review schemas with the developers for long-term maintainability.
• Investigate slow queries and blocking issues and put in place durable fixes.
• Run migrations safely, including during releases.
• Maintain data quality checks and the procedures that keep records consistent.

Skills

MySQL administration

MariaDB administration

Query optimisation

Backup & recovery

Access control

Schema design

Monitoring

Replication

Performance troubleshooting

Tools

AWS RDS

Job description

As Database Administrator you are responsible for the integrity and availability of the data Corishta holds. You will keep MySQL running well as the volume grows, make sure backups are real and restorable, control who can reach the data and why, and work with the developers so that the queries they write do not slow the platform down.

Responsibilities

• Monitor MySQL performance and tune the server configuration and indexes as the data grows
• Own the backup strategy and regularly verify that backups can actually be restored
• Manage database user accounts and access permissions, and review them periodically
• Design and review schemas with the developers for long-term maintainability
• Investigate slow queries and blocking issues and put in place durable fixes
• Run migrations safely, including during releases
• Maintain data quality checks and the procedures that keep records consistent

Requirements

• Four or more years administering MySQL or MariaDB in production
• Strong understanding of indexing, query plans and transaction isolation
• Practical experience with backup, restore and replication
• Experience managing database access control and auditing who changes what
• Careful, methodical working style, since the data holds personal family information
• Experience with large relational datasets
• Familiarity with AWS RDS or a comparable managed database service
• Exposure to data protection requirements in India

Preferred Skills

• MySQL
• MariaDB
• Query optimisation
• Backup and recovery
• Access control
• Schema design
• Monitoring
• AWS RDS
• Replication
• Performance troubleshooting

Compensation

This is a full-time salaried position. Salary for this role is confirmed individually during the hiring process and is based on experience; no fixed figure is advertised at this stage.

Work Location

• Pune, Maharashtra
• Mumbai, Maharashtra