Implement appropriate indexes for performance improvement.
Fine-tune configurations MongoDB and servers for performance improvement.
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
Any other relevant params
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, and fine-tune the queries if any.
Qualifications & Skills required:
BS in Engineering, Computer Science, or related discipline.
Excellent Communication and Interpersonal skills
6+ year s hands-on strong experience on MongoDB and MySQL
Understanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code.
Write efficient queries.
Technical knowledge of Linux & Windows-based platforms
.png&w=256&q=75)
