Remote Oracle ADW DBA & ETL Engineer - OCI Data Integration

VSO Inc.; United States; Remote; USD 110,000 - 170,000; Full time

Benefits offered by this job

Health benefits

Flexible work arrangements

Learning & development

Job summary

VSO Inc. is seeking an Oracle ADW Database Administrator & ETL Engineer to join our fully remote USA team. You will establish, configure, and maintain Oracle ADW in OCI, and design ETL pipelines to support analytics.

Strong SQL and data modeling skills are essential to optimize STAR schemas. You will collaborate with analytics, data engineering, and infrastructure teams to ensure secure, scalable data flows and reliable reporting.

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.

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.

Skills

Advanced SQL

Oracle ADW experience

ETL Engineering

OCI Data Integration

STAR schemas design

OCI administration

Tools

OCI Data Integration Cloud Service

Oracle Cloud Infrastructure (OCI) administration

Job description

VSO Inc. is seeking an Oracle ADW Database Administrator & ETL Engineer to join our fully remote USA team. You will establish, configure, and maintain Oracle ADW in OCI, and design ETL pipelines to support analytics.

Strong SQL and data modeling skills are essential to optimize STAR schemas. You will collaborate with analytics, data engineering, and infrastructure teams to ensure secure, scalable data flows and reliable reporting.