Data Warehouse Administrator/Database Administrator Job at Guru Schools in Sacra

**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 - 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 - Develops Requirements Specifications - Develops 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:** - 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. - Excellent communication and collaboration skills to work effectively with stakeholders and team members. **Desired:** - Certified for "Oracle Autonomous Database Cloud 2021 Certified Specialist" and/or "Oracle Machine Learning using Autonomous Database 2021 Certified Specialist" - Certified on Oracle Cloud infrastructure 2021 certified architect professional - Certified for Oracle data integrator 12C certified implementation specialist