Key Duties/Responsibilities:

- Performs data warehouse administration for the Enterprise Data Warehouse in the Oracle Cloud Infrastructure, Oracle Autonomous Data Warehouse Environment

- Reviews existing architecture and provides solution recommendations where applicable

- Develops, tests, and implements scripts/jobs for data Extract Transform and Load (ETL) from data source(s) to target(s) in the data warehouse using ODI

- Visualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge data

- Develops physical data model and/or works with data modeler to develop physical data model

- Develops Testing Approach, Plan, Scripts and Documentation of Results

- Develops and maintains a data catalog for the enterprise data warehouse

- Develops and maintains a data dictionary for the enterprise data warehouse

- Develops Requirements Specifications

- Develops Design Specifications

- Evaluates and monitors databases to resolve performance issues

- Monitors the EDW and responds to incidents

- Provides documentation to support the Kimball Dimensional Data Modeling Framework

- Mentors and educates team members on best practices and industry standards

Qualifications:

Mandatory:

- Staff resource must have a minimum of seven (7) years of verifiable experience in database design and warehouse architecture supportive of key duties/responsibilities identified above.

- Excellent communication and collaboration skills to work effectively with stakeholders and team members.

Desired:

- Certified for "Oracle Autonomous Database Cloud 2021 Certified Specialist" and/or "Oracle Machine Learning using Autonomous Database 2021 Certified Specialist"

- Certified on Oracle Cloud infrastructure 2021 certified architect professional

- Certified for Oracle data integrator 12C certified implementation specialist

Job Type: Contract

Pay: $55.00 - $70.00 per hour

Expected hours: 40 per week

Benefits:

• 401(k)

Experience level:

• 7 years

Schedule:

• Monday to Friday

Work Location: Hybrid remote in Sacramento, CA 95814