MySQL Dba - Hyderabad, India - OvalEdge

Description

• Installation in MySQL/MariaDB server database with platforms likeLinux, Windows&AWS
• Installing various versions of MySQL(like 5.x/8.x)/MariaDB on Linux, Windows&AWS
• Areas of experience include Installation, Creation and Maintenance of Databases.
• Experience in performance tuning, MySQL/MariaDB Circular, Master/Master and Master/Slave Replication and Percona Xtra DB cluster and resolving Lock and I/O Buffer contention issues.
• Experience on database backup and restore.
• Experience on incremental backup and schedule backup.
• Experience on MySQL/MariaDB Replication (Master-Slave).
• Expertise in snapshot, import/export, db optimization with the help of explain plan.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.
• Taking online and offline backups, Managing daily, weekly backups.
• Responsible for weekly DB maintenance, production database release tasks.
• Worked with storage engines MyISAM, InnoDB, Memory etc.
• Installing MySQL/MariaDB with source and binary distribution.
• Perform security patching, bug fixes, minor upgrades on production, preprod and development database instances
• Troubleshooting major incidents, connectivity issues, performance, database slowness issues for database instances.
• Monitoring performance and availability of databases during business hours and on call hours.
• Automating daily/recurring tasks such as user creation, log purging, daily backups.
• Adhering to security norms and provide database user with privileges as per decided standards. Database user role creation.
• MySQL/MariaDB replication setup, MySQL innodb cluster, MySQL NDB cluster, MariaDB Galera cluster.
• Basic experience in bash shell scripting.
• MySQL/MariaDB server best practices configurations using file
• Experienced in upgrading MySQL/MariaDB server using inplace upgrade method for minor releases and logical upgrade method for major release followed by MySQL/MariaDB Upgrade utility

• Day shift

• Hyderabad, Telangana: Reliably commute or planning to relocate before starting work (required)