Data Warehouse Admin Database Admin

up to 3 year full time W2 contact (largestate project)

$60 / hr

KeyDuties / Responsibilities :

• Performs datawarehouse administration for the Enterprise Data Warehouse in theOracle Cloud Infrastructure Oracle Autonomous Data WarehouseEnvironment
• Reviews existing architecture andprovides solution recommendations where applicable
• Develops tests and implements scripts / jobs fordata Extract Transform and Load (ETL) from data source(s) totarget(s) in the data warehouse using ODI
• Visualizes and designs the enterprise datamanagement framework : specifies processes used to plan acquiremaintain use archive retrieve control and purge data
• Develops physical data model and / or works withdata modeler to develop physical data model
• Develops Testing Approach Plan Scripts andDocumentation of Results
• Develops andmaintains a data catalog for the enterprise data warehouse
• Develops and maintains a data dictionary forthe enterprise data warehouse
• DevelopsRequirements Specifications
• Develops DesignSpecifications
• Evaluates and monitorsdatabases to resolve performance issues
• Monitors the EDW and responds to incidents
• Provides documentation to support the KimballDimensional Data Modeling Framework
• Mentorsand educates team members on best practices and industry standards

Qualifications : Mandatory :

Mandatory :

• Staffresource must have a minimum of seven (7) years of verifiableexperience in database design and warehouse architecture supportiveof key duties / responsibilities identified above.
• Excellent communication and collaborationskills to work effectively with stakeholders and team members.
• Certified for Oracle Autonomous Database Cloud2021 Certified Specialist and / or Oracle Machine Learning usingAutonomous Database 2021 Certified Specialist
• Certified on Oracle Cloud infrastructure 2021certified architect professional
• Certified forOracle data integrator 12C certified implementationspecialist

Desired :