Database Admin Lead

Role: Database Admin Lead

Location: Sacramento, CA. Hybrid work required. 2 days required in-office (Monday & Wednesday)

Certifications: Oracle (Must)

ODI & ADW & OCI experience

Required to have Lead experience running projects.

Senior Data Warehouse Administrator/Database Administrator

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