Oracle consultant Job at Keyhole Software, Lenexa, KS

L2QvV21UeTN6eDNjb2lIeHYrM3NlRmpvZ0E9PQ==
  • Keyhole Software
  • Lenexa, KS

Job Description

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 via REST Data Services (ORDS) ; consume and expose RESTful APIs as needed.
  • 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, APEX Collections, 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 careers@keyholesoftware.com , 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.

Job Tags

Full time, Contract work, Temporary work, For contractors, Freelance, Live in, Work at office, Remote work,

Similar Jobs

San Diego Post Acute

Director of Rehab - PT - S Job at San Diego Post Acute

Directly supervises and guides all therapy personnel, in an assigned facility which would include licensed, registered, certified therapists, assistants, aides and students. Daily scheduling for the department staff to meet the needs of the facility. Provides direct care...

The Lash Lounge - Walnut Creek

Assistant Salon Manager Job at The Lash Lounge - Walnut Creek

THE LASH LOUNGE in Walnut Creek is looking for a FULL TIME Assistant Salon Manager. We are an upscale eyelash salon providing eyelash extensions/services, facial threading, Lash Lifts, and retail sales. We take pride in creating an inviting atmosphere and giving each of... 

Broad River Rehabilitation

Occupational Therapy Assistant / COTA / OTA / PRN Job at Broad River Rehabilitation

 ...Griffin, GA. Broad River Rehab is a rapidly growing, NC based therapy company that partners with providers across all settings including...  ...living and skilled nursing facilities to provide premier physical, occupational and speech therapy services. PRN Opportunities also... 

D2B Groups

Generator Field Technician Job at D2B Groups

 ...We are seeking a skilled and experienced Generator Field Technician to join our team. As a Generator Technician, you will be responsible for the installation, maintenance, and repair of generators and their related systems. You will work on a variety of generator models... 

Luxus

Energy Modeling Engineer Job at Luxus

 ...Job: Energy Modeling Engineer (2+ Years Experience with IES Software) Location: Irving, TX Position Overview: We are seeking a highly motivated and skilled Energy Modeling Engineer with at least 2 years of experience in building energy simulations and performance...