5 Data Warehouse Administrator Jobs in Sacramento, CA
eStaff LLC is Hiring a Data Warehouse Administrator Near Sacramento, CA
We are recruiting Data Warehouse Administrators for a project starting in July/August. The positions will be long-term, and we are looking for local candidates in the Sacramento, CA, area.
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:
- Public sector experience
- 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
Job Summary
Full Time
$95k-118k (estimate)
06/23/2024
07/10/2024
WEST ISLIP, NY
50 - 100
2013
$10M - $50M
Related Companies
The following is the career advancement route for Data Warehouse Administrator positions, which can be used as a reference in future career path planning. As a Data Warehouse Administrator, it can be promoted into senior positions as a Data Warehouse Administrator, Senior that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Data Warehouse Administrator. You can explore the career advancement for a Data Warehouse Administrator below and select your interested title to get hiring information.
