PG&E's Information Technology (IT) organization needs to ensure the reliable and efficient operation of its Meter To Cash (MTC) applications, specifically CC&B and BCS, by providing senior-level support for performance analysis, issue resolution, and application implementations.
Requirements
- Oracle Complex SQL development
- Oracle SQL performance tuning
- Oracle Database/table/index design
- Proficient in Oracle Enterprise Manager
- Ability to create the most complex test beds, create test scenarios, create regression tests, document and assess software reliability
- Application operations experience.
- Proficient in Unix / Linux shell scripting
Responsibilities
- 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.
Other
- This position is hybrid, working from your remote office and Oakland General Office on business need.
- BA/BS in Computer Science, Management Information Systems, or equivalent experience
- 5+ years of application development and analysis experience
- Excellent analytical and creative problem-solving abilities.
- Able to prioritize and execute tasks in a very complex, high-pressure environment