Job Description

What You will do:

• Installing various versions of MySQL( like 5.x/8.x )/MariaDB on Linux , Windows, and other operating systems in both on-premise and on Cloud like AWS, Azure, etc.,
• Managing Cloud(AWS/Azure) Managed MySQL/MariaDB.
• Areas of experience include Installation, Creation, and Maintenance of Databases.
• Taking online and offline backups, Managing daily, weekly backups.
• Responsible for weekly DB maintenance, and 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, and minor upgrades on production, pre-prod, and development database instances
• Troubleshooting major incidents, connectivity issues, performance, and 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, and daily backups.
• Adhering to security norms and providing database users 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 my.cnf file

Expertise You Will Bring:

• Installation in MySQL/MariaDB server database with platforms like Linux, Windows, and other OS.
• Experience in working with managed databases on the cloud like AWS RDS.
• Experience in incremental backup and schedule backup.
• Experience with MySQL/MariaDB Replication (Master-Slave).
• Expertise in snapshot, import/export, and DB optimization with the help of explained plans.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.
• 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 in database backup and restore.
• Experienced in upgrading MySQL/MariaDB server using in-place upgrade method for minor releases and logical upgrade method for major releases followed by MySQL/MariaDB Upgrade utility.

Skills mysql, database Administration, mariadb, Sequal, ReplicationAbout CompanyWe at MSPIRE Ventures offer quality Staffing Agency services to place the right people with the right jobs across India. Whether you are looking to hire new staff or find a new job, we\xe2\x80\x99re happy to offer you our services. Apart from this we are dealing in Contractual staffing, payroll services and RPO. Call us up to arrange an appointment. We\xe2\x80\x99ll have your hiring or job-seeking needs met in lowest turn around time (TAT) by our team of expert recruiters.We are an Early age startup, founded by younger entrepreneurs in Recruitment Consulting, Staffing & Payroll Services, headquartered in Ahmedabad with a dedicated team of more than 50+ highly qualified and professional,domain expert recruiters delivering quality recruitment and staffing solutions.We are currently based in Ahmedabad, Mumbai, Pune, Gurgaon but we serve across India.

Mspire Ventures