Senior Data Warehouse Administrator/ Database Administrator

We are seeking a Senior Data Warehouse Administrator for a long-term Hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client.

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-Hands-on 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