Postgres Expert Database Administrator

$120,000 - $200,000/Yr

PG&E - Oakland, CA

Full-time - Senior

Hybrid - Oakland, CA

Utilities

About the position

The Postgres Expert Database Administrator at PG&E Corporation is responsible for overseeing the roadmaps, configuration standards, and guidelines for Postgres databases. This role involves engaging in various database deliverables, including physical database design, capacity planning, quality assurance standards, backup and recovery designs, disaster recovery plans, and security implementation. The DBA will manage, maintain, upgrade, and migrate both production and non-production databases, working in a hybrid environment between remote and the Oakland General Office based on business needs.

Responsibilities

• Collaborates with Project Manager on complex project timelines, identifying critical path, resource estimates, risks, and dependencies.
• Exercises independent judgment and discretion in matters of significance with broad scope and high complexity.
• Lead and collaborates on Postgres database standards and technologies.
• Frequently demonstrates advanced knowledge of emerging software/add-ons related to Postgres.
• Mentor fellow DBAs and management.
• Lead Postgres database architectural designs.
• Present in Technology Forums and openly discuss experience.
• Resolve high complexity database problems of broad scope within procedural guidelines.
• Understand business requirements and apply them to complex database design and development.
• Documentation.

Requirements

• Bachelor's degree in computer science or job-related discipline or equivalent experience.
• 8 years' experience in database technology, job-related.
• 7 years of Postgres experience.

Nice-to-haves

• Strong experience with Postgres database administration tasks.
• Strong experience with Postgres database performance factors, monitoring, and tuning.
• Strong knowledge and experience of Postgres High Availability and Disaster Recovery solutions.
• Strong scripting experience.
• Expertise with Postgres.
• Expertise with Linux.
• Experience with Oracle.
• Experience with MS SQL Server.
• Experience with Kubernetes.

Benefits

• Discretionary incentive compensation programs.