Oracle Autonomous Data Warehouse (ADW) Engineer

NexGen Technologies, Inc.; United States; Remote; USD 125,000 - 135,000; Full time

Job summary

NexGen Technologies, Inc. is seeking an Oracle Autonomous Data Warehouse (ADW) Engineer to establish, configure, and maintain the ADW environment and to implement data ingestion pipelines using OCI Data Integration services for federal contracts.

The role emphasizes strong SQL, data modeling with STAR schemas, and cloud-based Oracle data technologies. Requirements include 3–5 years in Oracle DB/ETL roles, OCI administration, and collaboration with analytics and infrastructure teams to support

Qualifications

• 3–5 years of experience as an Oracle Database Administrator or ETL Engineer.
• 3–5 years of hands-on experience with Oracle Autonomous Data Warehouse (ADW).
• Experience building and managing pipelines in OCI Data Integration Cloud Service.
• Experience designing and maintaining STAR schemas and dimensional data models.
• Strong background with Oracle Cloud Infrastructure (OCI) administration and resource configuration.
• Advanced SQL skills, including query optimization, analytical functions, and performance tuning.

Responsibilities

• Provision, configure, and administer Oracle ADW instances within OCI.
• Implement and manage data ingestion pipelines using OCI Data Integration.
• Develop ETL/ELT workflows to load, transform, and stage data for analytics.
• Design, build, and maintain STAR schemas optimized for reporting and performance.
• Monitor performance, storage usage, and query efficiency in the ADW environment.
• Collaborate with analytics, data engineering, and infrastructure teams to support reporting needs.
• Ensure security, access control, and proper OCI resource configuration.
• Document data models, ETL pipelines, and data mapping for maintainability.

Skills

Oracle ADW experience

OCI administration

SQL proficiency

ETL/ELT design

Data modeling

Education

Bachelor's degree in MIS/CS/Data Engineering

Tools

OCI Data Integration Cloud Service

Oracle Analytics Cloud

Job description

Oracle Autonomous Data Warehouse (ADW) Engineer

NexGen Technologies, Inc. is a leading IT services firm specializing in delivering innovative, high-quality solutions to our federal government clients. Our core competencies include IT professional support services, software development, cloud services, IT Operations, Agile project management, and GIS services.

Job Summary

As an Oracle Autonomous Data Warehouse (ADW) Engineer, you 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. The project focus is standing‑up of an Oracle Autonomous Data Warehouse and implementation of OCI Data Integration pipelines. 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.

Supervisory Responsibilities

• There are no supervisory responsibilities.

Essential Duties and Responsibilities (as assigned)

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

Other duties may be assigned.

Technical Skills

• 3–5 years of experience as an Oracle Database Administrator or ETL Engineer.
• 3–5 years of hands‑on experience with Oracle Autonomous Data Warehouse (ADW).
• Experience building and managing pipelines in OCI Data Integration Cloud Service.
• Experience designing and maintaining STAR schemas and dimensional data models.
• Strong background with Oracle Cloud Infrastructure (OCI) administration and resource configuration.
• Advanced SQL skills, including query optimization, analytical functions, and performance tuning.

Desired Skills

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

Education

• Bachelor’s degree in Management Information Systems, Computer Science, Data Engineering, or related discipline.

Additional Requirements

• Strong written and verbal communication skills with attention to detail and clarity.
• The successful candidate will be able to pass background screening prior to employment.
• US Citizenship, legal permanent residence, or US work authorization with minimum 3 years of US presence is required due to federal contract requirements.

NexGen Technologies Inc. is an equal opportunity employer.

Compensation:$125,000-135,000/year

(The successful candidate's starting pay will fall within the salary range provided and isdeterminedbased on job-related factors, including, but not limited to, experience, qualifications, knowledge, skills, geographic work location, and market conditions)