MySQL DBA

Location : Hyderabad (WFO)

Experience Level: 4-6 yrs

Core Skills:

MySQL:

• Administration: Installation, configuration, upgrades, backups/restores, user management, performance tuning, security hardening, replication, clustering (MySQL Group Replication, Galera), partitioning
• Development: SQL (SELECT, INSERT, UPDATE, DELETE, JOINs, subqueries, stored procedures, functions, triggers, views)
• Troubleshooting: Performance issues, replication errors, data corruption, security breaches
• Storage Engines: InnoDB, MyISAM, Memory
• High Availability & Disaster Recovery (HA/DR): Replication topologies, failover procedures, RTO/RPO, DR drills
• Monitoring & Alerting: Performance monitoring tools (e.g., MySQL Enterprise Monitor, Percona Monitoring and Management (PMM)), setting up alerts, log analysis
• Security: User management, access control (RBAC), encryption, data masking, security audits
• Scripting: Shell scripting (Bash, etc.), Python (for automation)
• Cloud Platforms (if applicable): AWS RDS, Azure SQL Database, Google Cloud SQL

Advanced Skills:

• Performance Optimization: Query optimization techniques (indexing, query rewriting, EXPLAIN plan analysis), slow query analysis, tuning server parameters
• Clustering: Advanced cluster configurations, troubleshooting cluster issues
• Replication: Advanced replication setups (multi-source replication, cascading replication)
• Database Design: Normalization, denormalization, data modeling, schema design
• Troubleshooting Complex Issues: Deep dive into performance bottlenecks, replication failures, and other critical issues