Database MySQL Assistant

EXPERIENCE AND EDUCATION:

Essential Qualifications/Experience:

·         Strong administration of MySQL (preferably 8.0+)

·         Knowledge of SQL optimization, indexing, and query execution plans

·         Expert knowledge on backup/restore (e.g., mysqldump, mysqlpump, Percona XtraBackup or equivalent) and point-in-time recovery

·         Linux fundamentals (system resources, I/O, file systems, network basics) relevant to database performance

·         Security best practices (TLS, privilege management, audit/logging, secure configuration)

·         Knowledge on a second database technology like PostgreSQL, Microsoft SQL Server

·         Automation/SRE mindset: scripting (Bash/Python/Perl)

·         5+ years hands-on MySQL DBA experience in production environments

·         Demonstrated experience supporting business-critical systems with defined SLAs

·         Proven track record in performance troubleshooting and incident handling

DUTIES/ROLE: 

·         Operational DBA Duties

ü  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)