Senior Engineer / Engineer (CIM Oracle Database)

Vanguard; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

Vanguard in Singapore seeks an experienced Oracle DBA to support CIM and manufacturing systems. You will handle L1/L2 DBA tasks, perform RMAN backups, and ensure high availability while optimizing performance.

The role involves scripting for automation and coordinating with cross-functional teams to meet SLAs. Ideal candidates have 3–5 years of hands-on Oracle DBA experience, strong RMAN/AWR/ADDM skills, and familiarity with expdp/impdp and partitioning.

Qualifications

• 3–5 years of hands-on Oracle DBA experience in production environments.
• Experience managing L1/L2 DBA tasks (incident handling, monitoring, performance tuning, backup and recovery).
• Strong RMAN, AWR/ASH/ADDM, SQL tuning and Oracle performance optimization techniques.
• Experience with expdp/impdp, partitioning, advanced compression, LOBs and related Oracle features.
• Familiarity with scripting (Shell, Python) for automation of DBA tasks.

Responsibilities

• Act as Oracle DBA for CIM and related manufacturing systems.
• Ensure BAU support activities in line with SLAs.
• Perform backup and recovery using RMAN and database cloning.
• Use Oracle utilities such as expdp/impdp, partitioning, and LOB management.
• Conduct performance tuning using SPM, hints, and SQL Tuning Advisor.
• Collaborate with internal teams to ensure high availability of fab systems.
• Maintain technical documentation and share knowledge with junior staff.

Skills

Oracle DBA

BAU Support

SQL Tuning

RMAN

AWR/ASH/ADDM

Scripting (Shell/Python)

Shift-based Support

Performance Optimization

Tools

expdp/impdp

Partitioning

LOBs

Oracle Utilities

Job description

• Proving ofDatabase Operations & Support such as:
  Act as Oracle DBA for Computer Integrated Manufacturing (CIM) and related manufacturing systems.
• Ensure effective BAU support activities in line with internal customer needs and SLAs.
• Perform database monitoring, session management, lock analysis, long-running query handling and hung session resolution.Manage L1 and L2 DBA tasks, including incident handling, root cause analysis and preventive actions.
• Perform backup and recovery using RMAN, including database cloning (e.g. duplicate database).
• Use Oracle utilities and features such asexpdp/impdp, partitioning, advanced compression, LOB management and concurrent statistics.
• Conduct performance tuning using SQL Plan Management (SPM), hints and SQL Tuning Advisor.
• Analyze AWR/ASH/ADDM reports and implement tuning recommendations.
• Troubleshoot database issues such as TNS/network connectivity, tablespace/FRA utilization, user privilege problems and alert log errors.
• Manage shift duties together with other team members to support production operations.
  Optimization, Automation & AI‑Assisted Operations
• Identify opportunities to automate routine DBAtasks (monitoring, reporting, housekeeping, capacity checks) using scripting and available tools.
• Leverage the company’s on‑premise ChatGPTEngine and GitHub Copilot to improve productivity in scripting, documentation and problem analysis.
• Collaborate with internal big data teams using Hadoop and Greenplum platforms to ensure efficient data flow between Oracle databases and big data systems.
• Support initiatives to integrate database telemetry with big data / analytics platforms for advanced monitoring, anomaly detection and performance insights.
• Work closely with application, infrastructure and manufacturing teams to ensure high availability and performance of fab systems.
• Maintain up to date technical documentation, standard operating procedures and knowledge base articles.
• Share best practices and provide guidance to junior team members or L1 support where required.

Job Requirements:

• Minimum 3 to 5 years of solid hands‑on experience as an Oracle DBA in production environments, including BAU support.
• Proven experience managing L1 and L2 DBA tasks (incident handling, monitoring, performance tuning, backup and recovery).
• Strong knowledge of RMAN, AWR/ASH/ADDM, SQL tuning and Oracle performance optimization techniques.
• Practical experience with expdp/impdp, partitioning, advanced compression, LOBs and related Oracle features.
• Good understanding of database security, user/role management and auditing concepts.
• Experience in troubleshooting connectivity issues, storage/tablespace problems and database availability incidents.
• Familiarity with scripting (e.g. Shell, Python or similar) for automation of DBA tasks.
• Ability to work in a shift-based support model and respond to production issues in a timely manner.