Senior Data Warehouse Administrator/ Database Administrator

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

Scroll down to find an indepth overview of this job, and what is expected of candidates Make an application by clicking on the Apply button.

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

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. Responsibilities include: Performs data warehouse administration for the Enterprise Data...


  • 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 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 eStaffLLC Remote Work Freelance Full time

    We are seeking a Data Warehouse Administrator for a long-term assignment working 100% remotely from anywhere in the US with our Sacramento, California based client.Responsibilities include:Performs data warehouse administration for the Enterprise Data Wareho...


  • 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, United States State of California Full time

    Under the direction of the Information Technology Manager I, the incumbent acts as a .NET administrator overseeing the .NET framework infrastructure to ensure smooth operation of .NET-based applications. The .NET administrator will be responsible for maintaining, optimizing, and troubleshooting .NET servers, as well as supporting development teams in...


  • West Sacramento, California, United States DCI Donor Services Full time

    About the Role:We are seeking a Senior Data Warehouse Designer to join our team at DCI Donor Services. The ideal candidate will have experience in designing, building, and maintaining large-scale data warehouses and data lakes. This role is responsible for ensuring the integrity and accuracy of our data warehouse, which supports business intelligence...


  • Sacramento, California, United States State of California Full time

    About the Position">This position requires experience with Microsoft Windows Server administration and IIS, as well as knowledge of project management practices.Develop and maintain high availability solutions such as database mirroring, AlwaysOn Availability Groups, or clustering.Collaborate with development teams to design efficient database schemas and...


  • Sacramento, California, United States Sacramento Municipal Full time

    Job Summary:The Lead Administrative Coordinator plays a critical role in supporting our senior leaders at Sacramento Municipal Utility District (SMUD). This position requires exceptional administrative expertise, strategic thinking, and excellent communication skills.Main Responsibilities:Provide expert administrative support to executives, encompassing...


  • Sacramento, California, United States State of California Full time

    Key ResponsibilitiesThe successful candidate for this Senior Systems Administrator position will be responsible for managing the state's IT infrastructure, including servers, networks, and databases. They will also provide technical support to staff and ensure the security and integrity of our systems.


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

    Administrative Clerk OpportunityWe are seeking a diligent and detail-oriented Administrative Clerk to join our Madison Square Senior Living team. As an integral member of our administrative team, you will play a vital role in supporting the coordination of resident documentation, licensing needs, and agency communications.The successful candidate will be a...


  • 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 State of California Full time

    The State of California seeks a highly skilled and experienced individual to fill the role of Executive Office Liaison. This is an exciting opportunity for someone who is passionate about providing exceptional support services to senior management teams.About the RoleThis is a Limited Term position that may be extended to 24 months or become permanent,...


  • 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, 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 Mindlance Full time

    We are seeking a skilled and experienced Microsoft SQL Server Database Administrator (DBA) with expertise in SQL Server Reporting Services (SSRS) and Transact-SQL (TSQL). The successful candidate will be responsible for the design, implementation, maintenance, and optimization of our SQL Server databases, ensuring high performance, availability, and...