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 (Java Script, 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.