Oracle Data Warehouse Administrator
Sacramento, CA, United States
Exp - 9+Years
Client - Photon Infotech/ Client
Rate $68/hr on W2
Oracle Data Warehouse Administrator
Local to Sacramento area, CA
Visa: NO H1B/CPT/OPT
Duration: 3 years Contract
MOI: Video
Specific
Candidates must have a LinkedIn profile with a picture
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.
Description
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.
#J-18808-Ljbffr