Data Warehouse Administrator
Remote Candidates must have a LinkedIn profile with a picture Team Viewer Interviews Description We are seeking a Data Warehouse Administrator for a l
ong-term assignment, working 100% remotely from anywhere in the US. 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 Education team members on best practices and industry standards
Required: - 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.