Ishan Technologies - Database Administrator - MySQL

Description :

Role Summary :

The ideal candidate will ensure the availability, reliability, and performance of database systems, support application teams, and implement best practices in database administration, security, and backup strategies.

Key Responsibilities :

- Install, configure, and maintain MySQL databases for production, staging, and development environments.

- Monitor database performance, identify bottlenecks, and optimize queries, indexes, and schema.

- Ensure high availability, backup, and disaster recovery strategies are in place.

- Implement database security measures, including user access management, encryption, and auditing.

- Perform regular database maintenance tasks : patching, upgrades, and tuning.

- Collaborate with development and DevOps teams to support application deployment and database integration.

- Create and maintain documentation for database architecture, configuration, and processes.

- Troubleshoot database-related issues and provide timely resolutions.

- Participate in capacity planning and database architecture decisions for scalability and performance.

- Automate repetitive database tasks using scripts or tools.

Required Skills & Experience :

- Bachelors degree in Computer Science, Information Technology, or related field.

- 3+ years of experience as a Database Administrator, specifically with MySQL.

- Strong understanding of MySQL architecture, replication, clustering, and backup strategies.

- Proficiency in SQL query optimization, indexing, and performance tuning.

- Experience with database monitoring and alerting tools.

- Familiarity with Linux/Unix environments for database deployment and maintenance.

- Knowledge of database security, user management, and access control.

- Experience with automation and scripting (Python, Shell, or Perl) for DBA tasks.

- Familiarity with cloud database platforms (AWS RDS, Azure Database, GCP Cloud SQL) is a plus