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

REV LLC; United States; Remote; USD 76,000 - 96,000; Part time

Job summary

REV LLC is seeking a hands-on Oracle Autonomous Data Warehouse (ADW) Database Administrator and ETL Engineer for a six-month remote engagement in the United States. You will configure and administer ADW in OCI, build data integration pipelines, and develop SQL for dimensional models.

Ideal candidates will have 3–5 years in data warehousing or cloud data engineering, plus experience with OCI tools and Oracle Analytics Cloud.

Qualifications

• 3–5 years 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.
• Familiarity with OCI Object Storage, Data Catalog, Data Flow, GoldenGate, or Oracle Analytics Cloud is preferred.

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

Oracle ADW

OCI Data Integration

SQL development

Dimensional modeling

Star schema

Data governance

Metadata management

Data security

Analytics Cloud access

Tools

OCI Data Catalog

OCI Data Flow

GoldenGate

Oracle Analytics Cloud

OCI Object Storage

Job description

Company: REV

Engagement Type: 1099 Independent Contractor

Pay Range: $55–$70/hour, depending on experience, degree, and certifications

Duration: 6 months

Location: Remote—USA

About the Opportunity

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.

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.

Qualification and Technical Experience

• 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.
• Familiarity with OCI Object Storage, Data Catalog, Data Flow, GoldenGate, or Oracle Analytics Cloud is preferred.

Engagement Requirements

• 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.

Equal Opportunity

REV is an equal opportunity organization. Candidates are evaluated based on job‑related qualifications and applicable legal requirements. Reasonable accommodations are available during the application and selection process.