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 investigation of performance and 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, operations teams and IT leadership to provide the best in application implementations, environments, and hardware solutions.
Duties will include :
- Developing complex SQL.
- Creating database objects (e.g., tables, indexes, stored procedures, etc.) from a developer’s perspective.
- Working with the Automic (UC4) team to develop batch jobs.
- Running batch jobs to assess performance.
- Developing and supporting tools in support of MTC applications.
- Support CC&B CMA (Soft Table) migration automation tool.
PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation 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, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. Although we estimate the successful candidate hired into this role will be placed between the entry point and the middle of the range, 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.
A reasonable salary range is :
Bay Area Minimum : $114,000
Bay Area Maximum : $182,000
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 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 :
BA / BS in Computer Science, Management Information Systems, or equivalent experience5+ years of application development and analysis experienceDesired :
Knowledge of Oracle CC&B and / or Billing Cloud Service (BCS)Knowledge of UC4 (Automic)Advanced understanding of software and application architecture, how it works, and how it often breaksOracle Complex SQL developmentOracle SQL performance tuningOracle Database / table / index designProficient in Oracle Enterprise ManagerAbility to create the most complex test beds, create test scenarios, create regression tests, document and assess software reliabilityApplication operations experience.Skilled in Microsoft Office 365 (Excel, Word, Outlook, Teams)Proficient in Unix / Linux shell scriptingExcellent analytical and creative problem-solving abilities.Proven track record of successfully performing complex application developmentProven knowledge with programming principles to enhance system performanceAble to prioritize and execute tasks in a very complex, high-pressure environmentAbility to conduct research into application issues and products as requiredOversee, 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.Proficient knowledge of Linux / AIXExperience in IBM hardware and storageKnowledge of Oracle Golden Gate productExperienced in Java / Groovy programmingAbility to present to an audienceAbility to speak up and challenge technical solutions when appropriateLeadership skills - Ability to lead and work with business, technical and leadership people in various organizationsSolution design experienceExperience in overseeing the design, development, and implementation of complex and 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.