Quick overview
Job description
OCI Oracle ATP Database Architect -
Remote (USA)
Video Interview
Description:
- Design and implement data lake architecture leveraging Oracle ATP, OCI services, and Oracle analytics tools.
- Define standards and patterns for Landing (Raw), Unified (Consolidated) and Structured (Curated) data layers.
- Establish data modeling approaches (normalized, dimensional, and hybrid models) aligned with analytics and reporting needs.
- Build ingestion pipelines to load massive data from source systems (F&B POS).
- Support batch and near†real†time ingestion using tools such as OCI Data Integration, OIC, OCI Object Storage, REST APIs, and file†based loads.
- Preserve source fidelity, metadata, and audit attributes (load dates, source system identifiers, record counts).
- Implement data quality validations, reconciliation controls, and error handling.
- Transform raw data into cleansed, conformed, and analytics†ready structures.
- Develop business†friendly schemas, dimensions, and fact tables to support reporting, dashboards, and advanced analytics.
- Implement data enrichment, harmonization, and reference data management logic.
- Optimize SQL, indexing, partitioning, external tables, and materialized views to ensure high performance and scalability within Oracle ATP.
- Collaborate with governance and security teams to ensure compliance with data privacy, retention, and access control policies
- Experience getting data from MS SQL Server Database and My SQL (Optional)
Similar jobs
- UO

PEER RECOVERY SPECIALIST CERTIFIED
University of New Mexico - Hospitals · Edgewood, NM · Hybrid · Posted 9 Nov 2026 🇺🇸
BLSMental HealthPatient CareSalary not listed - UO

COUNSELOR SOCIAL WKR CLIN
University of New Mexico - Hospitals · Peralta, NM · Hybrid · Posted 26 Oct 2026 🇺🇸
Case ManagementMental HealthOutreach+1Salary not listed - RA
Dietary AideRecently posted
Regency at Shelby Township · Utica, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$16 - $17/hr - RA
Laundry AideRecently posted
Regency at Bluffs Park · Ann Arbor, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
NursingSalary not listed - EM

Admissions CoordinatorRecently posted
Ely Manor · Allegan, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
CRMMedical TerminologyNursingSalary not listed - TL
Dietary AideRecently posted
The Laurels of Sandy Creek · Wayland, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$16 - $17/hr - CH

Float Business Office CoordinatorRecently posted
Ciena Healthcare · Grand Rapids, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Accounts ReceivableNursingPatient Care+1Salary not listed - RA
Business Office Coordinator (BOC)Recently posted
Regency at Whitmore Lake · Whitmore Lake, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$10k/mo - RA
Activity AideRecently posted
Regency at Whitmore Lake · Whitmore Lake, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$16 - $17/hr - RA
Dietary AideRecently posted
Regency at Whitmore Lake · Whitmore Lake, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$18/hr - CH

Float Business Office CoordinatorRecently posted
Ciena Healthcare · Detroit, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Accounts ReceivableNursingPatient Care+1Salary not listed - HR
Certified Dietary Manager (CDM)Recently posted
Hickory Ridge of Temperance · Temperance, MI · On-site · Posted 16 Nov 2026 🇺🇸
ComplianceFood SafetyNursing+1Salary not listed