Senior Programmer Analyst - Performance

Pacific Gas And Electric Company•Oakland, CA

2d•$118,000 - $188,000•Hybrid

About The Position

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. 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). Duties will include performance test planning and coordination, and investigation of operational issues in a collaborative environment with cross functional teams and communicating status to peer level organizations. The individual will work on performance testing and Operational Readiness Testing. In addition, the individual may develop and support tools in support of 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.

Requirements

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

Nice To Haves

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

Responsibilities

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.
Analyze and develop requirements for UC4 (Automic) batch processing jobs and workflows. Work with the UC4 team to develop batch jobs.
Develop and tune complex Oracle SQL queries.
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.
Develop and support tools for the MTC applications.
Design database objects (e.g., tables, indexes, stored procedures, etc.) from a developer’s perspective.
Support CC&B / BCS Content Migration Assistant (Soft Table and Account Mover) migration automation tool.
Resolve application programming analysis problems of broad scope within procedural guidelines.
Oversee the operations of the enterprise application.
Capacity planning for application growth.
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 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.