Model Integration Trainee Job at Openkyber, Texas

dDJmQ3ZqMkk5Uy9KekVPVWk5V2tFaUFDdUE9PQ==
  • Openkyber
  • Texas

Job Description

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:
  • Bachelor s degree in Computer Science, Information Systems, or related field.
  • 5+ years of experience as an Oracle DBA, with 2+ years working with Oracle Fusion Cloud Applications.
  • Hands-on experience with Oracle Fusion data extraction via BICC.
  • Strong knowledge of Snowflake architecture, SQL, PL/SQL, and ETL tools.
  • Familiarity with OCI services (Object Storage, Data Flow, GoldenGate) and cloud security models.
Preferred Qualifications:
  • Experience with SOAP/XML provisioning interfaces and Oracle Communications PDI.
  • Proficiency in Python, Shell scripting, or Terraform for automation.
  • Oracle or Snowflake certifications (e.g., OCP, SnowPro Core).
Soft Skills:
  • Strong analytical and troubleshooting skills.
  • Excellent communication and documentation abilities.
  • Ability to work independently and collaboratively in a fast-paced environment.

Job Tags

Traineeship,

Similar Jobs

GD Resources

Senior Student Success & Retention Consultant Job at GD Resources

 ...professionals alike to contribute to innovative projects and drive success in a collaborative and supportive environment. Join us to make...  ..., and continuous improvement. Job Title: Senior Student Success & Retention Consultant Industry: Higher Education Consulting... 

American Red Cross

Fixed Site Donor Recruitment Associate Job at American Red Cross

 ...Please use Google Chrome or Mozilla Firefox when accessing Candidate Home. By joining the American Red Cross you will touch millions of lives every year and experience the greatness of the human spirit at its best. Are you ready to be part of the worlds largest humanitarian... 

Clinical Management Consultants

Neonatal NICU Nurse Practitioner NP Job at Clinical Management Consultants

 ...Neonatal NICU Nurse Practitioner NP Dream Big, Care Bigger! &##127775; An elite pediatric hospital seeks a Neonatal NICU Nurse Practitioner NP to champion advanced neonatal care in a fast-growing regional hub, delivering life-changing outcomes in a cutting-edge environment... 

St. Ives Hometown Living of Johns Creek

Maintenance Technician for a Senior Living Community Job at St. Ives Hometown Living of Johns Creek

Description of the role:As a Maintenance Technician at St. Ives Hometown Living of Johns Creek, you will be responsible for ensuring the maintenance and upkeep of our senior living community. The ideal candidate for this position possesses a unique blend of technical... 

ATC Athens

Healthcare Aide Job at ATC Athens

 ...we want you to join us!Required:* Valid BLS certification* Latest TB* At least 2 years Psychiatric experience, and/or Group Home experience* No CNA license requiredWe offer the following benefits:* Compensation $16 - $17/hour* Medical insurance*...