Talent.com
Sr. Data Warehouse Administrator
Sr. Data Warehouse AdministratoreStaffLLC • Sacramento, CA, US
Sr. Data Warehouse Administrator

Sr. Data Warehouse Administrator

eStaffLLC • Sacramento, CA, US
30+ days ago
Job type
  • Full-time
Job description

We are seeking a Data Warehouse Administrator for a long-term assignment working

Two days a week in Sacramento, CA, the office is required. Our client will select which days of the week. Must live within 90 miles of Sacramento, CA. Anyone who is not currently near the requirement location will be rejected.

We are seeking a Senior hands-on Data Warehouse Administrator with strong communication skills for a hybrid assignment with our Sacramento, California-based client. This requires a detail-oriented individual with the ability to translate business and functional requirements into technical Data Warehouse specifications as well as independently build and support an Oracle ADW data warehouse environment with minimal supervision.

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 models and / or works with a data modeler to develop a 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

Requirements :

  • Minimum of 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.

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.
Create a job alert for this search

Sr. Data Warehouse Administrator • Sacramento, CA, US

Similar jobs

Warehouse Only Technician

AdaptHealthElk Grove, CA, United States
Full-time

The Warehouse Only Technician will process orders, prepare items for shipment and receive incoming inventory.Also responsible for cleaning and disinfecting returned equipment, cleaning room mainten...Show more

 • Promoted

Administrative Analyst | Pooling | Hybrid in Sacramento, CA

SedgwickSacramento, CA, United States
Full-time

Administrative Analyst | Pooling | Hybrid in Sacramento, CA.By joining Sedgwick, you'll be part of something truly meaningful.It's what our 33,000 colleagues do every day for people around the worl...Show more

 • Promoted

Warehouse/Yard Associate

ICONIX WaterworksSacramento, CA, United States
Full-time

Receives and stocks product in the warehouse.Picks customer orders from inventory stock and completes to meet productivity and accuracy standards.Loads and unloads orders/shipments.Completes all pa...Show more

 • Promoted

Analytics Specialist

Telligen Tech, IncSacramento, CA, United States
Full-time
Quick Apply

Title: Analytics Specialist Location: Sacramento, CA(Hybrid) Duration: Long Term Qualifications Extensive experience in designing, deve...Show more

Database Administrator

TradeJobsWorkForce95832 Sacramento, CA, US
Full-time

Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining th...Show more

 • Promoted

Warehouse Utility

Primo BrandsSacramento, CA, United States
Permanent

Overview:Primo Brands is a leading branded beverage company in North America with a focus on healthy hydration.We are proud to offer an extensive and iconic portfolio of highly recognizable, sustai...Show more

 • Promoted

Survey Taker: Earn up to $25 per survey (Remote)

Earn HausLincoln, CA, US
Remote
Full-time +1

Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.You will help influence brand decisions on se...Show more

 • Promoted

Administrative Assistant Admin - Part Time Panelists Needed - Remote

ApexFocusGroupLincoln, California, US
Remote
Full-time +1

Seeking participants for Focus Group and market research studies.Work part-time from home and earn up to $750 per week.Register to see if you are eligible.Administrative Assistant admin experience ...Show more

 • Promoted

Hospital Administrator

New Talent GroupSacramento, CA, United States
Full-time

This is a full-time, on-site role for a Hospital Administrator at a Veterinary Hospital (Confidential) located in Sacramento, CA.Strategic & Operational Leadership .Serve as the hospital’s operatio...Show more

 • Promoted

Surrogates Start at $75K to $95K+ plus $1,200 Bonus and $11K Pre Pregnancy Payout

Physician's SurrogacyLincoln, CA, US
Full-time +2

Surrogates Start at $75K$95K+ $1,250 Bonus + $11K Pre-Pregnancy Payout.Looking for a high-paying opportunity with real support and no upfront costs?.Become a Surrogate and earn up to.All expenses p...Show more

 • Promoted

Sr. Director Decision Support

Regal Medical GroupSacramento, CA, United States
Full-time

This position will lead in the development of Decision Support reporting solutions at Regal Medical Group in order to support the Executive Management Team’s business objectives.Provides leadership...Show more

 • Promoted

Senior Enterprise Data & AI Architect for Scale

UKG (Ultimate Kronos Group)Sacramento, CA, United States
Full-time

A leading software firm in Sacramento seeks an experienced Enterprise Architect.This pivotal role emphasizes the design and evolution of the enterprise data ecosystem.Responsibilities include leadi...Show more

 • Promoted

Warehouse FT Order Filler-Bulk

S.P. RichardsSacramento, CA, United States
Full-time

To pull items efficiently and accurately according to customer order.Essential Duties and Responsibilities Include The Following.Pull all orders for the customer according to the prescribed picking...Show more

 • Promoted

Remote Capital Markets Analyst - AI Trainer ($50-$60 per hour)

Data AnnotationLincoln, California
Remote
Full-time +1

DataAnnotation is committed to creating high-quality AI.Join our team to help train the next generation of AI while enjoying the flexibility of remote work and the freedom to set your own schedule....Show more

 • Promoted

Warehouse I

American Tire DistributorsSacramento, CA, United States
Full-time

Are you looking for an opportunity to turn your ambition and your people skills into a rewarding career with an industry leader? Join our team at American Tire Distributors! As the nation's premier...Show more

 • Promoted

VP, Real-World Data Strategy & Growth

NorstellaSacramento, CA, United States
Full-time

A leading life sciences data company in the United States seeks a Director/Sr.Director/Vice President - RWD Subject Matter Expert (SME).The role requires a strategic leader to manage key accounts a...Show more

 • Promoted

Data Architect- Healthcare

Diligente TechnologiesSacramento, CA, United States
Full-time

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Diligente Technologies.We are looking for Principal Data Engineers ...Show more

 • Promoted

Surrogates Needed - $60K-$100K+ Compensation and Expert Care

The Genesis GroupPenryn, CA, US
Full-time +1

You have the power to make miracles for our families.If you’ve previously had a healthy pregnancy, you may qualify to help intended parents grow their family via IVF and receive $60,000-$100,000+ i...Show more