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 optimization (using EXPLAIN), and indexing strategies. Conduct proactive monitoring of database health, capacity planning, and resource usage. Handle database patching, version upgrades, and complex migrations with minimal downtime.

DevOps & Automation (30%)

You will integrate database operations into the software development lifecycle to improve deployment speed and reliability. Infrastructure as Code (IaC): Automate database provisioning and configuration management using tools like Ansible or Terraform. Scripting: Develop automation for routine tasks (e.g., automated health checks, maintenance jobs) using Bash or Python. CI/CD Integration: Collaborate with DevOps teams to integrate schema changes and database deployments into CI/CD pipelines. Monitoring & Alerting: Set up advanced monitoring and automated alerting systems for proactive incident management.