You will get optimized SQL queries and faster database performance
Project details
Slow SQL queries can affect reporting, applications, batch processing, and overall database performance. I will analyze your SQL queries or stored procedures, identify the main bottlenecks, and provide practical optimization recommendations tailored to your database environment.
My work can include query rewriting, execution-plan analysis, indexing recommendations, join and filter optimization, aggregation improvements, and review of relevant table structures and statistics.
I work with PostgreSQL, Microsoft SQL Server, Oracle, MySQL, and other SQL-based database platforms, including databases running in cloud and on-premises environments.
You will receive optimized SQL, clear explanations of the identified issues, recommended changes, and before/after performance observations when measurable.
My focus is not simply rewriting SQL, but understanding why the query is slow and providing a solution that is efficient, maintainable, and appropriate for your workload.
All analysis is performed using the information you provide, and no production changes are made without your approval.
My work can include query rewriting, execution-plan analysis, indexing recommendations, join and filter optimization, aggregation improvements, and review of relevant table structures and statistics.
I work with PostgreSQL, Microsoft SQL Server, Oracle, MySQL, and other SQL-based database platforms, including databases running in cloud and on-premises environments.
You will receive optimized SQL, clear explanations of the identified issues, recommended changes, and before/after performance observations when measurable.
My focus is not simply rewriting SQL, but understanding why the query is slow and providing a solution that is efficient, maintainable, and appropriate for your workload.
All analysis is performed using the information you provide, and no production changes are made without your approval.
Database Type
MS SQL, PostgreSQLWhat's included
| Service Tiers |
Starter
$100
|
Standard
$250
|
Advanced
$500
|
|---|---|---|---|
| Delivery Time | 3 days | 5 days | 7 days |
Number of Revisions | 1 | 2 | 2 |
Number of Tables Added | 0 | 0 | 0 |
Schema Diagram | - | - | - |
Permissions Setup | - | - | - |
Import/Export Data | - | - | - |
Admin Panel Setup | - | - | - |
Optional add-ons
You can add these on the next page.
Additional Revision
+$40
Additional SQL Query
(+ 1 Day)
+$50Frequently asked questions
About Khalil
Expert Data Engineer | Cloud Data Platforms | ETL | Data Warehouse
Al Hamalah, Bahrain - 4:52 am local time
I help organizations build reliable and scalable data warehouses, lakehouses, ETL/ELT pipelines, cloud data platforms, and analytical data solutions that support business intelligence, regulatory reporting, analytics, and AI/ML use cases.
My expertise includes:
• Cloud Data Platforms – designing modern, scalable, and cloud-agnostic data architectures across leading cloud environments
• Data Warehouse & Lakehouse Architecture – enterprise data warehouses, dimensional models, data marts, Delta Lake, and analytical layers
• ETL / ELT Engineering – complex pipelines, incremental loads, orchestration, automation, validation, and data quality controls
• Database Engineering & Performance Tuning – SQL optimization, indexing, partitioning, workload tuning, and troubleshooting across PostgreSQL, Microsoft SQL Server, Amazon Redshift, and other relational platforms
• Data Platform Modernization – migrating legacy data warehouses and ETL platforms to modern cloud and hybrid architectures
• Informatica PowerCenter – mappings, workflows, transformations, integrations, troubleshooting, and performance optimization
• BI & Reporting Data Solutions – building high-performance datasets and analytical models for Power BI, SSRS, paginated reports, dashboards, and enterprise reporting
• Large-Scale Data Processing – designing and optimizing solutions for high-volume and complex data workloads
• Financial & Banking Data – extensive experience with deposits, loans, payments, transactions, general ledger, financial reporting, and regulatory datasets
• Data Architecture & Technical Leadership – requirements analysis, solution architecture, technical design, implementation planning, and end-to-end delivery
I’m particularly experienced in solving challenging data problems such as slow SQL queries, long-running ETL processes, reporting timeouts, database performance bottlenecks, large data volumes, complex integrations, and legacy platforms that require modernization.
Whether you need a complex SQL query optimized, an ETL pipeline redesigned, a database performance issue resolved, a legacy platform modernized, or a complete cloud data platform, data warehouse, or lakehouse solution designed and implemented, I can help.
My focus is on delivering solutions that are scalable, reliable, maintainable, secure, and production-ready, with clear communication and full ownership from design through implementation.
Steps for completing your project
After purchasing the project, send requirements so Khalil can start the project.
Delivery time starts when Khalil receives requirements from you.
Khalil works on your project following the steps below.
Revisions may occur after the delivery date.
Review Query and Database Details
I will review the SQL, table structures, indexes, execution plan, data volume, and performance information provided to understand the workload and identify likely bottlenecks.
Analyze Performance Bottlenecks
I will analyze joins, filters, aggregations, scans, cardinality estimates, indexing, sorting, and execution-plan operations to identify the main causes of poor performance.