Job Description

What you will be working on

We are looking for a hands-on database engineer to modernise a large-scale, business-critical platform, migrating legacy Oracle databases to PostgreSQL while ensuring data integrity, minimal downtime, and reliable performance.

Lead end-to-end data migration, including ETL, reconciliation, cutover, and rollback planning.
Reverse-engineer undocumented business logic from legacy schemas, stored procedures, and triggers.
Optimise SQL queries, indexing, partitioning, and database configurations for high-volume workloads.
Manage database reliability, backup and recovery, replication, high availability, and disaster recovery.
Establish standards for schema changes, database security, monitoring, and operational best practices.
Build automation and validation tools using Python, Bash, or similar scripting languages.
Work with application teams to resolve database issues and improve system performance.

What we are looking for

Minimum 10 years of hands-on database engineering, DBA, or relevant data engineering experience in production environments.
Strong Oracle expertise and practical PostgreSQL experience, ideally involving Oracle-to-PostgreSQL migration.
Proven experience with large-scale data migration, reconciliation, and production cutovers.
Strong SQL, query tuning, performance optimisation, and database troubleshooting skills.
Experience with replication and CDC tools such as Oracle GoldenGate or AWS DMS.
Experience with AWS RDS, Aurora, backup and recovery, high availability, and disaster recovery.
Scripting proficiency in Python, Bash, or similar.
Knowledge of database security, access controls, encryption, and data masking.

Good to have: Experience in large-scale platform modernisation, transaction-intensive systems, and AI-assisted development workflows.

For more information you can contact Norean Tan at [Confidential Information]

We regret to inform you that only shortlisted candidates will be notified / contacted.

EA Registration No.: R1434118 - Tan Lee Ying, Norean

iKas International (Asia) Pte Ltd

ROC No.: 200914065E | EA License No.: 16S8086