Java/Spring Developer – Database Migration (Oracle → PostgreSQL)

Join the Keyhole Software Team

Location: Lenexa, KS (Hybrid: On-site M/W/F; Remote T/Th)
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 Java/Spring Developer with hands-on database migration experience to join our consulting team. This role is focused on migrating enterprise applications from Oracle to PostgreSQL while maintaining and enhancing existing Java/Spring services.

This is a mid-level contributor position—we’re looking for someone who can check the technical boxes and deliver consistently, not someone seeking to lead teams. You’ll work within a collaborative environment made up of both Keyhole consultants and client employees, delivering reliable, maintainable code and database solutions in support of a long-term project.

Your Responsibilities

  • Contribute to the migration of enterprise applications from Oracle to PostgreSQL, ensuring data integrity, performance, and security.
  • Refactor and maintain back-end services using Java and the Spring ecosystem (Spring Boot, Spring Data, Spring Security, etc.).
  • Write and optimize SQL, stored procedures, and scripts to support data migration and application logic.
  • Collaborate with client and consulting team members to identify migration challenges, troubleshoot issues, and validate solutions.
  • Support integration testing, regression testing, and production cutovers.
  • Document technical changes, database schemas, and system processes for future maintainability.

Technical Requirements

Education: Bachelor’s degree in Computer Science or related field preferred; equivalent experience considered.
Experience: Minimum of 5 years of professional software development experience, with a strong focus on Java and database-driven applications.

Core Skills

  • Java (8+) and Spring Boot (Spring Data, Spring Security, Spring REST).
  • Database migration experience: Oracle to PostgreSQL (DDL/DML migration, stored procedure/function rewrites, schema design, performance tuning).
  • Strong SQL development and optimization skills in both Oracle and PostgreSQL.
  • Familiarity with Liquibase or Flyway for schema versioning and migration scripts.
  • Experience with RESTful APIs, microservices, and integration patterns.
  • Source control (Git), Agile/Scrum collaboration, and CI/CD pipelines.

Nice to Have

  • Experience with tools for Oracle-to-Postgres migration (e.g., AWS Schema Conversion Tool, ora2pg).
  • Familiarity with cloud deployments (AWS, Azure, or GCP).
  • Exposure to containerization (Docker, Kubernetes).

Other Qualifications

  • Ability to contribute independently within a hybrid consulting/client team structure.
  • Strong problem-solving skills, attention to detail, and follow-through on deliverables.
  • Comfortable working in a hybrid schedule (Lenexa, KS on-site M/W/F).

Why Join Keyhole Software?

At Keyhole, we blend the stability of full-time employment with the dynamic nature of client consulting. Our developers are long-term employees who enjoy steady roles while continuously expanding their skills through challenging client projects.

  • Real Impact: Work on a long-term project with clear, achievable goals.
  • Supportive Team: Collaborate with a team that includes both client FTEs and experienced Keyhole consultants.
  • Career Growth: Build specialized expertise in database migration and enterprise modernization.
  • Benefits: Competitive pay, health coverage, 401(k), and professional development.

What We Offer

Compensation: Competitive, though aligned with the client’s budget-conscious constraints. Range: $85,000 – $110,000 annually, depending 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
  • Collaborative, growth-focused environment

Apply

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

  • A copy of your resume
  • Your current city and state
  • A brief summary of your database migration experience (especially Oracle → PostgreSQL)

Please note: This role requires on-site presence in Lenexa, KS three days per week (Monday, Wednesday, Friday). We do not consider C2C, C2H, or fully remote arrangements for this position.