Role Summary
We are seeking a highly skilled and proactive Database Administrator with strong expertise in PostgreSQL and/or MongoDB database administration. The ideal candidate will be responsible for database administration, high availability, backup and recovery, security, and operational support of mission-critical database environments. Experience with distributed databases such as YugabyteDB will be an added advantage.
Key Responsibilities
Database Administration
- Install, configure, upgrade, patch, and maintain PostgreSQL and/or MongoDB environments.
- Manage database health, availability, performance, and capacity planning.
- Perform database migrations, refreshes, and setting provisioning.
- Administer database users, roles, permissions, and security policies.
- Ensure compliance with organizational security and audit requirements.
High Availability & Disaster Recovery
- Configure and manage replication technologies.
- Manage clustering, failover, and disaster recovery solutions.
- Perform backup and recovery operations and conduct recovery drills.
- Ensure database resiliency and business continuity.
Performance & Optimization
- Monitor and optimize database performance.
- Analyze query execution plans and recommend tuning strategies.
- Optimize indexes, database objects, and configurations.
- Troubleshoot database bottlenecks and production incidents.
Monitoring & Automation
- Implement and maintain monitoring, alerting, and reporting solutions.
- Automate routine DBA tasks using scripts and tools.
- Develop operational runbooks and standard procedures.
Production Support
- Provide L2 support for production environments.
- Participate in on-call support and incident management.
- Ensure SLA adherence and timely issue resolution.