PostgreSQL Database Developer (m/f/d) with Oracle Know How

For our costumer, we are looking for a PostgreSQL Developer (m/f/d) with Oracle Know How.

Start: asap
End: 31.03.2026
Full-time
Remote

Project-Goal:
Migration from Oracle to PostgreSQL of an internal application of the costumer

Tasks:
- Handle complex business logic currently implemented in multiple Oracle Packages, including:
- Custom types, cursors, global variables.
- Java calls from DB, mailing from DB.
- Migration process:
Package Migration: Generate PostgreSQL code via AI, adjust manually for compilation.
Package Validation: Test functionality of migrated packages by executing functions and fixing issues.
- Collaborate with different teams to resolve problems and find alternative solutions.
- Document all relevant information and advise stakeholders on technologies.

Requirements:
- PostgreSQL Development:
Strong experience in DB development.
Ability to validate and test PostgreSQL packages.
- Oracle Knowledge:
Understanding of Oracle Packages, Types, and DB-specific features.
Awareness of differences between Oracle and PostgreSQL.
- Migration Expertise:
Converting Oracle Packages and Types to PostgreSQL.
Adjusting code for compatibility and performance.
- Debugging & Problem-Solving:
Identify and fix functional issues in migrated code.
Suggest alternative solutions when needed.
- Performance Optimization:
Improve performance of converted objects (Types, Views, Materialized Views).
- Collaboration & Communication:
Work closely with different teams.
Report issues and progress in daily meetings.
- Documentation:
Record all steps, changes, and validations clearly.
- Advisory Skills:
Provide guidance on technologies and best practices.