Model Integration Trainee

Oracle DBA / Fusion DBA Provisioning & Data Integration (Oracle Fusion to Snowflake) - Dallas TX-Onsite Work :

Rate : 75 $ phr on W2 or 85 $ phr on Corp- Corp all inc

Job Title : Oracle DBA Provisioning & Data Integration (Oracle Fusion to Snowflake)

Job Summary : We are seeking an experienced Oracle Database Administrator (DBA) with a strong background in cloud data integration. This role focuses on managing the Provisioning Database Interface (PDI) and building robust pipelines to extract, transform, and load (ETL) data from Oracle Fusion Cloud Applications into Snowflake.

Key Responsibilities :

• Provisioning Database Interface (PDI) : Administer and optimize the Provisioning Database (PDB) used in enterprise systems. Support and troubleshoot SOAP / XML-based provisioning interfaces. Ensure data integrity and synchronization across provisioning systems and downstream consumers.
• Data Integration & Pipeline Development : Design and implement data extraction pipelines from Oracle Fusion Cloud ERP / HCM using tools like BICC (BI Cloud Connector) and Oracle Data Integrator (ODI). Manage data staging in OCI Object Storage and orchestrate secure, performant data loads into Snowflake using OCI Data Flow, GoldenGate, or custom ETL scripts. Monitor and optimize data transfer performance, ensuring minimal latency and high reliability.
• Database Administration : Install, configure, and maintain Oracle databases in high-availability environments. Perform performance tuning, backup / recovery, and capacity planning. Implement security best practices and ensure compliance with data governance policies.
• Collaboration & Support : Work closely with data engineers, application developers, and business analysts. Provide documentation, training, and support for provisioning and data integration workflows. Participate in incident response and root cause analysis for data-related issues.

Required Qualifications :

Preferred Qualifications :

Soft Skills :