Sr SQL & PL/SQL Software Engineer (Hybrid)

  • Full-time

Company Description

The California Independent System Operator (ISO) manages the flow of electricity across the high-voltage, long-distance power lines that make up 80 percent of California's power grid. We safeguard the economy and well-being of 30 million Californians by operating the grid reliably 24/7.

As the impartial grid operator, the California ISO opens access to the wholesale power market that is designed to diversify resources and lower prices. It also grants equal access to 25,865 circuit-miles of power lines and reduces barriers to diverse resources competing to bring power to customers.

The California ISO's function is often compared to that of air traffic controllers. It would be grossly unfair for air traffic controllers to represent one airline and profit from allowing that company's planes to go through before others. In the same way, the California ISO operates independently—managing the electron traffic on a power grid we do not own—making sure electricity is safely delivered to utilities and consumers on time and reliably.

The California ISO is committed to the health, safety, and work/life integration of it employees and is proud to offer flexible work arrangements. This position would be eligible to participate in a hybrid remote schedule (3 days in our beautiful Folsom campus, 2 days working from home). Relocation assistance is available.

Job Description

Under the general direction of a Manager, the Sr Software Engineer is responsible for activities related to design, development, maintenance and enhancements of supported business applications. Assignments typically include applications analysis, design, development, integration, unit testing, and implementation activities in compliance with established department and corporate policies, procedures and methods. Works with vendors and service providers to insure stability and reliability of associated systems.

What's In it for You

Our purpose is to lead the way to tomorrow's energy network. Make a difference and impact millions of people who depend on electricity in their everyday lives.

  • You get to work on interesting and challenging assignments that will help grow your skill set.
  • You will work in an extremely collaborative environment inside our LEED certified Folsom, California campus.
  • You will be challenged, be a part of a winning team, and your contributions will be rewarded and recognized.

What You Will Be Doing

  • Develops and maintains application systems to ensure timely access to accurate, real-time data.
  • Maintains enterprise application programs for internal and external ISO workflow and control functions.
  • Develops and implements unit tests and code review processes related to all supported applications.
  • Creates and maintains documentation and procedures related to the maintenance and operation of application systems.
  • Develops specifications and procures new applications that support ISO internal and external users.
  • Coordinates with various departments to support changes or additions to applications in accordance with ISO Change Management policies and procedures.
  • Interacts with vendor staff in the implementation of new systems and modifications to existing business applications.
  • Analyzes, supports, and resolves real-time computer hardware, software and database issues in a time sensitive environment.

Qualifications

Level of Education and Discipline

  • A Bachelor's degree (BA, BS) or equivalent education, training or experience in Computer Science, Engineering or related field.

Amount of Experience

  • Equivalent years of education and training, plus five (5) or more years related experience.

Type of Experience

  • Experienced in all areas of software engineering including design, development, analysis and data modeling. 
  • Expert level knowledge of SQL, PL/SQL and database performance tuning. 
  • Experience in implementing Java/J2EE Technologies. 
  • Experience with Source Control Systems ( bitbucket/Git), automated tests and continuous integration & Deployment (CI & CD)
  • Experience with Design Patterns.
  • Familiarity with waterfall, agile methodologies. 
  • Development and production implementation experience with spring, Kafka and/or Active MQ highly desired. 

Experience in any of the following development technologies is strongly desired: 

  • RBDMS (Oracle, PostgreSQL)
  • NoSQL (Casandra)
  • Java frameworks (Hibernate, Spring)
  • Web Application Servers (JBoss, Spring Boot)
  • Middleware technologies (MQ, Kafka)
  • SOA (ESB, Web Services) and Application/Web Services Security Design Patterns
  • Testing Tools (SOAP UI)
  • Testing Frameworks (JUnit, jMock, Selenium) 

Additional Information

**We will also consider a Lead Software Engineer level.  This position would require a Bachelor's degree or equivalent as stated above, plus six (6) or more years of related experience.**