Round 1: Technical Screening (Hands-on / Theoretical)
Database Management (MySQL)
Advanced SQL queries, indexing, query optimization, execution plans.
Backup and recovery strategies (logical vs physical backups, mysqldump, Percona XtraBackup, point-in-time recovery).
Replication setup and troubleshooting (asynchronous, semi-synchronous, GTID-based replication, lag handling).
High availability concepts (failover, clustering, ProxySQL, load balancing).
Security best practices (user management, access control, encryption).
Linux Administration
Basic and advanced shell commands, scripting for automation.
Process management, monitoring system performance (CPU, memory, I/O).
Disk/storage management and troubleshooting.
Networking basics (firewall, ports, SSH, connectivity).
Log management and debugging (journalctl, syslog, error logs).
AWS Cloud Fundamentals
RDS and Aurora MySQL configuration, monitoring, and scaling.
Backup and snapshot strategies in AWS.
IAM roles and security best practices.
Networking concepts (VPC, subnets, security groups).
CloudWatch and performance monitoring.
