- Implement optimal backup and recovery.
- Understand and optimize query performance.
- Create and publish database health checks to monitoring systems for the following:
- Identify slow queries
- Replication lags
- Node failures
- Index usage patterns
- CPU usage
- Memory usage
- Locks
- Number of connections
- Evaluate, plan and perform the DB upgrades.
- Maintenance - during release/outage etc.
- Implementing best practices for backups, replication, and health checks.
- Database hardening - implement best practices.
- Design and implement DR plans & HA solutions and recommendations.
- Work closely with the application team to understand what changes are coming in a build/patch/hotfix, do an impact analysis, fine-tune the queries if any.
- Automate the process of deploying DB changes so that we can support this for a new build/patch/hotfix.
- Act as an application DB during the design process.
- Required Skills
- 4+ year s hands-on experience as DBA and 2+ years on MongoDB.
- Understanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code.
- Strong DBA Experience - MongoDB.
- Write effective queries.
- Strong scripting experience - Unix/Shell Scripting, Python
- Technical knowledge of Linux & Windows-based platforms
- Strong analytical and problem-solving skills
Desired Skills
- Hands-on Experience in GCP.
- Disaster Recovery and Business Continuity experience.
- Required Education
- Bachelors degree