The posting
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 [email protected]
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



