Dilip M.

I have hands on experience in Postgresql, Mysql, and mariadb Role and responsibility 1. Installation. 1.1 Source code installation. 1.2 Rpm installation. 1.3 Tar ball installation 2. Back up and recovery. 2.1 Logical level 2.1.1 Data base level. 2.1.2 Table level. 2.1.3 Schema level. 2.2 physical level backup 2.2.1 Base Backup/mount point level. 2.3 PITR(POINT IN TIME RECOVERY) 3. User management. 4. Replication. 4.1 Master slave in mysql/streaming replication postgresql. 4.2 gtid replication in mysql/logical replication postrgres. 4.2 innodb Cluster setup/group replication 5. Database Upgradation. 5.1 Logical level upgrade. 5.2 Physical level upgrade. 6. Maintenance of the database. 6.1 Database level. 6.2 Table level. 7. Monitoring database. 7.1 Os level. 7.1.1 Physical data base Mount point. 7.1.2 Check services running like. Postgresql | Mysql | Mariana. 7.1.3 Memory check. 7.1.4 Resources check like cpu and load on server. 7.2 Mysql | Postgresql Data base level. 7.2.1 Data base size. 7.2.2 Active session. 7.2.3 Long running query. 7.2.4 log file monitoring. 7. Troubleshooting. 8. DR Drill. Switchover and Switchback. 9. HA Innodb cluster in mysql 9. Resolve Real time issues on database. 10. Performance related issue resolve. Note. I have a team of database admin and have excellent knowledge about the database