Browse categories
English
$
USD
Connect to your AI
I will optimize slow sql server and postgresql queries
Senior Software Engineer and NET Developer
I'm a Senior Software Engineer and Technical Lead with over 15 years of experience in software development.
I specialize in C#, .NET, ASP.NET Core, REST APIs, SQL Server, PostgreSQL, Docker, and paym...
About this Gig
Is your SQL Server or PostgreSQL database running slowly?
I'm a Senior Software Engineer and Technical Lead with over 15 years of experience in backend development, database optimization, and enterprise applications.
I can help you identify and optimize slow SQL queries to improve application performance.
What I can help with:
- SQL Server and PostgreSQL query optimization
- Slow SELECT, JOIN, UPDATE, and DELETE queries
- Execution plan analysis
- Missing or inefficient indexes
- Database performance bottlenecks
- Query rewriting and optimization
- SQL troubleshooting
My packages:
- Basic ($50): Analyze one slow query and provide recommendations.
- Standard ($150): Optimize one query and provide performance comparisons.
- Premium ($300): Optimize up to three queries, review relevant indexes, and document the improvements.
Each package covers the stated number of queries, not an entire database.
Please contact me before ordering to confirm the scope and available test environment. Performance improvements depend on your database structure, data volume, and workload.
Database type:
Relational database
Platform:
PostgreSQL
•
SQL Server
Expertise:
Design
•
SQL
•
Performance
•
Query optimization
FAQ
What do you need to get started?
Please provide your SQL query, database type and version, table structures, relevant indexes, and execution plan if available. Explain the performance issue and expected results. Do not share passwords or sensitive production data.
Do you work with both SQL Server and PostgreSQL?
Yes. I have extensive experience with Microsoft SQL Server and PostgreSQL, including query optimization, execution plans, indexing, and database performance troubleshooting.
Can you guarantee that my query will run faster?
I cannot guarantee a specific speed improvement. Performance depends on data volume, indexes, database configuration, and workload. I will identify potential improvements and provide measurable results when a suitable test environment is available.
What is the difference between your packages?
Basic includes analysis of one slow query and recommendations. Standard includes optimization of one query. Premium covers up to three queries, relevant index reviews, and documentation. All work is limited to the agreed scope.
Do you need access to my production database?
No, direct production access is not normally required. I prefer working with SQL scripts, execution plans, anonymized sample data, or a safe testing environment. Any access must be explicitly authorized.
Can you optimize my entire database?
This Gig focuses on individual SQL queries rather than full database optimization. For larger projects involving multiple queries, schema changes, or system-wide performance issues, please contact me for a custom offer.
