You will get high database performance after reviewing and tuning in a day or a week
Project details
Hello,
I have been working with database systems, including Oracle, PostgreSQL, MS SQL, and MySQL, for over 18 years in various industries such as retail, telecom, insurance, real estate, and public finance. As a DBA,
Especially, I consistently optimize performance by advising developers on SQL tuning, including SELECT statements with multi-table joins, group by, and order by clauses..
According to my observations, SQL queries account for 70% of database performance, with the remaining 30% coming from database configuration and data structures.
I always focus on the following key points:
• SQL query tuning: SQL query with sub-queries, "group by," "order by," etc..
• Adjusting the partitions, tables, and indexes in a database that go along with SQL queries.
• If required, adjust the RAM, buffer, and cache options in the database.
I will need a READ-ONLY database user to determine the root cause. The report will then be shared with you, along with tuning suggestions and the underlying reason for the performance problems.
In the next step, resolving the problem, I will provide you with detailed (step-by-step) instructions, including the DDL scripts.
Best regards,
Henry,
I have been working with database systems, including Oracle, PostgreSQL, MS SQL, and MySQL, for over 18 years in various industries such as retail, telecom, insurance, real estate, and public finance. As a DBA,
Especially, I consistently optimize performance by advising developers on SQL tuning, including SELECT statements with multi-table joins, group by, and order by clauses..
According to my observations, SQL queries account for 70% of database performance, with the remaining 30% coming from database configuration and data structures.
I always focus on the following key points:
• SQL query tuning: SQL query with sub-queries, "group by," "order by," etc..
• Adjusting the partitions, tables, and indexes in a database that go along with SQL queries.
• If required, adjust the RAM, buffer, and cache options in the database.
I will need a READ-ONLY database user to determine the root cause. The report will then be shared with you, along with tuning suggestions and the underlying reason for the performance problems.
In the next step, resolving the problem, I will provide you with detailed (step-by-step) instructions, including the DDL scripts.
Best regards,
Henry,
Database Type
MySQL, MS SQL, MS Access, Oracle, SQLite, PostgreSQL, MongoDBWhat's included
| Service Tiers |
Starter
$150
|
Standard
$800
|
Advanced
$2,000
|
|---|---|---|---|
| Delivery Time | 1 day | 7 days | 30 days |
Number of Revisions | 0 | 2 | 4 |
Number of Tables Added | 0 | 2 | 6 |
Schema Diagram | - | - | |
Permissions Setup | |||
Import/Export Data | - | ||
Admin Panel Setup | - | - |
Optional add-ons
You can add these on the next page.
Additional Revision
+$150
Additional Table Added
(+ 1 Day)
+$80
Schema Diagram
(+ 2 Days)
+$150
Import/Export Data
(+ 1 Day)
+$150
Admin Panel Setup
(+ 3 Days)
+$250
35 reviews
(32)
(3)
(0)
(0)
(0)
This project doesn't have any reviews.
MV
Maxim V.
Jun 9, 2026
Help with fixing MySQL master-master replication issues
Henry is a very highly skilled professional. He helped us to fix very difficult database replication issues.
SL
Sheldon L.
Sep 3, 2025
Setup MySQL Master-slave replication using existing config files
Great job!
AG
Akesh G.
Aug 28, 2025
30 minute consultation
TM
Todd M.
Dec 1, 2024
MySQL Database and Query Optimization Specialist
jm
jack m.
Nov 25, 2024
DB scripting support needed and optimisation queries
Henry is an expert in DB tasks and has worked his way in resolving issues. He has diligently worked on the task and professionally supported and has the right skills etc and expertise.
About Henry
Database Expertise: Performance Tuning & Solutions
100%
Job Success
Hanoi, Vietnam - 9:35 am local time
My core strengths include:
Performance Tuning & Troubleshooting: SQL query optimization, indexing, partitioning, memory/I/O tuning, and real-time issue resolution.
Database Administration: Installation, upgrades, backup/recovery, high availability (RAC, Always On, replication), and security hardening.
Data Architecture & Warehousing: Designing scalable schemas, star models, and ETL pipelines for BI and analytics.
Business Intelligence Integration: Power BI, Tableau, SAP BO, and advanced reporting solutions.
I deliver robust, secure, and high-performing database environments that empower organizations to scale confidently and make data-driven decisions. Whether on-premises or in the cloud, I ensure your systems run at peak efficiency with minimal downtime.
Steps for completing your project
After purchasing the project, send requirements so Henry can start the project.
Delivery time starts when Henry receives requirements from you.
Henry works on your project following the steps below.
Revisions may occur after the delivery date.
Offer review and accept.
I will review the offer and discuss with the client for more contract detail: milestone, communication methodology, handover documentations...
Start working with the client
Job start with agreements for: milestones, delivery date, documentation.