Data Warehouse Administrator

We are seeking a Data Warehouse Administrator for a long-term assignment working two days a week in Sacramento, CA. The office is required.  Our client will select which days of the week. Must currently live within 60-90 miles of Sacramento, CA.  Anyone who is not currently nearer the requirement location will be rejected.

 Responsibilities include:

• 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 models and/or works with a data modeler to develop a 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

 Required:

• Minimum seven (7) years of verifiable experience in database design and warehouse architecture, supportive of key duties/responsibilities identified above in an Oracle environment

• Hands-on working with and managing Oracle's Autonomous Data Warehouse (ADW) 
• Must have Oracle Data Integrator (ODI) experience.

• Proficient with various Oracle tools used to perform ETL, performance management, and tuning for an Oracle Data Warehouse and Oracle Cloud Infrastructure Environment.
• Senior hands-on Data Warehouse Administrator with strong communication skills 
• Proficient with various Oracle tools used to perform ETL, performance management, and tuning for an Oracle Data Warehouse and Oracle Cloud Infrastructure Environment.
• Senior hands-on Data Warehouse Administrator with strong communication skills.
• Detail-oriented ability to independently build and support an Oracle ADW data warehouse environment with minimal supervision
• Ability to translate business and functional requirements into technical requirements for a Data Warehouse.
• Based upon known and future workloads, be able to design VM configuration and resource allocation - inclusive of the CDB and PDB levels.
• Understand and be able to design and implement compartments, tagging, IAM policies for varied user groups and roles accessing the OADW or OCI tenancy.
• Understand and be able to guide best practices around tenancy DRG and LPG design and performance
• Detail-oriented ability to independently build and support an Oracle ADW data warehouse environment in the public cloud with minimal supervision
• Ability to translate business and functional requirements into technical requirements for a Data Warehouse and implement the approved design
• Based upon known and future workloads, be able to design VM configuration and resource allocation - inclusive of the CDB and PDB levels.
• Understand and be able to design and implement compartments, tagging, IAM policies for varied user groups and roles accessing the OADW or OCI tenancy.
• Understand and be able to guide best practices around tenancy DRG and LPG design and performance
• Candidate needs to demonstrate direct, hands-on, recent practical experience in the identified areas, with specific examples.

 Preferred:

• 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 of ETL experience.