[LTA-DPO] SENIOR ENGINEER, ERP2 DEVELOPMENT

Land Transport Authority (LTA) Singapore; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Land Transport Authority (LTA) Singapore is hiring a Senior Database Administrator to lead migration, administration and modernization of enterprise platforms, including moving databases to GCC on AWS or Azure. You will manage the full lifecycle of Oracle databases (19c), implement HA/DR, perform patching and performance tuning, and collaborate with cloud, DevOps and application teams.

Candidates should have 7+ years in Oracle DB design/administration, Linux experience, and relevant

Qualifications

• Minimum 7 years of Oracle Database design, implementation and administration.
• Hands-on experience with Oracle 19c in enterprise environments.
• Experience migrating on-prem to GCC on AWS or Azure.
• Proficiency in Oracle HA, DR and migration technologies (GoldenGate, Data Guard, RMAN, ZDM).
• Familiarity with Oracle AI Database technologies (AI DB 26ai, AI features).
• Scripting in Shell or Python to automate tasks.

Responsibilities

• Lead migration of Oracle environments to GCC on AWS/Azure with minimal business disruption.
• Design, implement and maintain replication between on-premises and cloud.
• Plan and execute Oracle installations, config, upgrades and lifecycle management.
• Perform performance tuning, capacity planning and preventive maintenance.
• Establish backup, HA and DR solutions and ensure security alignment.
• Collaborate with cloud, DevOps, infrastructure and application teams.
• Troubleshoot complex issues, perform root cause analysis and document procedures.

Skills

Oracle DBA

Scripting

Analytical skills

Interpersonal skills

Problem solving

Education

Engineering/CS degree

Tools

Oracle GoldenGate

Data Guard

RMAN

ZDM

Linux

AWS

Azure

Job description

[What the role is]

We are looking for a Senior Database Administrator to join our team to support the migration, administration and modernization of platforms supporting enterprise applications. You will play a key role in database migration to Government Commercial Cloud (GCC) (on AWS or Azure).

[What the role is]

We are looking for a Senior Database Administrator to join our team to support the migration, administration and modernization of platforms supporting enterprise applications. You will play a key role in database migration to Government Commercial Cloud (GCC) (on AWS or Azure).

The successful candidate will be responsible for the full database lifecycle, including installation, configuration, upgrades, patching, performance tuning, backup and recovery, high availability, disaster recovery and operational support. The role also involves evaluating and adopting the latest AI Database capabilities to support future platform modernization. The successful candidate will also work closely with existing vendors and internal stakeholders to ensure successful delivery of database migration, upgrade and operational support activities.

[What you will be working on]

• Lead the migration of Oracle Database 19c environments to Government Commercial Cloud (GCC) on AWS and Azure, ensuring minimal disruption to business operations.
• Design, implement and maintain database replication between on-premises and cloud environments.
• Plan and execute Oracle database installations, configuration, upgrades and database lifecycle management.
• Perform proactive database administration, including performance tuning, SQL optimization, capacity planning, health monitoring and preventive maintenance to ensure database availability, reliability and performance.
• Design, implement and maintain backup, recovery, High Availability (HA) and Disaster Recovery (DR) solutions.
• Apply database patches, security updates and configuration changes while ensuring compliance with organisational security policies and industry best practices.
• Collaborate with application, infrastructure, cloud and DevOps teams to support application deployments, system integration and cloud migration initiatives.
• Troubleshoot complex database and infrastructure issues, perform root cause analysis, automate operational tasks using scripting where appropriate, and maintain comprehensive technical documentation.
• Collaborate with existing vendors and cross-functional teams, including application, infrastructure and cloud teams, to deliver database migration, implementation, maintenance and operational support.

[What we are looking for]

• Knowledge in Engineering, Computer Science or equivalent degree.
• Minimum 7 years of experience in Oracle Database design, implementation and administration in enterprise environments.
• Strong hands-on experience administering Oracle Database 19c, including installation, configuration, upgrades, patching, performance tuning, backup & recovery and database security.
• Proven experience planning and executing Oracle database migrations from on-premises infrastructure to cloud platforms, preferably Government Commercial Cloud (GCC) on AWS or Azure.
• Strong hands-on experience with Oracle High Availability, Disaster Recovery and migration technologies, including Oracle GoldenGate, Data Guard, RMAN and Zero Downtime Migration (ZDM)
• Familiarity with Oracle AI Database technologies, including Oracle AI Database 26ai, Oracle APEX, Select AI and related database capabilities.
• Experience administering Oracle databases on Linux platforms and deploying database workloads to cloud environments (AWS and/or Azure).
• Proficiency in scripting and automation using Shell, Python or equivalent scripting languages to improve database administration and operational efficiency.
• Relevant Oracle Database, Oracle Cloud and cloud platform certifications are preferred.
• Team player with strong analytical, troubleshooting and interpersonal skills.

As part of the shortlisting process for the role, you may be required to complete a medical declaration and / or undergo further assessment.