Oracle Autonomous Data Warehouse (ADW) Database Administrator & ETL Engineer

REV LLC • Bellevue, WA

4d • $55 - $70 • Remote

About The Position

REV is seeking a hands-on Oracle Autonomous Data Warehouse (ADW) Database Administrator and ETL Engineer for a six-month consulting engagement. The consultant will establish and administer an Oracle cloud data warehouse environment and build data integration pipelines in Oracle Cloud Infrastructure (OCI). The role involves independently configuring ADW, developing ETL/ELT workflows, writing advanced SQL, implementing dimensional models, troubleshooting issues, and documenting solutions.

Requirements

• Three to five years of relevant experience in data warehousing, database administration, ETL/ELT development, or cloud data engineering.
• Hands-on experience with Oracle Autonomous Data Warehouse and OCI Data Integration.
• 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.
• Willingness and ability to work as a 1099 independent contractor for six months.
• Ability to demonstrate personal, hands-on technical contributions.
• Ability to successfully complete all client-required security requirements before accessing client systems and information.

Nice To Haves

• Familiarity with OCI Object Storage, Data Catalog, Data Flow, GoldenGate, or Oracle Analytics Cloud.

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.

What This Job Offers

• Education Level: No Education Listed