Browse categories
Explore
Fiverr Pro
English
$
USD
I will database queries, design schemas and fix performance
Software Engineer
I am a proactive Software Engineer with a strong understanding of object-oriented programming, data modeling, and modern system development. I have experience in architectural patterns like microservi...
About this Gig
Is your application slowing down due to sluggish database performance? Don't let unoptimized queries ruin your user experience. Let's fix it.
I am a Software Engineer specializing in relational databases. I will analyze, refactor, and tune your PostgreSQL database to achieve lightning-fast response times and robust data integrity.
What I Can Do For You:
- Query Optimization: Rewriting slow queries, fixing complex JOINs, LATERAL subqueries, and JSONB handling.
- Index Tuning: Applying proper indexing strategies to eliminate full table scans.
- Schema Design: Designing normalized, scalable table structures and relationships.
- EF Core Optimization: Fixing inefficient LINQ queries and array unnesting issues.
- Stored Procedures & Triggers: Building or debugging database-level automation and integrity.
Why Choose Me?
- In-depth knowledge of PostgreSQL internals and transactional integrity.
- Production-safe optimizations that protect your data.
- Clear explanations of the bottleneck and the solution.
Every database is unique. Please send me a message with your current setup and logs before placing an order so we can plan the best fix!
Database type:
Non-relational database
•
Relational database
Platform:
MongoDB
•
PostgreSQL
•
SQLite
•
SQL Server
Expertise:
SQL
•
NoSQL
•
Performance
•
Query optimization
FAQ
What do you need to start optimizing my database?
I need the specific slow SQL query or the table schemas (DDL script), an explanation of the bottleneck, and if possible, the query execution plan (EXPLAIN ANALYZE output).
Will my production data remain secure?
Absolutely. I do not need access to your live production data. We can work entirely using obfuscated dummy data, a mock schema, or isolated SQL scripts to diagnose and resolve the issue.
Do you fix database issues generated by ORMs like Entity Framework Core?
Yes. I specialize in identifying inefficient SQL generated by ORMs (like EF Core or Dapper) and refactoring the C# LINQ statements or configuring proper database mapping to resolve them.
