Senior Data Warehouse Administrator/ Database Administrator

7 days ago


Sacramento, United States eStaffLLC Full time

We are seeking a Senior Data Warehouse Administrator for a long-term Hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client.

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
  • Hands-on working with and managing Oracle's Autonomous Data Warehouse (ADW) service
  • 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
  • Participates in developing Requirements Specifications
  • Participates in developing 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
Job Requirements

Required:
  • Minimum seven (7) years of verifiable experience in database design and warehouse architecture supportive of key duties/responsibilities identified above in an Oracle environment
  • At least two (2) years of experience in the last 6 years administering Oracle Autonomous Data Warehouse in a Oracle Cloud Infrastructure Environment.
  • 5 years experience administering Oracle data warehouses within the last 10 years
  • Excellent communication and collaboration skills to work effectively with technical stakeholders and team members.
  • Proficient with various Oracle tools used to perform ETL, performance management, and tuning for an Oracle Data Warehouse and Oracle Cloud Infrastructure Environment.
  • Senior hands-on Data Warehouse Administrator with strong communication skills.
  • Detail oriented ability to independently build and support a Oracle ADW data warehouse environment with minimal supervision
  • Ability to translate business and functional requirements into technical requirements for a Data Warehouse.
  • Candidate needs to be able to demonstrate, direct hands-on recent practical experience in the areas identified with specific examples.
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
  • Ability to develop and perform Extract, Transform and Load (ETL) activities using Oracle tools with at least 2 years ETL experience.


  • Sacramento, United States Estaffllc Full time

    We are seeking a Senior Data Warehouse Administrator for a long-term Hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client.Scroll down to find an indepth overview of this job, and what is expected of candidates Make...


  • Sacramento, United States My3Tech Full time

    Hello,Hope you are doing good.Position: Senior Data Warehouse Administrator/Database AdministratorLocation: Sacramento, CA (Hybrid – onsite work required)Duration: Long TermClient: Loblolly/State of CAJob Description:Requirements:Senior hands-on Data Warehouse Administrator with strong communication skills.Detail oriented ability to independently build and...


  • Sacramento, United States Qualitative Financials Full time

    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...


  • Sacramento, United States TWO95 International Full time

    Title – Oracle Database Administrators Job Type – Contract(3 +years) with extensions Location – Sacramento, California Rate – Best Rate possible Job description Required Skills: • 4+ years of Oracle database administration experience (including hands-on experience on Oracle database upgrades, and database patching) • 2+ years of Hands-on...


  • Sacramento, California, United States Qualitative Financials Full time

    Qualitative Financials is seeking a highly skilled Data Warehouse Specialist to join our team.We offer an estimated salary of $110,000 - $160,000 per year based on industry standards and location.The successful candidate will have at least seven years of experience in database design and warehouse architecture, as well as strong skills in Oracle Data...


  • Sacramento, California, United States Madison Square Senior Living Full time

    Job Overview:Madison Square Senior Living seeks an experienced Senior Administrative Aide to join our team. In this role, you will provide administrative support to our staff, including coordinating tasks, communicating with agencies, and ensuring all documentation is properly completed and organized.Duties and Responsibilities:Serve as a liaison between our...


  • Sacramento, California, United States Qualitative Financials Full time

    At Qualitative Financials, we are seeking a highly experienced Enterprise Data Architect to lead our data warehouse team.We offer an estimated salary of $120,000 - $180,000 per year based on industry standards and location.The successful candidate will have at least seven years of experience in database design and warehouse architecture. Strong skills in...


  • Sacramento, California, United States Madison Square Senior Living Full time

    Job Title: Administrative CoordinatorAbout Madison Square Senior Living:We are seeking an organized and detail-oriented Administrative Coordinator to join our team at Madison Square Senior Living. As an Administrative Coordinator, you will play a vital role in coordinating essential administrative tasks, communicating effectively with various agencies...


  • Sacramento, United States Vanir Construction Management Full time

    About Vanir: Vanir Construction Management, Inc. has been exceeding client expectations for 41 years. Our progressive growth and quality of service has led Vanir to become consistently ranked among the top construction management firms in the nation by Engineering News-Record. As we continue growing into new areas and markets, our focus is to maintain a team...


  • Sacramento, California, United States Capio Group Full time

    About the RoleWe are looking for a highly skilled Enterprise Data Architect to join our team at Capio Group. As a key member of our organization, you will be responsible for developing and implementing a comprehensive data management strategy that aligns with our company's goals and objectives.Key Responsibilities:Develop a data management strategy that...


  • Sacramento, United States The Spartan Group LLC Full time

    Medford Volkswagen is focused on providing customers with an honest and simpler buying and service experience. we are currently seeking someone exceptional to take the helm. The ideal candidate will be a problem solver who has excellent communication skills and impeccable attention for detail. The candidate should also have experience working in an office...


  • Sacramento, United States Infojini Full time

    The Administrative Assistant II position will provide specialized administrative support for the Access to Program. Tasks include: • *Creation of AV Program Manual • *File gathering and data entry of AV program documents• *Scanning and photocopying of AV training documents -required for record-keeping • Review and processing TEC's• MS Access data...


  • Sacramento, United States Infojini Full time

    The Administrative Assistant II position will provide specialized administrative support for the Access to Program. Tasks include: • *Creation of AV Program Manual • *File gathering and data entry of AV program documents • *Scanning and photocopying of AV training documents -required for record-keeping • Review and processing TEC's • MS Access...


  • Sacramento, United States Infojini Full time

    The Administrative Assistant II position will provide specialized administrative support for the Access to Program. Tasks include: • *Creation of AV Program Manual • *File gathering and data entry of AV program documents• *Scanning and photocopying of AV training documents -required for record-keeping • Review and processing TEC's• MS Access data...


  • Sacramento, California, United States California Community Colleges Full time

    About the PositionThe California Community Colleges Chancellor's Office is seeking a Senior Administrative Professional to join their team. This is a full-time, permanent position based in Sacramento County.As a Senior Administrative Professional, you will be responsible for providing high-level administrative support to the IDEAS executive team. This will...


  • Sacramento, California, United States Infojini Full time

    About InfojiniWe are a dynamic organization seeking an experienced Administrative Coordinator Specialist to provide specialized administrative support for our Access to Program.Job SummaryThe ideal candidate will possess advanced skills in MS Word, Excel, and Access database, as well as excellent written and verbal communication skills. This role requires...


  • Sacramento, California, United States Sutter Health Full time

    We are looking for an experienced administrative professional to join our team at Sutter Health.Job Overview:This role involves providing high-level administrative support to a senior leader, requiring exceptional organizational skills, attention to detail, and the ability to work independently with minimal supervision.About Our Team:Sutter Health is a...


  • Sacramento, California, United States Vanir Construction Management Full time

    About Vanir Construction Management, Inc.We are a consistently ranked top construction management firm in the nation by Engineering News-Record. With 41 years of progressive growth and quality service, we are committed to maintaining a team of creative, ambitious, and visionary individuals. Job Overview:The Senior Administrative Assistant will provide...


  • Sacramento, California, United States WellSpace Health Full time

    Job DescriptionWe are seeking a highly skilled Senior Database Analyst / PowerBI Developer to join our team at WellSpace Health. As a key member of our Informatics/NextGen department, you will play a critical role in supporting the information needs of our organization through the administration and design/development of Power BI dashboards.The ideal...


  • Sacramento, California, United States Madison Square Senior Living Full time

    Job SummaryThe role of Administrative Clerk at Madison Square Senior Living involves providing exceptional support to residents, administrators, and external agencies. This position requires a high degree of organization, attention to detail, and effective communication skills.Key ResponsibilitiesPrimary Point of Contact: Serve as the main point of contact...