Oracle ADW Database Admin & ETL Engineer

The Oracle ADW Database Administrator & ETL Engineer will be responsible for establishing, configuring, and maintaining the organization s Oracle Autonomous Data Warehouse (ADW) environment and implementing data ingestion pipelines using Oracle Cloud Infrastructure (OCI) Data Integration services. This role requires strong experience with cloud-based Oracle data technologies, advanced SQL expertise, and the ability to design, build, and maintain STAR schemas to support analytical workloads.

Title Oracle ADW Database Admin & ETL Engineer
Duration 7 Months
Location 100% Remote EST
Project Focus: Stand up of Oracle Autonomous Data Warehouse and implementation of OCI Data Integration pipelines

Job Description
Experience Level: 3 5 years


Role Summary:
The Oracle ADW Database Administrator & ETL Engineer will be responsible for establishing, configuring, and maintaining the organization s Oracle Autonomous Data Warehouse (ADW) environment and implementing data ingestion pipelines using Oracle Cloud Infrastructure (OCI) Data Integration services. This role requires strong experience with cloud-based Oracle data technologies, advanced SQL expertise, and the ability to design, build, and maintain STAR schemas to support analytical workloads.

Key Responsibilities:

• Provision, configure, and administer Oracle Autonomous Data Warehouse instances within OCI.
• Implement and manage data ingestion pipelines using OCI Data Integration Cloud Service.
• Develop ETL/ELT workflows to load, transform, and stage data for downstream analytics.
• Design, build, and maintain STAR schemas optimized for reporting and analytical performance.
• Monitor database performance, storage usage, and query efficiency across the ADW environment.
• Collaborate with analytics, data engineering, and infrastructure teams to support reporting and semantic model needs.
• Ensure security, access control, and proper configuration of OCI resources used in the data pipeline.
• Document data models, ETL pipelines, data mapping logic, and database configuration for long-term maintainability.

Required Qualifications:

• 3 5 years of experience as an Oracle Database Administrator or ETL Engineer.
• Hands-on experience with Oracle Autonomous Data Warehouse (ADW).
• Experience building and managing pipelines in OCI Data Integration Cloud Service.
• Strong background with Oracle Cloud Infrastructure (OCI) administration and resource configuration.
• Advanced SQL skills, including query optimization, analytical functions, and performance tuning.
• Experience designing and maintaining STAR schemas and dimensional data models.

Preferred Qualifications:

• Experience integrating ADW with analytics platforms such as Oracle Analytics Cloud (OAC).
• Familiarity with broader OCI data services (Object Storage, Data Catalog, Data Flow, GoldenGate).
• Knowledge of ETL/ELT best practices and cloud based data warehousing strategies.
• Exposure to data governance, metadata management, and security best practices in cloud environments.