Oracle Cloud Architect - Remote

CNET Global Solutions, INC

United States

1 day ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Cloud Computing Software Documentation Databases Extract Transform Load (ETL) Data Stores Dimensional Modeling Metadata Oracle (Applications) PL-SQL SQL Databases Data Logging Oracle Service Cloud

+1 more

Web Api

Job description

Developing automated ETL.
Designing & implementing enterprise class data repositories built upon Oracle on prem and cloud hosted DB’s.
Expertise in dimensional modeling and ability to act as a technical mentor.

Requirements

Has extensive practical experience with the modern Oracle platforms and technologies. This includes the following:
Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.
Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.
Practical experience utilizing API calls for automated data refreshes.
Practical experience with Oracle Analytics Cloud (OAC)
Mastery of SQL and PL/SQL and the ability to develop complex procedures, functions, views, and scripts.
Expertise in dimensional modeling.
Experience with tabular data models.
Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust, performant, scalable, reliable, and expandable.
Demonstrates a disciplined approach to process and error logging.
Maintains excellent work habits when it comes to coding comments, system documentation, and metadata creation.
Ability to serve as a technical mentor to both senior and junior IT staff.
Ability to develop architectural diagrams and system documentation, and train others on the content.
Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.
Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.