Senior Mysql DBA

Key Responsibilities

• Deploy, manage, and optimize MySQL clusters (Replication, GTID, High Availability solutions).
• Administer Redis clusters (Replication, Sentinel, Cluster mode).
• Diagnose and resolve production issues including slow queries, replication lag, lock contention, resource bottlenecks, and instance failures.
• Perform SQL optimization, index tuning, and execution plan analysis.
• Design and maintain backup, recovery, and disaster recovery strategies.
• Monitor database health using Datadog / Prometheus / Grafana and improve alerting frameworks.
• Develop automation scripts (Shell / Python) to enhance operational efficiency.
• Conduct capacity planning, performance benchmarking, and cost evaluations (cloud vs. self-managed).
• Manage database security, access control, and audit requirements.
• Lead incident response and produce structured post-incident analysis.

Qualifications
Required:

• 5+ years of MySQL production operations experience.
• Strong understanding of InnoDB internals (transactions, locking, MVCC).
• Experience with MySQL replication and high-availability architectures.
• Hands-on SQL performance tuning experience.
• Production Redis experience.
• Experience with Kafka or RabbitMQ.
• Strong Linux troubleshooting skills.
• Scripting ability in Shell or Python.
• Fluent in spoken Mandarin and written Chinese; ability to read, write, and communicate professionally in Chinese is required.