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

Are you looking to take the next step in your career as an Oracle Autonomous Data Warehouse (ADW) Database Administrator & ETL Engineer? Let's chat and see if we are a good match!

Opportunity:

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.

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.