{bc}
Apply
linkedin

Oracle Full-Stack Engineer

ADFAR Tech
Jeddah, KSA
Full Time
Senior
1 weeks ago
Oracle APEXPL/SQLSQLOracle REST Data Services (ORDS)Database AdministrationPerformance Tuning
Free

Job Fit Check

Base Career helps you apply smarter for this job.

?%
Ready to Scan

Key skills for this role

Oracle APEXPL/SQLSQL
Smart Apply

Full Job Posting

About the Role

  • We are looking for an experienced Oracle Full Stack Engineer to design, build, and operate mission critical applications and databases on the Oracle platform. In this hands on role you will own solutions end to end — from APEX user interfaces and ORDS REST services down through PL/SQL business logic

Key Responsibilities

  • Design and build Oracle APEX applications, including pages, components, interactive reports, forms, and responsive UIs that meet business and usability requirements.
  • Develop, review, and maintain PL/SQL code — packages, procedures, functions, and triggers — applying consistent coding standards and conducting peer code reviews.
  • Design relational schemas and author DDL, including tables, constraints, indexes, views, and partitioning strategies for large and growing datasets.
  • Build and secure REST APIs using Oracle REST Data Services (ORDS), including endpoint design, authentication, authorization, and access control.
  • Tune SQL and PL/SQL for performance: analyze execution plans, optimize queries, and design appropriate indexing and partitioning to meet throughput and latency targets.
  • Perform database administration tasks across development, test, and production environments, supporting availability, capacity, and routine maintenance.
  • Diagnose and resolve database errors (ORA NNNNN), tracing root causes and implementing durable fixes.
  • Interpret performance diagnostics from AWR, ADDM, and ASH reports, and translate findings into concrete remediation and capacity planning actions.
  • Design and maintain partitioned schemas to support scalability, manageability, and efficient data lifecycle management.
  • Collaborate with application developers, analysts, and operations engineers to deliver well documented, supportable solutions; participate in design discussions and contribute to technical standards.

Required Qualifications

  • 5+ years of professional experience as an Oracle developer, database engineer, or equivalent full stack Oracle role.
  • Expert level PL/SQL development skills, including packages, procedures, functions, triggers, and bulk processing.
  • Strong SQL skills with proven experience in query optimization and reading and interpreting execution plans.
  • Hands on experience building Oracle APEX applications, including pages, components, and UI development.
  • Experience designing relational schemas and writing production DDL (tables, constraints, indexes, views).
  • Demonstrated experience building and securing REST endpoints with Oracle REST Data Services (ORDS).
  • Practical database administration experience and the ability to diagnose and resolve ORA NNNNN errors.
  • Working knowledge of Oracle performance tooling — AWR, ADDM, and ASH — and the ability to act on their findings.
  • Experience designing partitioned tables and schemas for large scale data.
  • Solid understanding of database security, transaction management, and concurrency.
  • Front end skills (JavaScript, CSS) to extend and customize APEX applications.

Preferred / Nice to Have Qualifications

  • Oracle Certified Professional (OCP) — Database Administrator or PL/SQL Developer — or equivalent Oracle certification.
  • Experience with recent Oracle Database releases (19c, 21c, or 23ai) and Oracle Cloud Infrastructure (OCI) or Autonomous Database.
  • Familiarity with CI/CD for database changes and version control for schema and PL/SQL code (e.g., Liquibase, SQLcl, Git).
  • Experience with high availability and recovery features (RMAN, Data Guard, RAC).
  • Experience integrating Oracle systems with external services and message based architectures.
  • Exposure to data warehousing, ETL, or large volume batch processing.

Technical Skills Summary

  • Application Development: Oracle APEX (pages, components, UIs) Expert
  • Database Programming: PL/SQL (packages, procedures, triggers) Expert
  • Database Programming: PL/SQL code review and standards Advanced
  • Data Modeling: Schema and DDL design Advanced
  • Data Modeling: Partitioned schema design Advanced
  • Performance: SQL tuning and execution plan analysis Expert
  • Performance: AWR / ADDM / ASH interpretation Advanced
  • Administration: DBA operations and maintenance Advanced
  • Administration: ORA NNNNN error diagnosis Advanced
  • APIs: ORDS REST endpoint design and security Advanced

Soft Skills

  • Strong analytical and problem solving ability, with a methodical approach to diagnosing complex issues.
  • Clear written and verbal communication; able to explain technical trade offs to both engineers and non technical stakeholders.
  • Ownership mindset — sees problems through from diagnosis to durable resolution.
  • Collaborative team player who gives and receives constructive code review feedback.
  • Attention to detail and a commitment to quality, documentation, and maintainability.
  • Comfortable balancing priorities across development work and operational support.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at ADFAR Tech

Scrum Master

Riyadh, KSA

TodayFull Time

Senior Project Manager

Riyadh, KSA

1 months agoFull Time

Solutions Architect

Riyadh, KSA

1 months agoFull Time

Java Developer

Riyadh, KSA

1 months agoFulltime

Information Technology Sales Manager

Riyadh, KSA

2 months agoFulltime