About this role
<p>Requisition ID # 171953 </p> <p><p>Job Category: Information Technology </p> <p>Job Level: Individual Contributor</p> <p>Business Unit: Information Technology</p> <p>Work Type: Hybrid</p> <p>Job Location: Oakland</p> <p> <p> <p> <p><p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong>Department Overview</strong></span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Information Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions.</span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong><br>Position Summary</strong></span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Designs, develops, configures, and supports cloud-native applications, data integration solutions, and data platform services utilizing AWS and Snowflake technologies. Responsible for building and operating scalable cloud infrastructure, data pipelines, database replication solutions, and enterprise data platforms that support critical business operations. Partners with business stakeholders, architects, and product teams to design secure, reliable, and cost-effective solutions that enable data-driven decision making across the organization.</span><br><br></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Develops Infrastructure as Code (IaC), automates deployment processes, manages cloud-native services, and ensures operational excellence through monitoring, observability, security, and governance best practices.</span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif">PG&E is providing the full salary/pay range for this position. The actual amount paid to an individual will be based on multiple factors, including, but not limited to, internal equity,<strong> </strong>specific skills, education, licenses or certifications, experience, market value, and geographic location. <strong>The range to reasonably expect will be around the minimum and the midpoint $128,000 - $173,000. The final decision will be made on a case-by-case basis related to the factors above. </strong>This job is also eligible to participate in PG&E’s discretionary incentive compensation programs. </span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Bay Area Min: $ 128,000</span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Bay Area Max: $ 218,000</span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><br><span style="font-family:arial, helvetica, sans-serif">This position is hybrid, working from your remote office at our Oakland Headquarters based on business need. The assigned work location will be within the PG&E Service Territory.</span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong>Job Responsibilities</strong></span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong>Cloud Platform Engineering</strong></span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Design, develop, and operate AWS-based solutions using services including API Gateway, Lambda, EC2, S3, IAM, CloudWatch, and Database Migration Service (DMS).</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Implement Infrastructure as Code using Terraform and enterprise-approved modules and patterns.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Design and maintain CI/CD pipelines supporting application, infrastructure, and database deployments.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Implement monitoring, logging, alerting, and operational dashboards using CloudWatch and enterprise observability tools.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Ensure cloud solutions align with enterprise security, governance, networking, and compliance requirements.</span></li> </ul> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong><br>Data Engineering & Snowflake</strong></span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Design and support scalable data ingestion, replication, and transformation pipelines supporting enterprise analytics and operational reporting.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Develop and maintain integrations between operational systems, cloud platforms, and Snowflake data environments.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Build and optimize Snowflake database objects including schemas, tables, views, tasks, streams, and stored procedures.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Support data quality, data validation, metadata management, and governance practices within the Snowflake platform.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Tune and optimize Snowflake workloads for performance, scalability, and cost efficiency.</span></li> </ul> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong><br>Database & Replication Engineering</strong></span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Administer Microsoft SQL Server databases hosted on AWS EC2 environments.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Configure and manage high availability, backup/recovery, patching, monitoring, and performance tuning activities.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Design, implement, and support AWS DMS replication processes including Change Data Capture (CDC), latency monitoring, and reconciliation.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Analyze and troubleshoot database, replication, and application performance issues.</span></li> </ul> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong><br>Operational Excellence</strong></span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Provide production support, incident response, root cause analysis, and continuous service improvements.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Collaborate with architects, business stakeholders, and development teams to translate business requirements into technical solutions.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Apply cloud cost optimization practices including resource tagging, utilization analysis, right-sizing, and FinOps principles.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Participate in architecture reviews, operational readiness assessments, and modernization initiatives.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Resolve application, infrastructure, and data platform issues of complex scope through cross-functional collaboration.</span></li> </ul> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong>Qualifications</strong></span></p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong>Minimum Qualifications</strong></span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Bachelor's Degree in Computer Science, Information Systems, Engineering, or equivalent experience.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">7 years of experience in programming analysis, software engineering, cloud engineering, or data platform development.</span></li> </ul> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;line-height:normal;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif"><strong>Desired Qualifications</strong></span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience in the utility or energy sector with understanding of grid operations, outage workflows and customer service processes.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">3+ years of hands-on experience deploying and operating production workloads on AWS.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience with AWS services including API Gateway, Lambda, EC2, S3, IAM, and CloudWatch.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience implementing Infrastructure as Code using Terraform.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Hands-on Microsoft SQL Server administration experience.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience building and supporting Git-based CI/CD pipelines.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Strong SQL development and database design experience.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Working knowledge of cloud security, IAM, networking, and monitoring concepts</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience with AWS DMS and CDC-based replication architectures.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience supporting enterprise-scale AWS environments using centralized governance and shared services models.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience with Windows Server administration on AWS, including Systems Manager (SSM) and Patch Manager.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Knowledge of enterprise networking concepts including VPCs, Transit Gateway, Direct Connect, VPC Endpoints, and hybrid cloud architectures.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience implementing monitoring and observability solutions using CloudWatch dashboards, alarms, tracing, and operational analytics.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Understanding of SQL Server high-availability architectures, replication technologies, and disaster recovery solutions.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience designing and supporting Snowflake data warehouse and data engineering solutions.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience with Snowflake Streams, Tasks, Snowpipe, performance tuning, and data governance capabilities.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience with cost optimization and FinOps practices in cloud environments.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Experience supporting utility, energy, or other critical infrastructure systems.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">AWS certifications (Solutions Architect, Developer, Database Specialty, SysOps)</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">FinOps Certified Practitioner preferred.</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in;font-size:12.0pt;font-family:arial, helvetica, sans-serif"><span style="font-family:arial, helvetica, sans-serif">Snowflake SnowPro certification preferred.</span></li> </ul>