Senior Data Warehouse Administrator/Database Administrator

Senior Data Warehouse Administrator/Database Administrator

Position: Senior Data Warehouse Administrator/Database Administrator

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

Duration: Long Term

Client: Loblolly/State of CA

Job Description: Requirements:

• Senior hands-on Data Warehouse Administrator with strong communication skills.
• Detail oriented ability to independently build and support an Oracle ADW data warehouse environment at the public cloud with minimal supervision
• Ability to translate business and functional requirements into technical requirements for a Data Warehouse and implement 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 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
• As necessary, 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 in collaboration with team specialists
• Experience with OCI Access Management and processes
• 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 in the OADW
• Develops Testing Approach, Plan, Scripts and Documentation of Results
• Participates in Developing and maintaining the data catalog(s) for the enterprise data warehouse
• Participates in Developing and maintaining the data dictionary(ies) 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:

• Certified for "Oracle Autonomous Database Cloud 2021 Certified Specialist" and/or "Oracle Machine Learning using Autonomous Database 2021 Certified Specialist"
• 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 a 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 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.