Senior Oracle Database Analyst

Location: Oakland, California

Requisition ID # 157372-en_US

Save Job I'm Interested

Our IT professionals are at the enterprise's core, leveraging modern technology to deliver safe and reliable energy to our customers. We use AI, the cloud, data science, and the latest tools and programming languages to solve hard, interesting problems and tackle challenges like the ever-growing threat of climate change, wildfires, and breaches of cyber security. Join us and experience the satisfaction of being a technology enabler for a company that leads the industry in innovation.

• Entry, Mid, Senior, Executive

• Full-Time

Success Profile

What makes a successful Team Member at PG&E? Check out the top traits we’re looking for and see if you have the right mix.

• Adaptable

• Collaborative

• Creative

• Curious

• Results-driven

• Thoughtful

Benefits

PG&E is proud to provide a comprehensive benefits program to help you take care of your physical, emotional and financial health. In addition to the offerings below, you can expect inclusive programs in areas such as performance recognition, training and employee development, mentoring and more.

Paid Time Off

Vacation, Sick Hours, Holidays, Family Leave

Employee Resource Groups

16 ERGs at the core of our DEIB culture that support employee development and foster business relationships

Professional Development

Leadership and Employee Development Courses, LinkedIn Learning, Mentoring Program and up to $8,000 for Tuition Reimbursement

Healthcare

Low-Cost Medical, Dental, Life/Accident/Disability Insurance and Free Vision

Healthcare & Dependent Care FSA

Pre-tax employee-funded accounts that cover certain out-of-pocket medical and dependent care expenses

Retirement Plans

401(k) Matching up to 8% AND Cash Balance Pension (no Cost to you)

Job Details

Requisition ID # 157372

Job Category: Information Technology

Job Level: Individual Contributor

Business Unit: Information Technology

Work Type: Hybrid

Job Location: Oakland; Alameda; Alta; American Canyon; Angels Camp; Antioch; Auberry; Auburn; Avenal; Avila Beach; Bakersfield; Balch Camp; Bear Valley; Belden; Bellota; Belmont; Benicia; Berkeley; Brentwood; Brisbane; Buellton; Burney; Buttonwillow; Calistoga; Campbell; Canyon Dam; Canyondam; Capitola; Caruthers; Chico; Clearlake; Clovis; Coalinga; Colusa; Concord; Concord; Corcoran; Cottonwood; Cupertino; Daly City; Danville; Davis; Dinuba; Downieville; Dublin; Emeryville; Eureka; Fairfield; Folsom; Fort Bragg; Fortuna; Fremont; French Camp; Fresno; Fresno; Fulton; Garberville; Geyserville; Gilroy; Goodyear; Grass Valley; Guerneville; Half Moon Bay; Hayward; Hinkley; Hollister; Holt; Huron; Jackson; Kerman; King City; Lakeport; Lemoore; Lincoln; Linden; Livermore; Lodi; Loomis; Los Banos; Lower Lake; Madera; Magalia; Manteca; Manton; Mariposa; Martell; Marysville; Maxwell; Menlo Park; Merced; Meridian; Millbrae; Milpitas; Modesto; Monterey; Montgomery Creek; Morgan Hill; Morro Bay; Moss Landing; Mountain View; Napa; Needles; Newark; Newman; Novato; Oakdale; Oakhurst; Oakley; Olema; Orinda; Orland; Oroville; Palo Alto; Palo Cedro; Paradise; Parkwood; Paso Robles; Petaluma; Pioneer; Pismo Beach; Pittsburg; Placerville; Pleasant Hill; Point Arena; Potter Valley; Quincy; Rancho Cordova; Red Bluff; Redding; Richmond; Ridgecrest; Rio Vista; Rocklin; Roseville; Round Mountain; Sacramento; Salida; Salinas; San Bruno; San Carlos; San Francisco; San Francisco; San Jose; San Luis Obispo; San Mateo; San Rafael; San Ramon; San Ramon; Sanger; Santa Cruz; Santa Maria; Santa Nella; Santa Rosa; Selma; Shaver Lake; Sonoma; Sonora; South San Francisco; Springville; Stockton; Storrie; Taft; Tracy; Turlock; Twain; Ukiah; Vacaville; Vallejo; Walnut Creek; Wasco; Watsonville; West Sacramento; Wheatland; Whitmore; Willits; Willow Creek; Willows; Windsor; Winters; Woodland; Yuba City

Department Overview

Information Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions.

Position Summary

This position is with the Database Solutions and Deployment team. The Oracle DBA will be part of the project team responsible for solutioning and building out databases. This position requires occasional weekend and after-hours support, and the DBA must carry a cell phone.

This position is hybrid, working from your remote office and the Oakland General Office twice monthly or based on business need. The assigned work location will be within the PG&E Service Territory and will be agreed upon by the successful candidate and hiring leader.

PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. Although we estimate the successful candidate hired into this role will be placed between the entry point and the middle of the range, the decision will be made on a case-by-case basis related to these factors.​ This job is also eligible to participate in PG&E’s discretionary incentive compensation programs.

A reasonable salary range is:​

Bay Area Minimum: $118,000

Bay Area Maximum: $188,000

California Minimum:$112,000

California Maximum:$179,000

Job Responsibilities

• Install, upgrade, patch, backup, and recover assigned Oracle databases as specified by project requirements.

• Setup monitoring and ensure databases adhere to build standards.

• Refresh or migrate data.

• Create database objects.

• Enforce company change control, patch management, and information security standards and procedures.

• Collaborate and consult with DBA teammates on project tasks.

• Provide off-hour and weekend support as needed for the projects.

• Demonstrate consistent and independent ability to manage projects and the workload.

• Manage work according to criteria of costs, scheduling, and functional and technical performance.

• Maintain open and honest communications with clients, teammates and management for purposes of providing ongoing, timely status reporting.

• Communicate status, issues and concerns in both written and oral formats.

• Provide proper documentation for knowledge sharing and transition.

Qualifications

Minimum:

• Bachelors Degree in Computer Science or job-related discipline or equivalent experience

• Experience in database technology, job-related, 5 years

Desired:

• Good oral and written communication skills.

• Good workload and time management skills.

• Ability to maintain reliability of the database systems.

• Ability to adhere to company policies and compliance standards.

• Experience with Oracle 11G, 12C, 18C, and 19C databases.

• Proficient with OEM, RMAN, ASM, RAC, Golden Gate, OUD, Data Guard Broker, and Data Guard Observer.

• Experience with multi-terabyte databases and/or database warehouses.

• Experience with RAC, ASM and SQL performance tuning.

• Experience with relational database design.

• Experience with of Database and Grid Infrastructure binaries cloning.

• Experience with DDBoost.

• Experience with Perl, Unix, Linux shell scripting.