I will optimize mysql, oracle and redis, fix sql and database issues

China

I speak English

MySQL and Redis DBA, SQL Optimization and Data Recovery

Senior DBA with over 10 years in MySQL, Redis and Oracle. I diagnose slow SQL, replication lag, locking and memory issues, and plan database recoveries and changes. MySQL: EXPLAIN/index tuning, GTID ...
About this Gig

Slow SQL, replication lag or database errors? I am a DBA with over 10 years of experience in MySQL, Oracle and Redis.


MYSQL

SQL/index tuning with EXPLAIN and Performance Schema; locks, deadlocks, CPU and memory diagnosis; GTID replication; XtraBackup/binlog recovery; gh-ost online DDL, migrations and upgrades.


ORACLE

Database administration, SQL/index performance tuning, backup/recovery planning, high availability review, migration and production troubleshooting.


REDIS

Standalone, Sentinel and Cluster; replication/failover; RDB/AOF persistence; memory, eviction, hot/big keys and latency optimization.


OPERATIONS

Monitoring, capacity checks, SQL auditing, access controls, DataX migration and Go/Python automation.


You receive root-cause findings, scoped actions, validation and handover notes. Production changes follow an agreed backup, rollback and maintenance plan.


Message me before ordering with versions, topology, symptoms and goals. Each package covers one agreed scope. Large migrations and ongoing support need a custom offer. Recovery and performance depend on your data and workload.

Expertise:

Administrator

•

Backup & recovery

Database type:

Distributed database

•

Key-value database