Senior Data Warehouse Administrator/Database Administrator
My3Tech Inc
Senior Data Warehouse Administrator/Database Administrator
Position: Senior Data Warehouse Administrator/Database Administrator
Location: Sacramento, CA (Hybrid – onsite work required)
Duration: Long Term
Client: Loblolly/State of CA
Job Description: Requirements:
- Senior hands-on Data Warehouse Administrator with strong communication skills.
- Detail oriented ability to independently build and support an Oracle ADW data warehouse environment at the public cloud with minimal supervision
- Ability to translate business and functional requirements into technical requirements for a Data Warehouse and implement approved design
- Based upon known and future workloads, be able to design VM configuration and resource allocation - inclusive of the CDB and PDB levels.
- Understand and be able to design and implement compartments, tagging, IAM policies for varied user groups and roles accessing the OADW or OCI tenancy.
- Understand and be able to guide best practices around tenancy DRG and LPG design and performance
- Candidate needs to be able to demonstrate, direct hands-on recent practical experience in the areas identified with specific examples.
Key Duties/Responsibilities:
- 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
- As necessary, 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 in collaboration with team specialists
- Experience with OCI Access Management and processes
- Visualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge data
- Hands-on experience 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 in the OADW
- Develops Testing Approach, Plan, Scripts and Documentation of Results
- Participates in Developing and maintaining the data catalog(s) for the enterprise data warehouse
- Participates in Developing and maintaining the data dictionary(ies) 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
Qualifications: Mandatory:
- Certified for "Oracle Autonomous Database Cloud 2021 Certified Specialist" and/or "Oracle Machine Learning using Autonomous Database 2021 Certified Specialist"
- Staff resource must have a 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.
Desired:
- 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.
Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Senior Data Warehouse Administrator/Database Administrator in Sacramento, CA vacancy
- ...Caltrans (Edw) - Bf Sr. Data Warehouse Administrator/Database Administrator Role: CalTrans (EDW) - BF Sr. Data Warehouse Administrator/Database Administrator... ...-90 miles maximum from location. Requirements: Senior hands-on Data Warehouse Administrator with strong...SuggestedWork at office2 days per week
$83.43k - $222.48k
...leading healthcare company in Sacramento is looking for a Senior Mainframe DB2 Database Administrator responsible for optimizing and managing Db2z and IMS... ...in Db2 z/OS administration, SQL performance tuning, and data replication design. This full-time role includes 24/7...SeniorFull time$140k - $165k
Senior Database Administrator - Oracle to MS 13 days ago Requisition ID: 1112 Salary Range: $140,000.00 To $165,000.00 Annually Altech Solutions... ...progress, validating the FDRS schema rebuild, and ensuring zero data loss as cutover approaches. Beyond the migration, this...SeniorHourly payFull timeContract workTemporary work$83.43k - $222.48k
...CVS Health is currently seeking a Senior Mainframe DB2 Database Administrator who will be responsible for designing... ...rotation At least 1 year of data replication design and support skillset... ...REXX scripting experience Tivoli Data Warehouse extract/offload process and...SeniorHourly payFull timeTemporary workLocal area$94.1k - $144.8k
The Database Administrator, Senior leads the design, implementation, and lifecycle management of enterprise database platforms that underpin mission... ...‑availability strategies to ensure resilient, scalable data services across complex application portfolios. It also establishes...SeniorContract workWork experience placementWork at office$99k - $113k
Job Title Senior DBA- Techno Functional Role Job Location Remote [Continental USA]... ...strategic and operational leadership to the Database Administration team at Cognizant. The ideal candidate... ...T‑SQL scripts for administration and data tasks. PowerShell automation for routine...SeniorTemporary workFor contractorsLocal areaRemote work- We're looking for a Senior Database Administrator who can keep our data environment running smoothly and securely. In this role, you will be the subject matter expert of SMUD's database systems, making sure they're fast, reliable, and scalable. You'll design, configure,...SeniorFull timeContract workPart timeWork at officeLocal areaWork from home
$99k - $113k
Cognizant is seeking a Senior DBA Lead to oversee the Database Administration team. This remote position requires strong technical leadership in Microsoft SQL Server, with responsibilities including team management, stakeholder communication, and vendor oversight. Ideal...SeniorRemote job- ...Public Employees Retirement System (CalPERS) for a duration of 12 months. Candidates must have a minimum of 15 years as a Database Administrator with substantial experience in Oracle databases and PeopleSoft. The ideal candidate will demonstrate expert-level DBA skills...Senior
- Position Summary Senior Oracle DBA (W2). Duration 24+ months. Location: Elk Grove, CA. Onsite... ...Responsibilities Work with large Oracle databases. Administer Oracle 11g or higher production environments. Design and implement data extraction using Oracle Golden Gate....SeniorLocal area
- A leading global consulting firm is seeking a Technology Analysis Senior to drive innovation in automated revenue recognition. This role involves engaging with clients, analyzing business processes, and collaborating with technology teams to design effective solutions....Senior
- ...in IT or Engineering and a minimum of five years of experience in electronic data processing systems, with at least three years in a lead capacity. Key responsibilities include administrating Oracle environments and providing effective IT solutions tailored to client needs...SeniorContract work
- ...Grove, California, seeks a Programmer with a Bachelor's Degree in IT or Engineering and at least five years of experience in electronic data processing and programming. The candidate will manage Oracle Golden Gate environments, assist in disaster recovery operations, and...Senior
- Arnex Solutions LLC is looking for a Senior Oracle DBA to work onsite in Elk Grove... ...of experience with large Oracle databases, including administration of Oracle 11g or higher environments. Responsibilities include designing data extraction using Oracle Golden Gate,...Senior
- Devfi is seeking a Senior Oracle Database Administrator in Sacramento, California. The consultant will provide expert support for over 400 databases and... ...in Oracle technologies including Golden Gate and Data Integrator, and solid experience with upgrades and migrations...Senior
- ...seeking an experienced Oracle Golden Gate DBA for a contract role in Elk Grove, CA. The position requires expertise in Oracle database administration, with at least 5 years of relevant experience, including 3 years in a lead capacity. Responsibilities include providing DBA...SeniorContract work
- Sacramento-Municipal-Utility-District is seeking a Senior Database Administrator based in Sacramento, California. In this role, you will ensure that... ...option and is critical to supporting the organization's data infrastructure. #J-18808-Ljbffr Sacramento-Municipal-Utility...Senior
- ...qualified programmer with strong expertise in Oracle Golden Gate and administration of Oracle environments. The candidate must have a Bachelor's... ...field and at least five years of experience in electronic data processing systems, with a minimum of three years in a...Senior
$71.2k - $158.2k
...clinicians, inspire innovation, and save lives. Our mission? To create a human-centric healthcare experience powered by unified global data. It's a big challenge, but big challenges are what we do best. We're already transforming some of the world's largest health...SeniorContract workTemporary workWork experience placementLocal areaVisa sponsorshipFlexible hours$25.48 - $60.63 per hour
...a human-centric healthcare experience powered by unified global data. It's a big challenge, but big challenges are what we do best... ...practice sites and other associated build. Responsibilities As a Senior Consultant, you will consult with clients on service line...SeniorHourly payTemporary workWork experience placementLocal areaFlexible hours- ...AutoZone's Full-Time Senior Retail Sales Associate drives sales through superior customer service by exceeding customer expectations and providing a WOW! Customer Service experience. While assisting customers, the Senior Retail Sales Associate will p Retail Sales Associate...SeniorFull time
$102.5k - $187.9k
...applications and technology required to run their business. As a Senior in Application Design and Development, you will be at the... ...planet, while building trust in capital markets. Enabled by data, AI and advanced technology, EY teams help clients shape the future...SeniorFull timeSummer holidayFlexible hours- A dynamic tech-driven recruitment firm is seeking a Senior Sales Executive to join their remote team. This role involves managing complex sales cycles, prospecting enterprise clients, and achieving sales targets in the staffing industry. The ideal candidate has 3-7 years...SeniorRemote work
$121.5k - $227.2k
Ernst & Young Oman is looking for a Commercialization Architect, Assistant Director, to enhance the firm's product monetization strategies. This role requires clear responsibilities across product pricing, positioning, and profitability analysis. Candidates should have ...Senior$115k
...seeking a Principal Analyst - Senior Pricer. The successful candidate... ...of competitive proposal data gathered from internal and external sources and databases including Gov Win, Dun & Bradstreet... ...Bachelor's Degree in Business Administration/Management, Accounting or...SeniorContract workWork experience placementLocal areaRemote work$168k - $240k
...their desired business outcomes. We accelerate the growth of more impactful work and the evolution of Slalom. The Role: M&A Principal/Senior Principal The Role: M&A Principal/Senior Principal What You’ll Do: Delivery areas include: Executing operational due diligence...SeniorTemporary workWork at officeLocal area- ...Senior Personnel Clerk Location/Site: Human Resources Number of Openings: 1 Position Type: Permanent Employment Type: Full Time Salary: $20.53 - $25.90 per hour / $3,559 - $4,489 per month CSEA Salary Schedule Length of Work Year: Calendar 1 - (12 Months/Year, 260...SeniorHourly payPermanent employmentFull timeWork at officeMonday to Friday
$34.41 - $55.33 per hour
The University of California-Davis Health is seeking a qualified individual for a critical role in its Department of Surgery. This position focuses on support for ongoing research projects in nutrition and metabolism, emphasizing a collaborative approach with various professional...SeniorHourly payFull time$85k - $95k
...Senior Administrative Assistant LHH Recruitment Solutions is assisting a Sacramento, CA non-profit organization with an administrative assistant opportunity. This role supports a service-oriented organization by acting as a primary point of contact for individuals...SeniorWork at officeLocal area$109.2k - $223.4k
...Job Description Overview: Oracle Cloud Infrastructure (OCI) is seeking a Senior Principal Technical Program Manager (IC5) to join our high-impact SWAT team focused on accelerating data center expansion. This role operates at the center of large-scale infrastructure...SeniorTemporary workFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data Warehouse Administrator/Database Administrator. Be the first to apply!
Related searches
- database administrator Sacramento, CA
- senior database administrator Sacramento, CA
- database assistant Sacramento, CA
- remote dba Sacramento, CA
- data administrator Sacramento, CA
- remote database administrator Sacramento, CA
- database manager Sacramento, CA
- logistics operator Sacramento, CA
- receiving clerk full time Sacramento, CA
- 3rd shift grocery stock clerk Sacramento, CA

