MySQL DBA Postgre SQL

Full Job Description
Job description

We are looking for candidate with 6+ years experience as a DBA for MySQL and 2+ years of experience with PostgreSQL in a 24/7 production environment including backup recovery, replication, high availability, designing and managing schema, monitoring diagnosing and optimizing database performance

· Design, develop and administer business application databases and associated program software in current and future Database and Application Infrastructure including Application Hosting Technologies, MySQL environments.

· Undertake performance monitoring and tuning, problem resolution, availability management, capacity management, change management and security access management to ensure the continuous provision of service of the database and integrated platform environments.

· L3/L4 experience on MangoDB With MySQL being the primary skill.

· AWS MySQL knowledge will give plus

· Installation of RPM and Binaries .

· Hands on experience in sql server programming.

· Knowledge on Mysql server database objects like indexes, views, tables.

· Knowledge on Mysql programming.

· Experience on different storage engines like Innodb, MyISAM.

· Configuring MySQL server With InnoDB Storage Engine.

· Configuring Master-Slave and Master-Master Replications and GTID and Galera Cluster setups and their monitorings .

· Troubleshooting Replication/Cluster Issues.

· Experience in Disaster Recovery.

· Increased database performance by utilizing MySQL config changes.

· Experience in user management.

· Administrator privileges, Revoking privileges, removing users.

· Performance tuning of mysql database and query optimization.

· Backup and Restore using MySQL Dump and Percona Xtrabackup .

· Troubleshooting/Managing MySQL in production and maintenance environments on both Linux

· Good understanding on the MySQL internals.

· Experience in mysql version 5.5 , 5.6 ,5.6, 5.7 and 8.0

Job Types: Full-time, Regular / Permanent

Pay: ₹500,000.00 - ₹1,500,000.00 per year

Benefits:

Work from home
Schedule:

Monday to Friday
Night shift
Experience:

total work: 6 years (Preferred)
MySQL: 5 years (Preferred)
PostgreSQL: 2 years (Preferred)