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.
Numbers & Facts
Location
Washington DC, DC (Remote)
Skills
Access Controlunmatched
Analysis Skillsunmatched
Analytics Cloudunmatched
Best Practicesunmatched
Cloud Computingunmatched
Data Administrationunmatched
Data Analysisunmatched
Data Managementunmatched
Data Mappingunmatched
Data Modelingunmatched
Data Storageunmatched
Data Warehousingunmatched
Database Administrationunmatched
Database Extract Transform and Load (ETL)unmatched
Dimensional Modelingunmatched
Documentation Modelsunmatched
Metadataunmatched
Oracleunmatched
Oracle DBA (Database Administrator)unmatched
Performance Analysisunmatched
Performance Tuning/Optimizationunmatched
Query Analysisunmatched
Query Optimizationunmatched
SQL (Structured Query Language)unmatched
Sales Pipelineunmatched
Star Schemaunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.