I will optimize mysql, oracle and redis, fix sql and database issues
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.
FAQ
Which MySQL, Oracle and Redis services do you offer?
MySQL and Oracle: SQL/index tuning, deployment, backup/recovery, replication or HA review, migration and troubleshooting. Redis: standalone, Sentinel, Cluster, persistence and memory/latency tuning. Monitoring and automation are also available; we agree scope first.
Does one package include every service listed?
No. Basic covers diagnosis of one issue; Standard covers one agreed fix or tuning task on one instance; Premium covers one agreed project of up to three nodes. Share your topology and goal first so I can confirm scope. Larger work needs a custom offer.
Do you need direct access to my servers?
Initial diagnosis can use sanitized queries, plans, logs and metrics. If access is required, we agree a secure method and temporary, least-privilege permissions. Do not send passwords, private keys or unredacted customer data in the order requirements.
Can you guarantee recovery, zero downtime or a fixed speed increase?
Results depend on workload, topology, backups and data condition. I assess feasibility first and agree validation, backup, rollback and maintenance steps before production changes. I do not promise a fixed speed increase or guaranteed recovery.
Do you offer migrations, automation or ongoing support?
Yes. I can scope MySQL/Redis upgrades, migrations, backup workflows, monitoring and Go/Python automation. Ongoing support and urgent incidents require a separately agreed schedule and scope. Packages do not include unlimited work or 24/7 availability.
Can you handle large tables and online schema changes?
Yes. I assess indexes, table size, free space, replication lag and concurrent traffic, then choose a suitable approach such as gh-ost or native online DDL. We agree validation, cutover and rollback steps first. Online DDL can still involve brief locking.
Can you diagnose high CPU, memory use or replication lag?
Yes. I correlate Linux metrics with MySQL Performance Schema, execution plans, locks and replication status. I use tools such as perf or pidstat when appropriate, then deliver root-cause findings, prioritized fixes and validation.
