Senior Systems Analyst (67.26)

International Executive Service Corps; Rancho Cordova (CA); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical benefits

Paid time off

Company holidays

Retirement plan

Life insurance

Health savings account

Job summary

Golden State Water Company is seeking an experienced Senior Systems Analyst to provide 24x7 support for the Oracle CC&B system and its related components, including Oracle BI Publisher, Exstream, and cloud integrations. The role requires hands-on onsite work and senior-level expertise across applications, middleware, and databases.

The ideal candidate will document requirements, design solutions, configure applications, diagnose production issues, and coordinate with Oracle support.

Qualifications

• BS in Computer Science (or related discipline) or equivalent work experience.
• Seven (7) or more years’ significant systems analysis experience required.
• Proficient in troubleshooting application, middleware and database issues.
• Must have experience in Business Application, Production Control disciplines, and Change Management.
• Outstanding written, verbal communication, and interpersonal skills.
• Energetic and self-motivated team player with ability to work effectively and cooperatively with project and infrastructure teams.
• Specific required skills include: Oracle Database Administration, SQL, PL/SQL, and either SQL Developer or Toad; Understanding of network technologies/concepts; Linux OS Administration and commands.

Responsibilities

• Executes system analysis for small-to-medium sized projects independently, and provides significant contributions to large/complex projects with assistance from team members.
• Documents requirements, solution design, diagrams business processes and system workflows.
• Performs application setups and configurations.
• Performs rapid and accurate analysis and effective diagnosis of production issues.
• Provides direct end-user support for any issues or questions related to the applications.
• Acts as needed as the primary point of contact with Oracle support services.
• Analyzes base code problems, refers to Oracle, and tracks to closure.
• Supports customizations (i.e. configuration, interfaces, modifications, and reports).
• Lends expertise with system and component upgrades.
• Recommends and may assist in the testing of patches and upgrades.
• Recommends, designs, and deploys best practices for new technologies and implementations as well as knowledge transfer and mentoring to other team members.
• Participates in Disaster Recovery planning and testing.
• Provides after hours on-call support.
• Other related duties as necessary to support Company goals and objectives.

Skills

Oracle Database Administration

SQL

PL/SQL

Linux OS Administration

Networking basics

Java

Python

Oracle WebLogic

BI Publisher

OpenText Exstream

Eclipse

SQL Developer

Toad

Education

BS in Computer Science

Tools

SQL Developer

Toad

Oracle BI Publisher

Oracle Business Intelligence Publisher

Job description

Golden State Water Company is one of the largest investor-owned water utilities in the United States. We deliver quality, reliable water to more than 1 million people in over 80 communities throughout California. Golden State Water has been in business for more than 90 years because we put customers first.

POSITION DEFINITION

The individual in this position reports to the Information Technology Supervisor with the responsibility of providing 24 x 7 support for the Oracle Customer Care and Billing (CC&B) system, it’s associated application components (e.g. Oracle Business Intelligence Publisher, Automic Automation Manager, OpenText Exstream, etc.), and integrations with external cloud-based applications such as Oracle Mobile Workforce Management (MWM) system and Customer Web Self-Service (CSS) solutions. The incumbent works as part of a “hands-on” onsite support team and as a senior systems analyst with extensive experience in all aspects of information technology.

Summary of Key Responsibilities

• Executes system analysis for small-to-medium sized projects independently, and provides significant contributions to large/complex projects with assistance from team members.
• Documents requirements, solution design, diagrams business processes and system workflows.
• Performs application setups and configurations.
• Performs rapid and accurate analysis and effective diagnosis of production issues.
• Provides direct end-user support for any issues or questions related to the applications.
• Acts as needed as the primary point of contact with Oracle support services.
• Analyzes base code problems, refers to Oracle, and tracks to closure.
• Supports customizations (i.e. configuration, interfaces, modifications, and reports).
• Lends expertise with system and component upgrades.
• Recommends and may assist in the testing of patches and upgrades.
• Recommends, designs, and deploys best practices for new technologies and implementations as well as knowledge transfer and mentoring to other team members.
• Participates in Disaster Recovery planning and testing.
• Provides after hours on-call support.
• Other related duties as necessary to support Company goals and objectives.

Education, Experience, Knowledge and Skill Requirements

• BS in Computer Science (or related discipline) or equivalent work experience.
• Seven (7) or more years’ significant systems analysis experience required.
• Proficient in troubleshooting application, middleware and database issues.
• Must have experience in Business Application, Production Control disciplines, and Change Management.
• Outstanding written, verbal communication, and interpersonal skills.
• Energetic and self-motivated team player with ability to work effectively and cooperatively with project and infrastructure teams.
• Specific required skills include:
  • Oracle Database Administration
  • SQL, PL/SQL, and either SQL Developer or Toad
  • Understanding of network technologies/concepts
  • Linux OS Administration and commands

Highly Desirable Skills

• Three (3) or more years’ experience configuring, coding, and troubleshooting Oracle’s Customer Care and Billing software.
• Knowledge of CC&B in the following areas:
  • Administration and Configuration
  • Framework Business Processes
  • Framework Administration including ConfigTools
  • Development and Customizations
• Oracle Weblogic Server and Enterprise Manager
• Oracle Utilities SDK and Eclipse
• Oracle SOA Suite and Oracle Integration solutions
• Java
• Python
• OpenText Exstream
• Automic Applications Manager
• Ability to script in Linux
• Experience with BI Publisher or other reporting tools
• Working knowledge of various computer hardware platforms such as Linux and Windows
• Ability to develop project plans, track resources, dependencies, budget and due dates for successful project implementations
• Experience working in the Utilities industry

Qualities of a Successful Professional in This Position

• Flexible, thoughtful, accountable, approachable and passionate about work.
• Collaborative business partner who can show business results.
• Passion for customer service support with a sense of urgency and a ‘can-do’ attitude.
• Trustworthy; strong personal integrity; emotional maturity.
• Demonstrates strong level of accountability and ownership.Executes with discipline and urgency.
• Collaborative/team oriented.
• Exhibits professionalism with internal and external contacts.
• Organized with strong attention to detail and time management.
• High degree of initiative; self-starter.

May include but not limited to standing, climbing, walking, lifting, bending, pulling and/or pushing, grasping, reaching, stooping and crouching, sitting, typing, walking, reading, writing, color determination, speaking and listening for extended periods of time.

Benefits

Our Company supports our employees with rich benefit programs and resources to help them thrive today and prepare for tomorrow. Benefit options include medical, dental, and vision plans with the Company currently paying 85% of the monthly premium for employees and their eligible dependents. We also offer paid vacation and sick time and twelve Company paid holidays per year. To help our employees plan for the future, we offer both a 401(k) retirement plan as well as a Defined Contribution Profit Sharing retirement plan. Additional benefits include life, AD&D, and LTD insurance as well as health savings account and flexible spending plans.

Compensation Information

The compensation range provided is in compliance with state specific laws. Multiple factors are used to determine the actual starting rate of pay for all of our positions, including specific skills, years of experience, education, certification(s), and other job related factors.

The responsibilities of this position will involve access to information that may be considered confidential, private and sensitive. Therefore, the individual filling this position will be required to both allow and pass a background check.

NOTE: Reasonable accommodations will be made to enable individuals with special needs to perform the essential functions.

The Company is committed to providing equal employment opportunities for all job applicants and employees. The Company prohibits unlawful discrimination on the basis of race, religion, color, national origin, ancestry, physical disability, mental disability, legally protected medical condition, marital status, sex, gender, gender identity or expression, sexual orientation, age over 40, military or veteran status or any other basis protected by federal, state or local law.