I will develop, optimize and fix oracle database sql and pl sql code

Ezra Nyagaka

Kenya

I speak English

9 orders completed

ERP Developer for Business Central, ERPNext, Oracle SQL and Automation

I am an ERP and financial systems developer specializing in Microsoft Dynamics 365 Business Central (AL extensions, RDLC and Word reports, API integrations), ERPNext/Frappe, Oracle SQL and PL/SQL, and...
Read More
About this Gig

Is your Oracle database slow, throwing errors, or missing the logic your business needs? I will write, fix and tune your Oracle SQL and PL/SQL code so it runs correctly and fast.


What I can do for you:

  • Write stored procedures, functions, packages and triggers
  • Fix ORA- errors, compilation errors and logic bugs
  • Speed up slow queries using execution plans, indexes and query rewrites
  • Write complex SQL with joins, subqueries, analytic functions and CTEs
  • Use BULK COLLECT, FORALL, cursors, exception handling and dynamic SQL
  • Build views, materialized views, sequences and constraints
  • Create reports, data migration and ETL scripts

Why work with me:

  • Clean, commented and tested code
  • A short summary of every change I make
  • Fast turnaround and clear communication
  • Support until the code works in your environment

I work with Oracle 11g, 12c, 18c, 19c and 21c/23ai.


Please message me before ordering so I can review your requirements and recommend the right package.

Read More
develop, optimize and fix oracle database sql and pl sql code
Full Screen
develop, optimize and fix oracle database sql and pl sql code
Full Screen
Full Screen
develop, optimize and fix oracle database sql and pl sql codedevelop, optimize and fix oracle database sql and pl sql codedevelop, optimize and fix oracle database sql and pl sql code

Database type:

Centralized database

•

Relational database

Platform:

Oracle

•

PL/SQL

Expertise:

SQL

•

DML

•

Performance

•

Query optimization

My Portfolio

Related tags