Oracle Data Warehouse Administrator
Hybrid – Sacramento, CA(Locals to CA)
Visa: NO H1B & CPT
MOI: Team Viewer Interviews
The position is with the State of California
Candidates must have a LinkedIn profile with a picture
Description
We are seeking a Data Warehouse Administrator for a 3-year Hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California
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
• 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
Required:
• 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.
Preferred:
• 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
Regards,
Adarsh Sharma |
Senior Technical Recruiter |