Cleared IT Positions - Oracle Autonomous Data Warehouse (ADW) Da

Virtual, Inc.
United States
3 days ago
Apply on www.clearancejobs.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

Business Analytics Applications Data Analysis Cloud Computing Cloud Database Databases Data as a Services Information Engineering Data Governance Data Integration Extract Transform Load (ETL) Data Mapping Data Warehousing
+16 more
Document-Oriented Databases Meta-Data Management Oracle Databases Oracle (Applications) Oracle Warehouse Builder Performance Tuning Query Optimization Cloud Services Data Streaming Cloud Platform System Sql Optimization Analytic Functions Database Performance Oracle Analytics Cloud Oracle Cloud Infrastructure Data Pipelines

Job description

Virtual Service Operations is searching for an Oracle Autonomous Data Warehouse (ADW) Database Administrator & ETL Engineer to join our team. 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., * 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.

Requirements

  • 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., * At least 3-5 years of professional experience

  • This is a remote position
  • Active Public Trust Clearance
  • Please note that this specific position requires U.S. citizenship status

What is Important to Us:

  • You are an excellent communicator in writing and speaking.
  • You have the ability to work independently but also value teamwork.
  • Your problem-solving skills are excellent.
  • You are looking for a job where performance appraisals occur regularly, and you look forward to advancing your career.
  • You seek a community of virtue-centered co-workers and clients.

Benefits & conditions

What we offer you: As part of the VSO company, you will be part of a virtue-centered team who value their work and teammates. This is a no-jerk zone. We provide ongoing learning and development opportunities to foster continuous growth. We offer competitive salaries, health benefits, and flexible work arrangements.

About the company

More About VSO: VSO is a hybrid cloud and managed services consulting firm. Much of VSO’s success can be attributed to our deep partnerships with IT services industry leaders such as AWS, IBM, Microsoft and others. VSO leverages numerous other partner relationships so as to provide our customers with optimal support. Additionally, we take pride in taking care of our employees. We offer a wide variety of benefits for eligible employees related to health, retirement, professional development, and more! For more information, please visit our website at https://vso-inc.com/careers

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.clearancejobs.com
Prepare application

Good distractions

Loading talks and stories from around this role…