Senior Programmer Analyst

Requisition ID # 172594


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 Customer Applications (CC&B and BCS). The individual will analyze, design, develop, modify, configure, debug and evaluate programs for technical and functional business areas. Analyzes existing applications and systems and formulates logic for new systems, develops stored procedures, logical database design, performs coding and tests/debugs programs. In addition, the individual supports existing tools for the MTC applications. The individual will participate in working with technical Architects, Developers, Infrastructure / Operations teams and IT leadership to provide the best in application implementations and environments.

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

Job Responsibilities

The major responsibilities are the following:

• Develop and support tools for the MTC applications.
• Analyze, design, develop, modify, configure, debug and evaluate programs for technical and functional business areas. Analyzes existing applications and systems and formulates logic for new systems, develops stored procedures, logical database design, performs coding and tests/debugs programs.
• Support CC&B / BCS Content Migration Assistant (Soft Table and Account Mover) migration automation tools.
• Develop and tune complex Oracle SQL queries.
• Design database objects (e.g., tables, indexes, stored procedures, etc.) from a developer's perspective.
• Resolve application programming analysis problems of broad scope within procedural guidelines.
• Gauge the effectiveness and efficiency of existing applications; develop and implement strategies for improving or further leveraging these applications.
• Design and deploy new complex / Enterprise applications and enhancements to existing applications ensuring compatibility and inter-operability.
• Analyze and develop UC4 (Automic) batch processing jobs and workflows. Work with the UC4 team to develop batch jobs.
• Act as Subject Matter Expert for development and operations teams for supported applications.
• Mentor and collaborate with teams to ensure smooth and reliable operation of applications for fulfilling business objectives and processes.

Other responsibilities may include the following:

• Performance planning, coordination, analysis and testing of the CC&B and BCS applications.
• Run, monitor, and assess performance of batch jobs and online in support of performance testing and Operational Readiness Testing.
• Troubleshoot performance issues in the application and database and find solutions to performance problems.
• Oversee the creation of the in-depth performance tests of both batch and online, including end-user reviews for existing and new applications.
• Provide pre-concept estimates for Projects in the area of performance and/or operations.
• Oversee the operations of the enterprise application.
• Capacity planning for application growth.
• 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.
• Work with leadership, decision makers, and stakeholders to define business requirements and application goals, and to identify and resolve business application issues.
• Perform cost-benefit and return on investment analyses for proposed applications to aid management in making implementation decisions.
• Design and perform application security audits, backup procedures, and other recovery processes in accordance with the company's disaster recovery and business continuity strategies.

Qualifications

Minimum:

• Bachelors Degree in Computer Science or job-related discipline or equivalent experience
• Experience in programming analysis, 5 years

Desired:

• 10+ years of application development and analysis experience
• Advanced understanding of software and application architecture, how it works, and how it often breaks
• Oracle Complex SQL development
• Oracle SQL performance tuning
• Oracle Database/table/index design
• Ability to create the most complex test beds, create test scenarios, create regression tests, document and assess software reliability
• Application operations experience.
• Skilled in Microsoft Office 365 (Excel, Word, Outlook, Teams)
• Proficient in Unix / Linux shell scripting
• Excellent analytical and creative problem-solving abilities
• Proven track record of successful participation in complex application development
• Proven knowledge with programming principles to enhance system performance
• Able to prioritize and execute tasks in a very complex, high-pressure environment
• Ability to conduct research into application issues and products as required
• Oversee, mentor, and provide guidance to less experienced resources.
• Ability to work in a team-oriented, collaborative environment with multiple stakeholders
• Able to build trust and rapport that creates a comfortable & effective workplace
• Knowledge of Oracle CC&B and/or Billing Cloud Service (BCS)
• Knowledge of UC4 (Automic)
• Proficient knowledge of Linux/AIX
• Experience in IBM hardware and storage
• Proficient in Oracle Enterprise Manager
• Understanding of Oracle Golden Gate product
• Experienced in Java/Groovy programming
• Ability to present to an audience
• Ability to speak up and challenge technical solutions when appropriate
• Leadership skills - Ability to lead and work with business, technical and leadership people in various organizations
• Solution design experience
• Experience in overseeing the design, development, and implementation of complex Enterprise applications and associated integrations.
• Experience with application planning, security principles, and general software management best practices.
• Experience with core software applications.
• Advanced software troubleshooting experience.
• Excellent written, oral, and interpersonal communication skills.
• Ability to communicate ideas in both technical and user-friendly language.
• Extremely self-motivated and directed, with keen attention to detail.
• Strong customer service orientation.
• Brings a high-energy and passionate outlook to the role and has strong sense of ownership.

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,specific skills, education, licenses or certifications, experience, market value, and geographic location. The range to reasonably expect will be between the minimum and midpoint listed below. The final decision will be made on a case-by-case basis related to the factors above. This job is also eligible to participate in PG&E's discretionary incentive compensation programs.


Bay Area Min: $118,000.00

Bay Area Mid: $153,000.00

Bay Area Max: $188,000.00

Purpose, Virtues and Stands

Our Purpose explains "why" we exist:

• Delivering for our hometowns
• Serving our planet
• Leading with love

Our Virtues capture "who" we need to be:

• Trustworthy
• Empathetic
• Curious
• Tenacious
• Nimble
• Owners

Our Stands are "what" we will achieve together:

• Everyone and everything is always safe
• Catastrophic wildfires shall stop
• It is enjoyable to work with and for PG&E
• Clean and resilient energy for all
• Our work shall create prosperity for all customers and investors

More About Our Company

EEO
Pacific Gas and Electric Company is an Equal Employment Opportunity employer that actively pursues and hires a workforce that reflects the hometowns we serve. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, sex, age, religion, physical or mental disability status, medical condition, protected veteran status, marital status, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information or any other factor that is not related to the job.

Employee Privacy Notice The California Consumer Privacy Act (CCPA) goes into effect on January 1, 2020. CCPA grants new and far-reaching privacy rights to all California residents. The law also entitles job applicants, employees and non-employee workers to be notified of what personal information PG&E collects and for what purpose. The Employee Privacy Notice can be accessed through the following link: Employee Privacy Notice

PG&E will consider qualified applicants with arrest and conviction records for employment in a manner consistent with all state and local laws.