Senior Engineer / Engineer (CIM Oracle Database)

Job Description: • Proving of Database 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.