The posting
Responsibilities
Database Migration
- Lead end-to-end migration from legacy databases, covering extraction, transformation, loading, reconciliation and production cutover.
- Develop scripts and tools to validate data integrity, identify discrepancies and support rollback.
- Reverse-engineer undocumented business logic from legacy Oracle stored procedures, triggers and schemas.
- Plan phased migrations and co-existence strategies to minimise downtime and operational risks.
Performance and Reliability
- Troubleshoot slow queries, optimise SQL, indexing, partitioning and database configurations.
- Manage database backup and recovery, high availability, replication, disaster recovery and version upgrades.
- Build monitoring and alerting, troubleshoot production incidents and lead root-cause analysis.
- Optimise connection pooling, capacity, storage and database costs.
Security and Technical Leadership
- Review schema changes and ensure safe database deployments in live environments.
- Manage access controls, encryption, data masking and audit logging.
- Establish engineering standards and advise application teams on SQL, transactions and database performance.
What we are looking for
- At least 9 years of hands-on database engineering or DBA experience in production environments.
- Deep Oracle expertise in SQL tuning, indexing, partitioning, replication and performance optimisation.
- Strong PostgreSQL experience, including schema transformation and Oracle-to-PostgreSQL migration.
- Proven track record in large-scale data migration, reconciliation, cutover and rollback planning.
- Experience with backup and recovery, high availability, failover and production incident management.
- Familiarity with CDC and replication tools such as GoldenGate, AWS DMS or logical replication.
- Experience with AWS RDS/Aurora and scripting in Python, Bash or similar languages.
- Knowledge of database security, access controls, encryption and data masking.
- Strong documentation and technical communication skills.
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



