Senior Programmer Analyst
Pacific Gas and Electric Company · Oakland, CA · 1 wk ago
Information Technology$118k/yrFull-time
Job Responsibilities
- 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.
- Design and deploy new complex / Enterprise applications and enhancements to existing applications ensuring compatibility and inter-operability.
- Design and deploy new complex / Enterprise applications and enhancements to existing applications ensuring compatibility and inter-operability.
- Design and deploy new complex / Enterprise applications and enhancements to existing applications ensuring compatibility and inter-operability.
- Design and deploy new complex / Enterprise applications and enhancements to existing applications ensuring compatibility and inter-operability.
- Design and deploy new complex / Enterprise applications and enhancements to existing applications ensuring compatibility and inter-operability.
- 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.
Qualifications
- Bachelor's Degree in Computer Science or job-related discipline or equivalent experience.
- 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.
- 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.
- Able to present to an audience.
- Able 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.
- Buys a high-energy and passionate outlook to the role and has strong sense of ownership.