- Islandwide (Singapore) Singapore
Working Location
Job Description
Responsibilities
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.
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 *************
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
Important Information
Never provide your bank or credit card details when applying for jobs. Do not transfer any money or complete unrelated online surveys. If you see something suspicious, Report this Job ad.