Oracle APEX Consultant

Join the Keyhole Software Team

Location: Remote (U.S.)
Eligibility: Candidates must be authorized to work and reside in the United States. No Corp-to-Corp (C2C) or Contract-to-Hire (C2H) arrangements. At this time, Keyhole Software is unable to provide visa sponsorship of any kind.

About the Role

Keyhole Software is seeking a mid-level Oracle APEX Consultant to contribute to a long-term, low-code solution in a consulting environment. This is a hands-on, individual contributor position—perfect for someone who enjoys owning deliverables, collaborating closely with clients, and shipping. You’ll use Oracle APEX’s declarative features (and targeted code where it’s needed) to build secure, performant business apps that evolve with changing requirements.

We’re especially interested in candidates with experience integrating APEX with enterprise data sources and modern REST services.

Your Responsibilities

  • Design, build, and enhance business applications using Oracle APEX (Page Designer, Interactive Reports/Grids, Dynamic Actions, Faceted Search, LOVs, etc.).
  • Implement SQL/PL-SQL logic, APEX authorization/authentication schemes, and validations following best practices.
  • Integrate with external systems using APEX’s REST Data Sources and ORDS; consume external REST APIs and expose database logic as RESTful endpoints.
  • Optimize performance (analyzing SQL, indexing strategies, APEX component tuning) and uphold security (row-level security, session state protection, ACLs).
  • Create reusable components (templates, plug-ins, shared LOVs) to accelerate delivery and ensure consistency.
  • Collaborate directly with client stakeholders to translate requirements into shippable features and clear acceptance criteria.
  • Participate in sprint planning, estimation, demos, and iterative delivery in an Agile consulting environment.
  • Use version control and CI/CD practices to manage APEX exports, scripts, and deployments across environments.

Technical Requirements

Education: Bachelor’s degree in Computer Science/Information Systems or related field preferred; equivalent experience considered.
Experience: 5+ years of professional experience, including significant time building enterprise apps with Oracle technologies.

Core Skills

  • Oracle APEX (22.x/23.x/24.x+): Interactive Grids/Reports, Dynamic Actions, Authorization Schemes, Theme Roller/Universal Theme, REST integration via ORDS.
  • Database: Strong Oracle SQL and PL/SQL (packages, procedures, functions, performance tuning).
  • Integration: ORDS, REST/JSON, web services; understanding of API design and consumption.
  • Web Fundamentals: HTML, CSS, and basic JavaScript for client-side behaviors within APEX.
  • Dev Practices: Git, code reviews, environment promotion, and scripted deployments of APEX apps/DB objects.

Nice to Have

  • Unit testing in the Oracle ecosystem (e.g., utPLSQL), APEX plug-in development, printing/reporting (APEX Office Print/BI Publisher), SSO/IDP integration.
  • Cloud exposure (OCI, Azure, or AWS) and networking basics for secure connectivity.
  • Experience in regulated domains (healthcare, finance) or prior consulting/professional services work.
  • Experience and interest in another software development language like Java, .NET, or JavaScript for different project needs.

Other Qualifications

  • Doer mindset: you manage your work, hit dates, and keep scope and stakeholders aligned—without needing to lead a team.
  • Excellent communication, requirements discovery, and demo skills with client partners.
  • Curiosity for low-code best practices and when to augment declarative with custom code.

Why Join Keyhole Software?

At Keyhole, we blend the stability of full-time employment with the dynamic nature of client consulting. Our developers are not freelancers or short-term contractors—instead, they are long-term, full-time employees of Keyhole who work on a variety of consulting engagements across different clients. This model allows our team to enjoy the security of a steady position while continuously growing their skills and experience by contributing to challenging, long-term projects in diverse industries and technical environments.

  • Dynamic Projects: Solve interesting problems that keep your skills sharp and evolving.
  • Team Culture: Collaborate with experienced, supportive developers and architects.
  • Career Growth: Opportunities to broaden your technical toolkit and domain exposure.
  • Benefits: Competitive pay, health coverage, 401(k), professional development, and more.

What We Offer

Compensation: $95,000 – $120,000 annually, based on experience and qualifications.

Benefits Package:

  • Health insurance (traditional and HDHP options)
  • Dental and vision coverage
  • FSA & dependent care FSA
  • Life and disability insurance
  • 401(k) with discretionary employer contributions
  • Optional supplemental insurance
  • Supportive environment with continuous mentoring and knowledge sharing

Apply

To apply, please send a personalized email to [email protected], including:

  • A copy of your resume
  • Your current city and state (U.S. only)
  • A brief note on your Oracle APEX experience and recent projects (what you built, your role, and outcomes)

Please note that we only consider candidates based in the United States. We do not engage candidates on a 1099 or Corp-to-Corp (C2C) basis. To ensure an authentic and meaningful hiring process, all interviews are conducted live (in person or via video), and we take care to verify identities, backgrounds, and work histories.