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.
Solid scripting experience - Unix/Shell Scripting, Python
Technical knowledge of Linux & Windows-based platforms
Robust analytical and problem-solving skills
Desired Skills
Hands-on Experience in GCP.
Disaster Recovery and Business Continuity experience.
Required Education
Bachelors degree