ValueLabs - MySQL Developer - Performance Tuning

Description :

Key Responsibilities :

- Design, develop, and maintain high-performance MySQL databases for enterprise applications.

- Write and optimize complex SQL queries, stored procedures, triggers, and functions.

- Perform database schema design, normalization, indexing, and partitioning for optimal performance.

- Implement database security practices: role-based access control, encryption (at rest/in transit), audit logging.

- Conduct performance tuning using EXPLAIN plans, query optimization, and profiling tools.

- Manage database backups, replication, failover, and disaster recovery strategies (e.g., MySQL Replication, Galera Cluster).

- Collaborate with DevOps teams to integrate database changes into CI/CD pipelines (Jenkins, GitLab CI, Azure DevOps).

- Support database migrations (e.g., from legacy systems, Oracle, PostgreSQL to MySQL).

- Document database architecture, data models, and operational procedures.

- Troubleshoot production database issues, including deadlocks, replication lag, and slow queries.

- Work in Agile/Scrum environments using JIRA, Confluence, and sprint planning.

Required Skills & Qualifications :

- Bachelors degree in Computer Science, Engineering, or related field.

- 4+ years of hands-on experience in MySQL database development and administration.

- Proficiency in SQL, stored procedures, triggers, views, and functions.

- Strong understanding of database design principles, normalization, and data modeling.

- Experience with MySQL 5.7, 8.0+, including replication, clustering, and high availability setups.

- Familiarity with MySQL Workbench, phpMyAdmin, MySQL Shell, and command-line tools.

- Experience with performance monitoring and tuning using tools like Percona Monitoring & Management (PMM), Prometheus, Grafana.

- Knowledge of backup and recovery strategies (e.g., mysqldump, xtrabackup, Point-in-Time Recovery).

- Understanding of database security (user roles, privileges, SSL/TLS, audit logs).

- Experience in CI/CD integration for database changes (e.g., Liquibase, Flyway, Git-based schema versioning).

- Experience working in Agile/Scrum teams using JIRA and Confluence.

- Exposure to cloud-based MySQL services (AWS RDS, Google Cloud SQL, Azure Database for MySQL).

- Exposure to DevOps practices (Terraform, Ansible, Docker) for database provisioning.