Staff Database Engineer
Summary
Hands-on staff database engineer leading a legacy Oracle-to-PostgreSQL migration for a large-scale, business-critical platform: end-to-end ETL, cutover and rollback planning, reverse-engineering legacy schemas/procedures, and query/index/partition tuning. Also owns reliability work — backup/recovery, replication, HA and disaster recovery — plus automation with Python/Bash.
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 norean.tan@sanderson-ikas.sg
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