Oracle consultant Job at Keyhole Software, Lenexa, KS

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

Berkeley College

Online Admissions Associate Job at Berkeley College

 ...Strong communication, follow-up, phone and computer skills are required along with the ability to work inside and outside during seasonal times. All positions require Evening and Saturday hours. Berkeley College is committed to excellence in diversity and equity... 

会社名非公開

【食品】Assistant to Supply Chain Management Director Job at 会社名非公開

 ...essary to have a sense of cost/profit, understand demand/supply of coffee industry. Improving the team work is essent...  ...ness level)At least 3-5 years experience as a Supply Chain Ability with Windows tools (Word, Excel, PowerPoint, ... 

Kimley-Horn

Project Manager/Electrical Engineer - Renewable Energy Job at Kimley-Horn

 ...Overview Kimley-Horn's Sacramento office is seeking an Electrical Engineer with 4+years of experience to join their Renewable Energy team! This is not a remote position. Responsibilities Lead the design of electrical systems including renewable generation, energy... 

Sheridan Park Family Church

Director of Children's Ministry Job at Sheridan Park Family Church

 ...Time / 40 hours per week, including Sundays The following document serves to detail the general duties associated with this specific ministry position. It is not intended to limit the scope of duties the ministry worker can and may need to perform while employed, rather to... 

Coulson Group

Senior Composite Technician Job at Coulson Group

 ...wing and rotary-wing aircraft. With a fleet consisting of Boeing 737 FIRELINERS, Hercules C130, Citation, King Air, CH-47D Chinooks and UH-60 Blackhawks, we provide rapid response capabilities using our aviation assets across the globe. We currently produce, maintain and...