Venkata
Bengaluru, Bangalore Division, Karnataka, India
Experience: 4 years
Open to: Full-Time, Part-Time
Education: Bachelors
Availability: Within 30 Days
Skills: AWS, MongoDB, MySQL
Previously worked at: Product Companies
Assessment Score: 50
- Professional Experience: Over 2 years of experience as a MySQL Database Administrator (DBA), with expertise in installation, configuration, and maintenance of MySQL Servers (5.7/8.0), and experience managing both production and development databases.
- Database Administration & Security: Proficient in user management, permissions, backups, restoring databases, and security implementations according to CIS Security Policies. Experienced in configuring MySQL parameters for optimization and managing high availability solutions like Master-Slave and Master-Master replication.
- Performance Optimization: Skilled in analyzing performance bottlenecks at the database and server level, using tools like performance monitors, query tuning, and optimizing indexes to improve database and server performance. Strong experience in troubleshooting issues related to CPU, memory, and I/O statistics.
- Backup & Recovery Management: Hands-on experience in performing logical backups (MySQL dump, MySQL pump) and implementing Point-In-Time Recovery (PITR) using binary logs, alongside crash recovery techniques and database object optimizations.
- Project Management & Support: Responsible for providing 24/7 production support, attending daily calls, resolving troubleshooting tickets, and collaborating with developers to deploy data on production environments. Led MySQL version upgrades and managed data migration processes.
- Technical Skills & Tools: Proficient in using Unix/Linux shell commands, MySQL, SQL, and familiar with various database tools. Adept at handling server-level optimizations, performance tuning, and ensuring smooth operational continuity through comprehensive monitoring and regular backups.