Job Opportunities - Sr. Data Warehouse Administrator/Database Administrator in Sacramento, CA (Hybrid – 2 Days Onsite work required)

Role: Sr. Data Warehouse Administrator/Database Administrator

Location: Sacramento, CA (Hybrid – onsite work required)

Two days a week in office required. Client will select which days of the week. Must live within 60-90 miles maximum from location.

Requirements:

·      Senior hands-on Data Warehouse Administrator with strong communication skills.

·      Detail oriented ability to independently build and support a Oracle ADW data warehouse environment with minimal supervision

·      Ability to translate business and functional requirements into technical requirements for a Data Warehouse.

·      Candidate needs to be able to demonstrate, direct hands-on recent practical experience in the areas identified with specific examples.

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

·      Hands-on experience working with and managing Oracle''s Autonomous Data Warehouse (ADW) service

·      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

·      Participates in developing Requirements Specifications

·      Participates in developing 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 in an Oracle environment

·      At least two (2) years of experience in the last 6 years administering Oracle Autonomous Data Warehouse in an Oracle Cloud Infrastructure Environment.

·      5 years’ experience administering Oracle data warehouses within the last 10 years

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

·      Proficient with various Oracle tools used to perform ETL, performance management, and tuning for an Oracle Data Warehouse and Oracle Cloud Infrastructure Environment.

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

·      Ability to develop and perform Extract, Transform and Load (ETL) activities using Oracle tools with at least 2 years ETL experience.