I will optimize sql queries and improve postgresql database performance
Senior Mobile and Web Developer MVP and AI Solutions
About this Gig
Is your SQL query slow, failing, or becoming difficult to maintain?
Im a UK-based senior software developer and data professional with extensive experience working with SQL, PostgreSQL, Supabase and enterprise data platforms.
I can help with:
Slow SQL query optimisation
PostgreSQL performance tuning
EXPLAIN / EXPLAIN ANALYZE reviews
Index optimisation
Complex joins and reporting queries
Views, functions and stored procedures
Database schema improvements
Supabase PostgreSQL optimisation
SQL errors and debugging
Data transformation and aggregation
Query refactoring and clean-up
My focus is not just making a query work I aim to make it fast, reliable and maintainable.
Where appropriate, I will explain the cause of the performance issue and the changes made so you understand the solution.
Please contact me before ordering for large databases, production systems or complex performance issues so I can confirm the scope first.
My Portfolio
FAQ
Should I contact you before placing an order?
Yes. For larger databases, production systems or complex performance issues, please contact me first so I can review the scope and recommend the correct package.
Which databases do you work with?
I primarily work with PostgreSQL, Supabase PostgreSQL and SQL Server, and I can also help with general SQL query optimisation and database logic.
Can you optimise slow SQL queries?
Yes. I can review execution plans, joins, filters, indexes, aggregations and query structure to identify performance bottlenecks.
Can you work with Supabase?
Yes. I can help optimise Supabase PostgreSQL queries, functions, views, indexes and database logic.
Do you need access to my production database?
Not always. In many cases, SQL scripts, schema details, sample/anonymised data and EXPLAIN ANALYZE output are enough. If live access is required, read-only access is preferred where possible.
Can you fix stored procedures, functions and views?
Yes. I can troubleshoot, refactor and optimise database functions, stored procedures and views.
Will you explain what was changed?
Yes. Where appropriate, I will explain the cause of the issue and the changes made so the solution is understandable and maintainable.

