I will design and optimize your postgresql or oracle database
About this Gig
Slow queries or messy schema? I design clean relational databases and make
slow ones fast.
I provide:
- Database schema design (tables, relationships, constraints, indexes)
- Slow query analysis and optimization
- Index tuning and EXPLAIN plan review
- SQL writing and refactoring (joins, aggregates, stored procedures)
- JPA/Hibernate mapping and performance fixes (N+1 query removal)
- Data modeling for new applications
Works with PostgreSQL, Oracle, and MySQL. You get clean SQL, clear
explanations, and measurable performance improvements.
Message me before ordering with your schema or slow query so I can scope the
work.
Platform:
MongoDB
•
MySQL
•
Oracle
•
PostgreSQL
Expertise:
Normalization
•
SQL
•
Performance
•
Query optimization
My Portfolio
FAQ
Can you optimize queries without changing my app code?
Often yes — through indexes and query rewrites. If app/ORM changes are needed, I'll tell you upfront.
Do you provide the SQL scripts?
Yes. You get ready-to-run SQL for schema and indexes, plus an explanation of each change.
Can you measure the improvement?
Yes. I share before/after EXPLAIN plans or timings so you see the gain.
