Database Administrator

Database Administration & Maintenance (70%)

Your primary responsibility is ensuring the high availability, security, and integrity of MySQL, PostgreSQL, and MongoDB environments.

Cluster Management & High Availability:

Set up and maintain MySQL Master-Slave replication. •Configure and manage Percona XtraDB Cluster (PXC) and MySQL InnoDB Clusters for high availability and fault tolerance. •Manage PostgreSQL streaming/logical replication and MongoDB Replica Sets/Sharded Clusters.

Backup & Disaster Recovery:

Design and implement robust strategies for Backup and restore using physical and logical methods. •Manage Incremental Backups and perform Point-In-Time Recovery (PITR) to minimize data loss during failures. •Regularly test recovery procedures to ensure data consistency and reliability.

Performance & Health:

•Execute Performance Tuning, query optimizati...