You will get expert SQL query and stored procedure troubleshooting
Project details
I will troubleshoot, correct, optimize, and document SQL queries, stored procedures, and database functions.
The service can include fixing syntax or runtime errors, correcting wrong results, reviewing joins and filters, refactoring legacy SQL, analyzing execution plans, identifying bottlenecks, and recommending appropriate indexing or query changes.
I have 25+ years of database-development experience across Microsoft SQL Server, PostgreSQL, Oracle Database, DB2, SQL Anywhere/Sybase, MySQL/MariaDB, InterBase/Firebird, SQLite, and 4D.
Depending on the selected package, I can review one query, one complex stored procedure, or a related SQL component that includes several queries, functions, and performance dependencies.
You will receive the corrected source code, validation of the expected result, and a concise explanation of the issue and the changes made.
Server-wide performance investigations, major schema redesign, production configuration, or multiple unrelated SQL problems require a separate scope.
The service can include fixing syntax or runtime errors, correcting wrong results, reviewing joins and filters, refactoring legacy SQL, analyzing execution plans, identifying bottlenecks, and recommending appropriate indexing or query changes.
I have 25+ years of database-development experience across Microsoft SQL Server, PostgreSQL, Oracle Database, DB2, SQL Anywhere/Sybase, MySQL/MariaDB, InterBase/Firebird, SQLite, and 4D.
Depending on the selected package, I can review one query, one complex stored procedure, or a related SQL component that includes several queries, functions, and performance dependencies.
You will receive the corrected source code, validation of the expected result, and a concise explanation of the issue and the changes made.
Server-wide performance investigations, major schema redesign, production configuration, or multiple unrelated SQL problems require a separate scope.
Database Type
MySQL, MS SQL, Oracle, SQLite, PostgreSQLWhat's included
| Service Tiers |
Starter
$125
|
Standard
$325
|
Advanced
$700
|
|---|---|---|---|
| Delivery Time | 2 days | 4 days | 7 days |
Number of Revisions | 1 | 1 | 2 |
Number of Queries | 1 | 1 | 4 |
Query Debugging | |||
Query Optimization | |||
Query Scheduling | - | - | - |
Query Analysis | |||
Source Code |
Optional add-ons
You can add these on the next page.
Additional Revision
+$75
Additional Simple Related Query
(+ 2 Days)
+$150Frequently asked questions
About Igor
Senior Software Engineer | NetSuite, SQL/ETL, Delphi & JavaCard
Victoria, Canada - 1:32 am local time
I help clients solve technically complex problems involving business systems, data, APIs, legacy applications, and production environments. My core areas of specialization are:
• Oracle NetSuite Development & Integration
SuiteScript 1.0/2.x, RESTlets, Map/Reduce, User Event and Scheduled scripts, SuiteTalk SOAP/REST, SuiteFlow, Saved Searches, CSV imports, third-party integrations, production troubleshooting, and legacy-script migration.
• Database Development, SQL & ETL
Microsoft SQL Server, PostgreSQL, Oracle, DB2, SQL Anywhere, MySQL, Firebird, SQLite, and 4D. I work with database design, SQL/DDL development, stored procedures, data migration, ETL, data conversion, reporting logic, performance troubleshooting, and production issue resolution.
• Delphi / Object Pascal Development
RAD Studio, VCL, Windows desktop and client/server applications, Windows Services, database applications, multithreaded systems, legacy-code modernization, debugging, refactoring, and ongoing product maintenance.
• AI-Assisted Development & Workflow Automation
n8n, API and webhook integrations, scheduled workflows, OCR and AI-assisted data extraction, database-backed automation, automated reporting, email/SMS notifications, Telegram workflows, and AI-assisted modernization of existing software.
Selected results from previous projects include:
• Authored and reworked more than 70 NetSuite SuiteScript solutions for a large ERP implementation.
• Developed REST APIs and data-migration interfaces connecting NetSuite with Salesforce, MuleSoft, payment systems, banking APIs, and third-party logistics services.
• Delivered dozens of SQL, DDL, ETL, and PowerShell solutions for healthcare, property-tax, insurance, education, and enterprise data-migration projects.
• Migrated business-critical Oracle PL/SQL logic to PostgreSQL for financial commission calculations and daily reporting.
• Delivered more than 100 improvements and bug fixes for Delphi-based transportation and healthcare applications.
• Improved a C# and SQL Server document-printing solution, reducing recurring printing costs by approximately 20%.
I also have deep specialist experience in smart cards, JavaCard/JCOP, GSM SIM/USIM, PC/SC, APDU processing, cryptography, OpenSSL, Microsoft CryptoAPI, digital signatures, and security-oriented software.
I can work across the full software-development lifecycle: requirements analysis, architecture and technical design, implementation, database development, integration, testing, deployment, documentation, production support, and root-cause troubleshooting.
My approach is structured and practical: I clarify goals, study the existing system, identify risks early, communicate progress clearly, and deliver solutions that are maintainable—not merely quick patches.
Steps for completing your project
After purchasing the project, send requirements so Igor can start the project.
Delivery time starts when Igor receives requirements from you.
Igor works on your project following the steps below.
Revisions may occur after the delivery date.
Review the SQL issue and scope
I will review the SQL code, database platform, expected behavior, available schema details, and package scope before beginning the analysis.
Reproduce and diagnose the problem
I will analyze the query logic, joins, filters, execution plan, indexes, dependencies, and error details to identify the root cause.