OCI Oracle ATP Database Architect
Advantra Consulting Group
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)
Vacancy posted 21 hours ago
Similar jobs that could be interesting for youBased on the OCI Oracle ATP Database Architect in United States vacancy
$175k - $185k
..., VA, United States | Posted on 10/28/2026 Job Title: Oracle Cloud Infrastructure (OCI) Engineer Work Arrangement: Hybrid (remote, with up to... ...hands-on OCI engineering experience together with Oracle Database and Oracle Exadata expertise, migrations of on-premises...Oracle databaseFull timeRemote workMonday to Friday1 day per weekDhaka Technology Limited
Sterling, VA21 hours ago- ...Varmoda is seeking an experienced, hands-on Oracle EBS / OCI Lead to own the administration, support and optimization of Oracle E-Business... ...finance and operations platform, accountable for application, database and cloud-layer issues alike. We are looking for a practitioner...Oracle database
- ...securing, deploying, and operating Oracle AI solutions and agency Proofs... ...development, Oracle AI Database and data engineering, AI security... ...responsible-AI controls, and OCI DevSecOps/platform engineering... ...certification and OCI DevOps or Architect certification. Oracle...Oracle databaseLocal area
ExpediteInfoTech, Inc.
Rockville, MD27 days ago - ...Responsibilities: The Cloud Infrastructure Architect/Specialist will provide... ...PeopleSoft and its supporting Oracle technologies on Oracle Cloud Infrastructure (OCI). The consultant will be... ...Oracle WebLogic Server, Oracle Database, and Oracle Kubernetes Engine (OKE...Oracle database
V Group Inc.
New York, NY20 days ago - ...establishment, and technical delivery of EIT Oracle AI and OCI solutions for the Oracle AI Innovation... ...spanning OCI Generative AI, Oracle AI Database and vector capabilities, RAG, agentic... ...architecture requirements. OCI Architect Professional, OCI Generative AI...Oracle databaseLocal area
ExpediteInfoTech, Inc.
Rockville, MD27 days ago $84.77 per hour
...Job Description Job Description VDH Oracle OCI Cloud Engineer (806807) Title/Role: VDH Oracle OCI Cloud Engineer Region Description... ...Only Work Arrangement: Hybrid Short Description: VDH Database Administrator VENDOR MAXIMUM SUBMITTAL RATE: $84.77hr....Oracle databaseWork at officeWeekend workPeopleNTech LLC
Richmond, VA18 days ago- ...Senior Oracle DBA – Cloud Migrations, Upgrades & APEX Specialist... ...Oracle DBA to architect, install and maintain Oracle Database infrastructure in on-prem... ...-premises datacenters to OCI DB Systems, and Autonomous... ...Systems, Autonomous Database (ATP), and Exadata Cloud...Oracle databaseShift work
- ...monitoring, and supporting security controls across Oracle E-Business Suite R12/R12.2 and Oracle Cloud Infrastructure (OCI). The specialist will manage user access, IAM, roles, authentication, authorization, database security, cloud security, integrations, and compliance...Oracle database
Ampcus Incorporated
Washington DC18 days ago - ...Job Description Job Description OCI Cloud Infrastructure Architect/Specialist Contract Length: 2 years... ...support enterprise applications on Oracle Cloud Infrastructure (OCI). This... ...-to-OCI migrations involving Oracle Database, WebLogic, SOA, WebCenter, and Identity...Oracle databaseContract work
Crossfire Consulting Corporation
New York, NY10 days ago $104.8k - $149.3k
...reporting to Vice President of DI, Database & Enterprise Tools. This team... ...-critical database and Oracle EBS solutions.How will you make... ...database frameworkImplement architected HA/DR solutions to ensure... ...data centers, the cloud (AWS & OCI)Research technology, support...Oracle databaseFor contractorsWork experience placementWork at officeLocal areaWorldwideRelocation packageWabtec
Pittsburgh, PA2 days ago- ...applications, PeopleSoft Update Manager (PUM) upgrades, and Oracle Cloud Infrastructure (OCI) migrations. The ideal candidate will lead large-scale... ...programs involving PeopleSoft applications, databases, middleware, and cloud infrastructure. Experience 15+ Years...Oracle databaseContract work
- .... ~ Proven experience leading PeopleSoft migrations to Oracle Cloud Infrastructure (OCI). ~ Strong knowledge of PeopleSoft Architecture, PeopleTools... ...initiatives. ~ Strong understanding of Oracle Database, WebLogic, Integration Broker, and PeopleSoft environments...Oracle databaseContract work
The Dignify Solutions, LLC
New York, NY18 days ago - ...Data Architect PositionCTG is seeking to fill a Data Architect position for our client. Location... ...activities. Architect and optimize Oracle database solutions, including schema design,... ...experience. Relevant certifications such as OCI, DAMA, or CDMP are preferred. Excellent...Oracle database
Computer Task Group
Dallas, TX1 day ago $61.6 - $88 per hour
...Data Architect (DAR)We are seeking a Data Architect to own the strategic design and governance... ...enterprise data landscape, built on Oracle on-premise database platforms and modeled using Erwin.... ...functions.Relevant certifications (OCI, DAMA, CDMP, etc.) is a plus.Experience...Oracle databaseYoh
Dallas, TX3 days ago$100k - $110k
...7000, and has 58 offices in 22 countries within key global markets. Our Challenge We are seeking a highly skilled Oracle Database architect to join our dynamic team. As a Senior Developer, the candidate will be responsible for designing, developing, testing, and...Oracle databaseTemporary workFlexible hoursSynechron
Charlotte, NC20 days ago$84.5k - $187k
...Description Principal Financial Analyst OCI Storage ABOUT THE JOB Oracle Cloud Infrastructure (OCI) is one of the fastest growing and most... .... OCI also serves as the foundation for Oracles database analytics and application services including Autonomous...Oracle databaseFull timeTemporary workFlexible hoursOracle
Nashville, TNa month ago- ...our team of strategic advisers and architects, differentiated by our industry... ...Integration Solutions on the Cloud Database Operations team, you will be... ...for: Administering and optimizing Oracle Database 19c/23c environments across OCI DB Systems, Exadata Cloud Service...Oracle databaseLocal area
Deloitte
Lake Mary, FL4 days ago $147.3k - $243.8k
...Solution Engineer, Data Platform & OCI - State and Local Government Industry Oracle As the provider of the world's... ...delivers industry-leading database, analytics, AI, and data management... ...directly with executive stakeholders, architects, and line-of-business leaders to...Oracle databaseTemporary workLocal areaFlexible hours$103k - $264.1k
...Job Description Senior Oracle Health Principal Data Migration Architect Job Description We are seeking experienced... .... Advanced SQL and database knowledge. Experience with data... .... Oracle Cloud Infrastructure (OCI) experience. Healthcare SaaS migration...Oracle databaseTemporary workFlexible hours- ...deliver that growth. Edison Works is seeking an experienced Database Architect to lead the architecture, design, standardization, and... ...future. This role requires deep technical expertise in both Oracle and Microsoft SQL Server, with responsibility for platform availability...Oracle databasePermanent employmentRelocation package
$155k - $210k
...About the role and what you'll be doing: The Expert Database Architect serves as Ensono's highest level of technical authority for... ...least one of the following: ~ Microsoft SQL Server ~ Oracle Database ~ PostgreSQL ~ MySQL ~ MongoDB and NoSQL...Oracle databaseFull timeTemporary workRemote workWork from homeFlexible hours- ...DescriptionResponsibilities Work with the County resources and Oracle implementation team to create Autonomous Database(ADB) in the Oracle Cloud. Ensure data... ..., and Oracle Autonomous Database (ATP and ADW).Cloud Architecture & Networking: Mastery over OCI-specific cloud configurations like...Oracle databaseWork experience placement
Mindlance
San Bernardino, CA21 hours ago $84.5k - $187k
Principal Finance Analyst, Product Lead - Workload Health Oracle Cloud Infrastructure (OCI) is one of the fastest growing businesses for the company... ...serves as the foundational layer for Oracle Autonomous Database, as well as for Oracle’s platform and application services...Oracle databaseTemporary workFlexible hoursOracle Corporation
Nashville, TN4 days ago- ...Engineering role. Strong experience with enterprise relational database platforms. Oracle highly preferred. Advanced proficiency in SQL, PL/SQL... .... Experience with Oracle Cloud, Oracle Fusion, ADW, ATP, OAC, FDI, OCI Data Integration, AIDP Workbench, or Object Storage....Oracle databaseFull timeWork at officeRemote work
$40 - $50 per hour
...Oracle OCI Cloud Monitoring & Observability Engineer Location: Atlanta GA - Onsite 100% Contract Rate :- $40-$50/hr Job Description... ...and management of OCI resources. Knowledge of Oracle database systems and other databases like MySQL and PostgreSQL for performance...Oracle databaseHourly payContract work- ...Description: The Cloud Infrastructure Architect/Specialist will provide... ...PeopleSoft and its supporting Oracle technologies on Oracle Cloud Infrastructure (OCI). The consultant will be responsible... ...Oracle WebLogic Server, Oracle Database, and Oracle Kubernetes Engine (...Oracle database
- ...has expertise with erwin Data Modeler, Oracle, and Microsoft SQL Server, along with experience... ...solutions. Working closely with data architects, DBAs, ETL developers, and business... ...generationStrong experience with Oracle databases (11g/12c/19c/21c) and Microsoft SQL Server...Oracle databaseLocal area
Genius Road
Dallas, TX1 day ago - ...Seeking an experienced Oracle DBA with strong Database Migration Services (DMS) expertise to administer enterprise Oracle databases and lead database... ...Database Migration Service (DMS) ~ Oracle GoldenGate ~ OCI / Exadata / ExaCC ~ Database migration and modernization...Oracle databaseContract work
Techvilla Solutions
Houston, TXa month ago $125k - $145k
...Science, Information Technology, or a related field. 8+ years of Oracle Database Administration and Engineering experience. Expert knowledge... ...Experience with Oracle Cloud Infrastructure (OCI). Oracle certification (OCP, OCM, or equivalent). Experience...Oracle databaseLocal area$287.3k - $371.8k
...® data management software is coming to Oracle Cloud Infrastructure as a first party, fully... ...discussions, then bring in solution architects when a deal needs depth. • Turn customer... ...how enterprise workloads such as Oracle databases, VMware, SAP, and file services move to...Oracle databaseFull timeLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to OCI Oracle ATP Database Architect. Be the first to apply!
Related searches
- principal data architect United States
- data integration architect United States
- hadoop big data architect United States
- azure data architect United States
- enterprise data architect United States
- senior data architect United States
- remote data architect United States
- data center architect United States
- data architect United States
- big data architect United States