Oracle Developer VA

Develops and tunes the PL/SQL, database objects and integrations behind your Oracle systems, including Oracle APEX applications and E-Business Suite or Fusion customisations. Keeps mission-critical Oracle workloads fast, correct and supportable.

Description

An Oracle Developer VA develops and optimises the database logic, applications and integrations behind Oracle-based systems. They can work with PL/SQL, Oracle APEX, E-Business Suite or Fusion customisations, performance tuning and data integration. Outsource Teams provides top 1% vetted talent with substantial Oracle development experience, no lock-in contracts and a replacement guarantee.

Responsibilities

  • Write and optimise PL/SQL packages, procedures, triggers and views for business logic and reporting.
  • Design Oracle schemas, partitioning and indexing strategies for large transactional and reporting workloads.
  • Tune SQL using execution plans, AWR reports and SQL Tuning Advisor to resolve performance issues.
  • Build and maintain Oracle APEX applications for internal business processes.
  • Develop customisations, reports and interfaces for Oracle E-Business Suite or Oracle Fusion Cloud where the client uses them.
  • Build data integrations and ETL with Oracle Data Integrator, SQL*Loader or external tables.
  • Implement security, auditing and data masking in line with the client's compliance needs.
  • Support migrations and upgrades between Oracle versions and to Oracle Cloud Infrastructure.
  • Write technical documentation and unit tests for database code with utPLSQL.

Software & Tools

PL/SQL Oracle Database Oracle APEX Oracle Forms SQL Developer

Requirements

  • 5+ years of Oracle development with deep PL/SQL and SQL expertise on Oracle 12c or later.
  • Experience with Oracle APEX, Oracle Forms and Reports, or Oracle E-Business Suite customisation.
  • Strong performance tuning skills, including reading execution plans and using AWR and ASH.
  • Familiarity with Oracle Cloud Infrastructure, Oracle Data Integrator and Oracle REST Data Services.
  • Oracle certification such as Oracle Database PL/SQL Developer Certified Professional is preferred.
  • Good English communication for working with DBAs, analysts and business users.
  • Fast, stable internet connection and backup power, with hours overlapping the client's business day.

Frequently Asked Questions

What Oracle development can they handle?

They can develop PL/SQL packages, procedures, triggers, views, reports and database-driven business logic.

Can they improve Oracle performance?

Yes. They can use execution plans, AWR reports and tuning tools to identify and address slow SQL.

Can they build Oracle APEX applications?

Yes. They can build and maintain APEX applications for internal business processes.

Can they support Oracle enterprise systems?

Yes. They can work with customisations, reports and interfaces for Oracle E-Business Suite or Oracle Fusion where used.

What tools can they use?

They can work with PL/SQL, Oracle Database, Oracle APEX, Oracle Forms and SQL Developer.

How experienced are the candidates?

Candidates are expected to have at least five years of Oracle development experience with deep PL/SQL and SQL expertise.

How much does it cost?

Rates start at $12 USD per hour for entry level, $16 USD per hour for intermediate and $22 USD per hour for senior talent. Full-time and part-time options are available.

Outsource Your Next Hire With Confidence

Scale your business faster with our vetted assistants from the Philippines. Start your free one week trial today and experience the difference.

Get a QuoteBook a Call

Consult a VA expert today!