You will get Fix,Debug & Optimize Oracle SQL/PLSQL Code Fast(Queries,Scripts,Packages)
Project details
Are your Oracle SQL or PL/SQL scripts failing, running slowly, or producing incorrect results?
If you need fast, clean, and reliable Oracle fixes, I’m here to help.
I’m a Senior Oracle SQL/PLSQL Developer with 25+ years of experience solving complex database issues for enterprise systems, including Finance, SCM, HR, Telecom, and Government. I specialize in quickly finding root causes and delivering clean, production-ready fixes.
I will diagnose and fix issues in your Oracle SQL or PL/SQL code — including errors, slow queries, failing scripts, packages, procedures, functions, triggers, and data loading jobs.
If you need fast, clean, and reliable Oracle fixes, I’m here to help.
I’m a Senior Oracle SQL/PLSQL Developer with 25+ years of experience solving complex database issues for enterprise systems, including Finance, SCM, HR, Telecom, and Government. I specialize in quickly finding root causes and delivering clean, production-ready fixes.
I will diagnose and fix issues in your Oracle SQL or PL/SQL code — including errors, slow queries, failing scripts, packages, procedures, functions, triggers, and data loading jobs.
Database Type
MySQL, Oracle, PostgreSQLWhat's included
| Service Tiers |
Starter
$75
|
Standard
$150
|
Advanced
$300
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 3 days |
Number of Revisions | 1 | 2 | 3 |
Number of Queries | 1 | 3 | 5 |
Query Debugging | |||
Query Optimization | |||
Query Scheduling | - | - | - |
Query Analysis | |||
Source Code |
Frequently asked questions
About Amar
Oracle PL/SQL Developer | EBS/Fusion Tech Consultant | APEX Expert
Plaine des Papayes, Mauritius - 8:15 am local time
I am a senior Oracle Technical Consultant with 25+ years of hands-on experience delivering high-performance solutions across Oracle SQL/PLSQL, APEX, EBS R12, and Oracle Cloud (Fusion).
I help organizations modernize, integrate, automate, and stabilize their business systems using reliable, enterprise-grade Oracle development.
My work spans financial services, government, telecom, and international consulting — including engagements in Mauritius, Botswana, Cameroon, and France.
🔶 Core Expertise
🔹 Oracle SQL & PL/SQL Development
Complex PL/SQL packages, functions, triggers
High-volume batch processing & ETL
SQL performance tuning & debugging
Data quality scripts, conversions, and validations
🔹 Oracle EBS Technical Development (R12)
Forms 10g, Reports 10g, Workflows, XML/BI Publisher
Interfaces, conversions, extensions (CEMLI)
HRMS, Payroll, Financials, SCM, Procurement, Inventory
Production support & performance optimization
🔹 Oracle Fusion Cloud Technical
BI Publisher | OTBI | Spreadsheet Loader | FBDI
Custom reports, data extracts, dashboards
Post-go-live support & troubleshooting
Technical configurations and integrations
🔹 APEX Application Development
Modernizing legacy Forms/Reports to APEX
Backend PL/SQL logic, validations, automation
REST API integrations with ORDS
🔹 Automation & System Integration
Python automation (Excel → Email → Reports)
Scheduling & batch automation
REST / SOAP integrations (JSON/XML)
Cross-system data synchronization
🔶 Tools & Technologies
Oracle 10g–19c • SQL Developer • PL/SQL • Oracle EBS R12 • Oracle Fusion Cloud
APEX • BI Publisher • OTBI • SQLLDR • Python (Pandas, openpyxl)
APIs (REST, JSON, XML) • Linux/Unix • Git • ORDS
🔶 Why Clients Work With Me
Oracle Certified Professional (OCP, OCA, OCI Developer, OCI Data Science)
PMP-Certified — structured delivery and clear communication
Strong technical and functional understanding of Financials, SCM, HR/Payroll
Experience working with Oracle Partners & global consulting firms
Independent, reliable, and detail-oriented
Fluent in English & French
🔶 Services I Deliver on Upwork
Oracle SQL/PLSQL development
Fixing SQL errors, performance bottlenecks, and broken scripts
EBS Reports, Forms, Interfaces, and data conversions
Fusion BI Publisher & OTBI report creation
APEX UI updates & PL/SQL backend logic
Python automation (Excel, CSV, email, APIs)
Data migration, reconciliation, data cleanup scripts
System integration using REST APIs
Documentation, UAT support, post-go-live assistance
💬 Let’s Discuss Your Project
I can help you build reliable Oracle solutions — whether it’s SQL tuning, EBS customizations, Fusion reporting, APEX enhancements, or Python-based automation.
Steps for completing your project
After purchasing the project, send requirements so Amar can start the project.
Delivery time starts when Amar receives requirements from you.
Amar works on your project following the steps below.
Revisions may occur after the delivery date.
Client Provides the Code
Client sends me: • SQL query • PL/SQL package/procedure • Error message • Expected result • Optional sample data • DB version 👉 Client never needs to give you direct database access unless they choose to.
I Reproduce the Issue in my Local Environment
I run client's code in my own local Oracle 19c instance (or 11g/12c if needed). I test, debug, find the issue, rewrite the logic, optimize, and generate a working solution.