Remote Oracle ADW DBA & ETL Engineer for OCI

REV LLC; Bellevue (WA); Remote; USD 76,000 - 90,000; Full time

Job summary

REV is seeking a hands-on Oracle Autonomous Data Warehouse (ADW) Database Administrator and ETL Engineer for a six-month consulting engagement. This consultant will establish and administer an Oracle cloud data warehouse environment and build data integration pipelines in Oracle Cloud Infrastructure (OCI).

The ideal candidate can independently configure ADW, develop ETL/ELT workflows, write advanced SQL, implement dimensional models, troubleshoot issues, and document solutions.

Qualifications

• Three to five years of experience in data warehousing, database administration, ETL/ELT development, or cloud data engineering.
• Hands-on experience with Oracle Autonomous Data Warehouse in OCI.
• Strong SQL development, optimization, and troubleshooting skills.
• Experience with dimensional modeling and star-schema design.
• Knowledge of cloud data warehouse architecture, data governance, metadata management, and security.

Responsibilities

• Configure, administer, and support Oracle Autonomous Data Warehouse in OCI.
• Build and maintain OCI Data Integration pipelines and data-loading processes.
• Develop and optimize advanced SQL queries and transformations.
• Design dimensional data models, including star schemas.
• Troubleshoot integration failures, data quality issues, and performance bottlenecks.
• Apply data governance, metadata management, and cloud security practices.
• Support Oracle Analytics Cloud and related OCI data services.
• Document configurations, pipelines, and technical solutions.

Skills

SQL

Dimensional modeling

Star schema

Cloud data warehousing

Data governance

Tools

Oracle Autonomous Data Warehouse

OCI Data Integration

Oracle Analytics Cloud

GoldenGate

OCI Object Storage

Data Catalog

Data Flow

Job description

REV is seeking a hands-on Oracle Autonomous Data Warehouse (ADW) Database Administrator and ETL Engineer for a six-month consulting engagement. This consultant will establish and administer an Oracle cloud data warehouse environment and build data integration pipelines in Oracle Cloud Infrastructure (OCI).

The ideal candidate can independently configure ADW, develop ETL/ELT workflows, write advanced SQL, implement dimensional models, troubleshoot issues, and document solutions.