Overview
Oracle Full-Stack Engineer Jobs in Jeddah, Makkah, Saudi Arabia at ADFAR Tech
Title: Oracle Full-Stack Engineer
Company: ADFAR Tech
Location: Jeddah, Makkah, Saudi Arabia
Oracle Full-Stack Engineer
Job Description
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, schema design, and database performance and administration. You will be the go-to expert when a query needs tuning, an ORA error needs diagnosing, or a new data model needs to scale, working closely with product, engineering, and operations teams to keep our systems fast, reliable, and maintainable.
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
Area
Skill
Expected Level
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.