Required Skills:
- Experience level: 5+ Years
- 5+ years of hands-on experience with MySQL (8.0+ preferred), including performance tuning and high-availability setups
- Need an associate to work from Hyderabad office (Mon-Fri)
About the Role:
As a MySQL Developer, you will be responsible for designing, implementing, optimizing, and securing the relational database systems.
Responsibilities:
- Design and implement scalable, normalized MySQL database schemas
- Optimize database performance through indexing, query tuning, partitioning, and replication strategies
- Develop and maintain stored procedures, triggers, and functions for business logic execution within the database layer
- Ensure data integrity using constraints, foreign keys, and transaction management
- Implement robust backup and disaster recovery plans using MySQL native
- Enforce security best practices: role-based access control (RBAC), encryption at rest and in transit, audit logging, and least-privilege principles
- Monitor database health using tools like Percona Monitoring and Management (PMM), Prometheus, or custom dashboards
- Document database architecture, schema changes, and migration scripts using version-controlled systems
- Support compliance with data protection standards such as GDPR, CCPA, and ISO 27001especially relevant for handling member data
- Assist in migrating legacy systems or integrating third-party services
Qualifications:
- 5+ years of hands-on experience with MySQL (8.0+ preferred), including performance tuning and high-availability setups
- Proven experience with database migration tools (Liquibase, Flyway, or similar)
- Strong understanding of ACID properties, transaction isolation levels, and locking mechanisms
- Experience with MySQL replication (master-slave, multi-source) and clustering (MySQL InnoDB Cluster, Group Replication)
- Proficiency in writing complex SQL queries, optimizing execution plans, and using EXPLAIN effectively
- Familiarity with containerized environments (Docker, Kubernetes) and cloud platforms (AWS RDS, Google Cloud SQL, Azure Database for MySQL)
- Experience with security hardening of MySQL instances (e.g., disabling default accounts, setting strong passwords, firewall rules)
- Knowledge of data privacy laws and experience handling sensitive personal data ethically
