I will optimize slow oracle, mysql or postgresql queries and fix sql bugs
About this Gig
Slow reports? Timeouts? Procedures that take hours?
I'm a Lead Developer with 8 years of hands-on Oracle and MySQL work in fintech, where performance really matters.
WHAT I DO
Optimize slow SQL queries and execution plans
Fix and write PL/SQL packages, procedures and triggers
Replace row-by-row code with BULK COLLECT / FORALL
Add or fix indexes on large tables
MySQL and PostgreSQL stored procedures and query tuning
Explain clearly what was wrong and what I changed
WHAT I NEED
The slow query/procedure, table structures and row counts
Execution plan if available (I can guide you)
Please message me before ordering so I can confirm the scope.
Database type:
Relational database
Platform:
MySQL
•
Oracle
•
PL/SQL
•
PostgreSQL
Expertise:
Data warehouse
•
SQL
•
Performance
•
Query optimization
FAQ
Do you need access to my database?
No. Sharing the query, structures and execution plan is usually enough. If access is needed, read-only access is fine.
Which versions do you support?
Oracle 11g–23ai, MySQL 5.7/8, PostgreSQL 12+.

