Data/ Oracle Engineer

Purpose

The Data / Oracle Engineer is responsible for designing, developing, maintaining, and optimizing enterprise data platforms and Oracle-based systems that support business applications, reporting, analytics, and digital initiatives across the organization. An ideal candidate will have hands-on experience supporting databases, cloud infrastructure, and enterprise applications within an Oracle Cloud environment.

The role provides hands-on technical expertise in Oracle databases, data engineering, integrations, and performance optimization, ensuring data availability, integrity, security, and scalability. Operating within a sovereign wealth fund environment, the role requires strong technical discipline, documentation rigor, and adherence to governance and change management standards.

Core Responsibilities

1. Oracle Database Engineering & Administration

• Design, implement, and support Oracle database environments across development, test, and production.
• Perform database administration tasks including installation, configuration, patching, upgrades, backup, and recovery.
• Monitor database performance and availability, conduct tuning, and resolve complex performance issues.
• Implement high availability and disaster recovery solutions (e.g., Data Guard, RMAN, Autonomous Database, Exadata, OCI Load Balancer).

2. Data Engineering & Integration

• Design and develop data pipelines, ETL/ELT processes , and integrations between Oracle databases and enterprise applications.
• Design and implement Oracle Fusion use cases in response to evolving business requirements across HR, Finance, and other functional domains.
• Support data ingestion from multiple sources including ERP, HR, finance, and business systems.
• Develop and maintain data models, schemas, and transformations to support reporting and analytics needs.
• Ensure data consistency, accuracy, and reconciliation across systems.

3. Analytics & Insights

• Support enterprise analytics solutions across Oracle Cloud and Oracle Fusion environments (e.g., Oracle Analytics Cloud, Fusion Analytics Warehouse).
• Design and maintain analytical data models, dashboards, and reports to support business decision-making across HR, Finance, and other domains.
• Enable data integration and ingestion from Oracle Fusion and OCI sources into analytics platforms using standard Oracle tools and services.

4. Performance, Reliability & Optimization

• Proactively identify and resolve data and database performance bottlenecks.
• Optimize SQL queries, PL/SQL procedures, indexing strategies, and data structures.
• Support capacity planning and growth forecasting for data platforms.
• Ensure system stability and minimize downtime through proactive monitoring.

5. Security, Governance & Compliance

• Implement database security controls including access management, encryption, auditing, and segregation of duties.
• Ensure compliance with internal IT governance, data security standards, and audit requirements.
• Maintain accurate technical documentation, configuration records, and change logs.
• Support internal and external audits by providing technical evidence and documentation.

6. Cloud, Automation & Modernization

• Support Oracle solutions in Oracle cloud environments .
• Automate database and data operations using scripting and tooling where appropriate.
• Support modernization initiatives such as data platform upgrades, system consolidation, and integration with analytics platforms.

7. Incident, Change & Support

• Participate in incident resolution, root cause analysis, and problem management for data and database issues.
• Execute approved changes in accordance with change management procedures.
• Provide second- and third-level support for Oracle and data-related issues.

8. Education & Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• Oracle certifications such as OCI Foundations Associate, OCI Integration Cloud Professional, Autonomous Database Cloud Professional or data engineering certifications are an advantage.

9. Experience Requirements

• 7-10 years of experience in Oracle database administration and data engineering roles.
• Strong experience working with enterprise Oracle environments in financial services, government, or high-availability organizations preferred.
• Proven experience supporting mission-critical systems and data platforms.
• Experience working in structured IT environments with strong governance and change control.

10. Technical Expertise / Skills / Knowledge

• Strong expertise in Oracle Fusion Environment , SQL, PL/SQL, performance tuning, and backup/recovery.
• Experience with data integration tools, ETL frameworks, and data pipelines.
• Knowledge of data modeling, reporting, and analytics enablement.
• Familiarity with Linux/Unix environments and scripting (Shell, Python, etc.).
• Experience with cloud-based data platforms or Oracle Cloud Infrastructure is an advantage.
• Strong troubleshooting, documentation, and communication skills.

#J-18808-Ljbffr