Programmer Analyst, Senior - CC&B

Requisition ID # 167342 

Job Category: Information Technology 

Job Level: Individual Contributor

Business Unit: Information Technology

Work Type: Hybrid

Job Location: Oakland

 

 

Department Overview

The Information Technology (IT) organization designs, develops, operates, and maintains the technology and telecommunications systems that enable PG&E to meet its commitment to providing safe, reliable, and affordable service to customers.

 

The Customer Information Systems (CIS) Solutions team is responsible for all aspects of Meter To Cash (MTC) application operations and projects including architecture design, research, and analysis. 

 

Position Summary

PG&E is seeking a highly motivated and knowledgeable individual to provide senior level support for the mission critical CC&B and BCS applications.  Duties will include managing and maintaining application performance, monitoring and addressing application issues in a collaborative environment with cross functional teams and communicating status to peer level organizations.  The individual will work on Performance Testing, Operational Readiness Testing, and SQL performance tuning.  In addition, the individual will participate in working with technical and business Architects, Infrastructure / Operations teams and IT leadership to provide the best in application implementations, environments, and hardware solutions.

 

The major responsibilities are the following:

• Performance analysis and testing of the CC&B and BCS applications.
• Running batch jobs to assess performance.
• Developing complex SQL.
• Oracle SQL tuning.
• Designing database objects (e.g., tables, indexes, stored procedures, etc.) from a developer’s perspective.
• Developing and supporting tools in support of MTC applications.
• Support CC&B / BCS CMA (Soft Table) migration automation tool.
• Working with the Automic (UC4) team to develop batch jobs.
• Act as Subject Matter Expert for development and operations teams for supported applications.

 

PG&E is providing the salary range that can reasonably be expected for this position at the time of the job posting. This salary 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, internal equity, specific skills, education, licenses or certifications, experience, market value, and geographic location. 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.  

 

Pay range display:​ $114,000 - $162,800

 

This position is hybrid, working from your remote office and Oakland General Office on business need.

 

Job Responsibilities

• Troubleshoot performance issues in the application and database and find solutions to performance problems.
• Resolves application programming analysis problems of broad scope within procedural guidelines.
• Development and analysis of Automic (UC4) batch processing jobs and workflows.
• Oversee the creation of the in-depth performance tests of both batch and online, including end-user reviews for existing and new applications.
• Oversee the operations of the enterprise application.
• Capacity planning for application growth.
• Run and monitor batch jobs in support of performance testing and Operational Readiness Testing.
• Mentor and collaborate with teams to ensure smooth and reliable operation of applications for fulfilling business objectives and processes.
• Design and deploy new complex / Enterprise applications and enhancements to existing applications ensuring compatibility and inter-operability.
• Conduct research on products and solutions to justify recommendations and to support purchasing efforts.
• Integrate multiple applications with enterprise systems.
• Define requirements for and review documentation for quality.
• Gauge the effectiveness and efficiency of existing applications; develop and implement strategies for improving or further leveraging these applications.
• Work with leader