Database Engineer

Database Engineer Consultant

• Start: No later than 1 October
• Initial contract: 6 months, with a high possibility of extension
• Scope: 100%

Key Responsibilities

• Lead and provide hands-on support for the end-to-end migration of Oracle database services to PostgreSQL, ensuring minimal disruption to the PAM platform.
• Bridge development teams and the database, translating application requirements into practical database solutions throughout the migration.
• Review and validate database schemas, configurations, and application code changes for accuracy, performance, and compatibility.
• Document learnings and best practices for future migrations.

Required Skills

• Deep experience as a PostgreSQL DBA or PostgreSQL developer.
• Knowledge of Oracle databases and Oracle-to-PostgreSQL datatype mappings.
• Hands-on experience with PostgreSQL migration projects.
• Ability to work independently within an established migration framework.
• Strong collaboration skills when working with database and development teams.
• Understanding of Liquibase for schema versioning and migration.

Note

The applications do not contain PL/SQL code, so PL/SQL conversion is not required for this engagement.

Nice-to-Have Skills

• Knowledge of Java applications working with Postgres.
• Experience with distributed systems and event-driven architecture, ideally using Kafka and/or Solace.
• Experience with AI agents and automation in development workflows, such as Cursor or Claude agent skills.
• Experience migrating high-traffic services with minimal downtime.