Oracle consultant Job at Keyhole Software, Lenexa, KS

VDA4MkdsemxweklJQkc3bVg2aWtwUno2Nnc9PQ==
  • 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

vTech Solution

Registered Nurse Job at vTech Solution

Job Summary: The Registered Nurse in Ambulatory Care provides skilled nursing care within a clinic setting, working collaboratively...  ...'s discretion. - Limited parking available at Juvenile Temporary Detention Center (JTDC). - Scrub color: Navy Blue. Scheduling... 

TBG | The Bachrach Group

Medical Receptionist Job at TBG | The Bachrach Group

 ...Medical Receptionist Location: Syosset, NY Compensation: Up to $20/hour Schedule: Full-time | MondayFriday, 8:00 AM 5:00 PM We are seeking customer service-driven and highly motivated individuals to join our team as Medical Records Coordinators .... 

Great Clips

Hairstylist Job at Great Clips

Job Description Job Description Tips paid daily! Are you looking for a full-time or part-time stylist position with room for advancement? We'd love to have you join our team at either of our Columbus locations. Applicant must have a current cosmetology or barber...

Sodexo

Executive Chef 1 Job at Sodexo

 ...Job Description Role Overview: Sodexo is seeking an Executive Chef for Northern Arizona University located in Flagstaff, AZ .The Executive Chef will oversee the culinary operations of a full service casual restaurant on the edge of campus serving the campus... 

Aramark Corporation

Food Production Manager Job at Aramark Corporation

Job DescriptionAramark is seeking a dedicated and detailoriented Food Production Manager to oversee and support daily food production operations. This role is responsible for ensuring high standards of food safety, quality, and efficiency while collaborating with the...