• Install, configure, maintain, and upgrade MySQL instances (standalone and/or clustered);
• Perform routine maintenance (schema housekeeping, index maintenance, statistics updates, data retention support);
• Manage users, roles, privileges, and authentication methods according to least-privilege principles;
• Manage storage growth and capacity forecasting (disk usage, table growth trends, partitioning/archiving recommendations);
• Maintain environment consistency across DEV/UAT/PROD where applicable.

Performance & Query Optimization:

• Analyze and optimize performance using tools and logs (slow query log, performance_schema, EXPLAIN/EXPLAIN ANALYZE);
• Provide indexing strategy and implement approved indexes/changes;
• Tune MySQL/InnoDB parameters (buffer pool, redo logs, flush behaviour, connection/thread settings, temp tables, etc.);
• Identify and remediate lock contention, deadlocks, replication delays, and inefficient access patterns.

Availability, Replication & Disaster Recovery:

• Design and operate backup strategies (logical/physical backups, binlog retention, encryption where required);
• Execute and document restore tests on a defined cadence to validate RPO/RTO objectives.

Security & Compliance:

• Apply MySQL hardening standards (secure configs, TLS in transit, encryption at rest if supported, restricted remote access);
• Manage patching and upgrades including risk/impact assessment and change planning;
• Support audit/compliance requirements (access reviews, evidence gathering, logging and retention).

Monitoring, Incident Response & Problem Management:

• Implement/maintain monitoring and alerting (e.g., PMM, Prometheus/Grafana, cloud-native monitoring);
• Define alert thresholds and reduce noise (actionable alerts, escalation paths);
• Provide incident triage and resolution within agreed service hours and severity targets;
• Conduct root cause analysis for major incidents and deliver corrective/preventive actions;
• Maintain operational documentation (backup/restore, failover, replication fixes, common performance issues).