Implement appropriate indexes for performance improvement.
Fine-tune configurations MySQL 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 as DBA on MySQL
Experience on MSSQL and Snowflake databases is added benefit.
Understanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code.
Write efficient queries.
Technical knowledge of Linux Windows-based platforms