Keyhole Software is seeking a Java/Spring Developer to migrate enterprise applications from Oracle to PostgreSQL while maintaining and enhancing existing Java/Spring services.
Requirements
- 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
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.
Other
- 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)
- Bachelor’s degree in Computer Science or related field preferred; equivalent experience considered
- Minimum of 5 years of professional software development experience
