Search Jobs

Final Filing Date:  First review of applications will be on June 7, 2024. NCPA reserves the right to close this posting once a sufficient number of applications have been received.
 

Under the direction of the IS Operations & Support Assistant Manager, the Database Administrator architects, tests, implements, maintains, and documents Agency databases. The database administrator collaborates closely with IS development and Agency operations personnel to provide backend database solutions for custom applications, including real-time, scheduling, and settlement programs. The database administrator troubleshoots and provides solutions for database problems.

Level III
This classification supports and maintains the Agency’s database infrastructure and related applications. Administers all database objects, including but not limited to schemas, tables, clusters, indexes, and views. Performs database re-organizations as needed to improve performance. Performs impact analysis of changes to be made to database objects before implementing significant schema changes. Ensures security for all databases by creating roles and associated privileges. Controls and monitors user access to databases. This is a journey-level position and is given minimal direction in job duties and responsibilities.  

Level IV
Architects and designs the Agency’s database infrastructure and ensures the highest levels of availability. Leads database projects to establish new database architectures. Oversees upgrades and implementations of new databases or related software.   Position can perform all lower level requirements and works independently with very little direction May be called upon to provide reports or present to the Agency’s Information Technology Committee. May direct the work of lower classifications.     

ESSENTIAL DUTIES AND RESPONSIBILITIES
This position requires that the incumbent reports for work on time and maintains satisfactory attendance in accordance with Agency policy; Ensures work responsibilities are covered when absent; Arrives to meetings and appointments on time; Performs special assignments for the Assistant Manager, Information Services or others as assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Responsibilities:
Design, create and maintain all Oracle databases required for development, testing, and production usage. 

Install, configure, upgrade, and troubleshoot Database server software for both stand-alone instances and Real Application Clusters (RAC). Includes patching both Oracle and Windows. 

Administer all database objects, including schemas, tables, clusters, indexes, views, sequences, constraints, packages, and procedures. This includes creating primary database storage structures (tablespaces) and primary objects (tables, views, indexes). Manage the sharing of resources between applications. 

Troubleshoot problems regarding the databases, servers, applications and development tools. Open technical support cases with support as needed and serve as primary support contact for NCPA. 

Perform capacity planning for all databases. Work closely with IS storage and system administration staff to plan and allocate database system storage. 

Experienced with creating, managing, and maintaining data warehouse technologies.

Perform ongoing monitoring and tuning of all database instances and Windows servers to optimize database performance and reliability. 

Plan and implement backup and recovery of Agency databases. Maintain remote standby databases using archive logs.

Implement and enforce security for all of the Databases through creating and maintaining users and roles, and assigning privileges. Control and monitor user access to the database. 

Perform database re-organizations as required to improve performance and ensure maximum uptime of the database. Modify the database structure from information given by application developers. Gather statistics, create indexes, create or expand tablespaces as needed. 

Perform SQL and PL/SQL tuning and performance monitoring. 

Set up and maintain documentation and standards for database practices and procedures. 

Provide technical support to application developers and database users. 

Perform impact analysis of changes to be made to database objects. Approve and implement/oversee significant schema changes and changes to database design. 

Provide support during non-standard hours (on an as-needed basis, on-call 24x7x365). 

Provide a strategic database direction for the organization.

MINIMUM QUALIFICATIONS

Level III:
Education and/or Experience
A bachelor’s degree from an accredited four-year college or university in Computer Science, Management Information Systems, Engineering, or a related field and five or more years of related experience and/or training, or an equivalent combination of education and experience.

Level IV: 
Education and/or Experience 
A bachelor’s degree from an accredited four-year college or university in Computer Science, Management Information Systems, Engineering, or a related field and eight or more years of related experience and/or training, or an equivalent combination of education and experience.

KNOWLEDGE AND ABILITIES 

Knowledge:
Knowledge of Oracle database; Oracle Recovery Manager (RMAN), Real Application Clusters (RAC); Oracle Automatic Storage Management (ASM), SQL, PL/SQL; Microsoft SQL Server; Windows; networking; virtual machines; batch/cmd scripting; PowerShell, SQL*Plus; Toad, GIT; physical database design; relational database theory; disaster recovery; back-up and recovery, relational database theory; Windows and Linux system administration; the Oracle optimizer and execution plans; troubleshooting and debugging, networking (TCP/IP), database security.

Abilities:
Ability to write complex programs and develop detailed program specifications; Ability to analyze data and situations, reason logically and creatively, identify problems, draw valid conclusions, and develop effective solutions; Ability to apply creative thinking in the design and development of methods of processing data with electronic computers; Ability to establish and maintain cooperative working relationships with those contacted in the course of the work; Ability to communicate effectively verbally and in writing, and prepare effective reports.

SPECIAL REQUIREMENTS

Valid California Driver's License and insurance as occasional travel may be required. 
While performing the duties of this job, the employee is regularly required to sit. The employee is occasionally required to stand and walk. Occasionally, the employee may be required to perform simple grasping and fine manipulation, use telephone, write or use a keyboard to communicate, crouch, crawl, reach and lift equipment up to 40 lbs. 

Level III: This job has no supervisory responsibilities. 

Level IV: This job may have supervisory responsibilities.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually moderate.

All employees are responsible for contributing to an inclusive, safe, and secure work environment that values diverse cultures, perspectives, and experiences and is free from discrimination.
 

THE POSITION

The City of Rocklin is looking for two Maintenance Workers to assist in the Parks Division of the Parks and Recreation Department. The Maintenance Worker is a temporary position and incumbents work on an as-needed basis, not to exceed 28 hours per week and up to 999 hours per fiscal year. Temporary employment does not provide any guarantee of continued employment and the City of Rocklin may end the assignment at any time. Temporary employees are not eligible for any other benefits except where required by law, and there is no guarantee of future permanent employment.

An example of duties are:

• Performs flood control measures by clearing creeks of obstructions, keeping drains clean and clear, and preparing sandbags in case of emergency.
• Performs crack sealing of asphalt, and backfilling trenches and excavations on City streets; performs repair, maintenance, and construction of sidewalks, curbs, and gutters.
• Removes concrete, builds forms, pours concrete, and performs other concrete work around City buildings as required.
• Empties trash cans, picks up and removes debris, litter, and trash from parks, athletic fields, trails, and landscaped areas throughout the City; removes graffiti and other unwanted markings from City-owned property.
• Plants, mows, prunes, and maintains turf, trees, shrubs, and plants; clears sites of weeds.
• Performs construction and repair of landscapes and other park facilities such as installing and maintaining signs, installing park structures, and installing and maintaining fences.
• Paints or stains and pressure washes and cleans park amenities and fencing.
• May apply pesticide, herbicide and other pest management treatments to vegetation and landscaped areas.
• Makes minor adjustments on service equipment; maintains tools and equipment in working order.
• Operates trucks, trailers, and other automotive equipment as required.
• Maintains logs of daily activities.
• Performs related duties as assigned.

MINIMUM REQUIREMENTS

Equivalent to graduation from high school
AND
Three (3) months of experience as a laborer in construction, maintenance, or landscaping work 

Licenses and Certifications

• Possession of, or ability to obtain and maintain, a valid California Class C Driver License and a satisfactory driving record is required. Individuals who do not meet this requirement due to a disability will be reviewed on a case-by-case basis.

The position is responsible for the performance of both the day-to-day power settlements among NCPA members, Western, California, and Federal electricity markets, local balancing authority area operators (CAISO, BANC, EIM), as well as settlement activities associated with NCPA Power Management’s Service Customers. Other responsibilities include tracking and meter data management validation duties, GHG (Greenhouse Gas) monitoring and analysis, analysis and testing associated with new CAISO market initiatives, and comprehensive analytic or technical studies, as required, including proceedings before state and federal regulatory agencies and public officials. This is a full journey-level position capable of performing all the duties and responsibilities of the Settlements Analyst I. Performs the full range of duties as assigned, receiving only occasional instruction, training, or assistance as new or unusual situations arise. Additionally, incumbents perform a variety of assigned complex technical and professional work in the areas of power accounts settlements, budgeting, systems development, and audit. Incumbents also provide technical analysis and assistance to staff, Members, contractual participants, and others, as required.

ESSENTIAL DUTIES AND RESPONSIBILITIES
This position requires that the incumbent report for work on time and maintain satisfactory attendance in accordance with Agency policy; Ensures work responsibilities are covered when absent; Arrives to meetings and appointments on time; Performs special assignments as assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Responsibilities:
Provides technical advice, functional instruction, and guidance to less experienced Power Settlement staff as needed. Trains new Power Settlements Analysts and cross trains as roles evolve. Recommends personnel actions. Prepares and presents training/tutorials on All Resources Bill, Pre-Bill process, Power Settlement processes overall, and various other topics, as needed, in person or via webinars (s) to NCPA Members and Project Participant staff.

Serves as subject matter expert, working with Information Services, on Power Settlements application requirements, such as All Resources Bill enhancements, and testing system enhancements in development.

Implements and operates complicated power settlements systems. Prepares complex analytical reports and supporting documentation.

Provides analysis, integration, and implementation of new energy market initiatives and/or customers/Scheduling Coordination accounts (e.g., ISO, Western Energy Imbalance Market (“EIM”), renewable generating resources, Community Choice Energy/Aggregators (“CCE”).

Monitors settlements associated with Renewable Energy Credits and acts as or provides support to NCPA’s Qualified Reporting Entity representative; registers credits on the Western Renewable Energy Generation Information System (“WREGIS”) or its successor.

Monitors settlements functions of Western capacity and energy allocations, market purchases and sales, Pool transmission activity, and other transactions as they occur; Prepares or reviews power settlement transactions for proper budget classification.

Conducts special studies requiring complex, voluminous, and detailed analysis of power costs and revenues. Recommends operational changes that provide better value to Members and Participants.

Coordinates and participates in the development, analysis, and monitoring of the Agency's power supply budgets. Acts as power settlements representative to other department managers and supervisors in regard to cost summary and budgetary reports.

Assists with the implementation of systems, policies, and procedures and special projects requiring highly technical study and analyses. Recommends changes or modifications to methods or systems as applicable.

Assists with formal budget and other presentations to upper management and the governing body.
Performs special assignments for the Power Settlements Supervisor or others as assigned, including preparation of testimony and exhibits for presentation before state and national regulatory proceedings.

MINIMUM QUALIFICATIONS

Education and/or Experience
Bachelor's degree (B. A.) from a four-year college or university with an emphasis on quantitative analysis, plus four (4) years of prior experience as a Power Settlements Analyst I or an equivalent combination of education and experience.

KNOWLEDGE AND ABILITIES 
Knowledge:
Knowledge of California Independent System Operator settlements procedures for tariff services and Metered Subsystem services; NCPA settlements procedures for scheduling coordinator services and the ten-member power pool; California Energy Imbalance Markets; NCPA’s Western (WAPA) contracts
California’s Green House Gas rules; CARB renewable energy credits; Knowledge of NCPA settlements procedures for scheduling coordinator services and the ten-member power pool.

Abilities:
Ability to retrieve detailed records and summary-level data from NCPA’s Oracle database systems through the use of Structured Query Language (“SQL”) statements in proprietary software (e.g., SAS, Toad, SQL Developer, Oracle Database Connection [“ODBC”]) and process through proprietary or open-source software programming applications (e.g., SAS, Visual Basic for Applications [“VBA”], R, Python, Excel workbooks); Ability to read, analyze, and interpret CAISO tariff, NCPA operating agreements, and contracts, standard industry power purchase agreements, technical procedures, and governmental regulations; Ability to write reports, business correspondence, and procedure manuals; Ability to present information effectively and respond to questions from groups of managers, clients, customers, and the general public; and the Ability to analyze and interpret settlement formulas expressed in summation notation.

SPECIAL REQUIREMENTS

Valid California Driver's License and insurance. 

This job has no supervisory responsibilities.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. While performing the duties of this job, the employee is frequently required to stand; sit; use hands to finger, handle, or feel; reach with hands and arms and talk or hear. The employee is occasionally required to walk; climb or balance; stoop, kneel, crouch, or crawl, and taste or smell. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and the ability to adjust focus.

The noise level in the work environment is usually moderate.

All employees are responsible for contributing to an inclusive, safe, and secure work environment that values diverse cultures, perspectives, and experiences and is free from discrimination.
 

TO VIEW JOB ANNOUNCEMENT, CLICK JOB PDF OR JOB ANNOUNCEMENT URL BELOW.

TO VIEW JOB ANNOUNCEMENT, CLICK JOB ANNOUNCEMENT URL BELOW.

Attention new and graduating Engineers! Help to shape and develop the changing energy industry.

DEFINITION
Under the direction of the Director of Engineering, this position provides engineering support to NCPA’s Power Generation Service department.  The Power Generation Service Department includes the “State of the Art” Lodi Energy Center (LEC) Combined Cycle Power Plant, our green Geothermal Power Plant, our Hydroelectric Power Plant, and includes our hydrogen fuel source with a mission to provide green and renewable energy to our 16-member agencies in Northern California.

This position is based out of Roseville, CA.  Roseville’s nearby recreation areas attract new residents who are looking for a great place to live and work! Roseville is located in Placer County, just 16 miles northeast of Sacramento, the state capital. Within one hour, you can enjoy water sports in nearby lakes and rivers, hike the beautiful Sierra foothills and ski the High Sierra. Situated between San Francisco and Lake Tahoe, our location offers the best of Northern California!

ESSENTIAL DUTIES
Manage and assist with power plant improvement projects, performance monitoring, and other initiatives. Conduct feasibility analysis, and justification, and prepare plans, and budgets.
Lead or assist with Root Cause Analysis (RCA) to investigate incidents that cause “forced outages”, equipment malfunctions, failures, or performance degradation at plants.
Provide administrative and end-user support for NCPA’s Computerized Maintenance Management System (CMMS) and Plant Information (PI Historian). Ensure that users are properly trained and the application is used in an optimal fashion. 
Support compliance with NERC/WECC reliability standards.  Assist in the preparation, review, collection, and organization of compliance evidence and associated procedures.

MINIMUM QUALIFICATIONS
Education 
For all levels, the qualified candidate will have a Bachelor’s degree from an ABET-accredited college or university with a focus on Mechanical or Electrical Engineering.

See the attached job description for full details.

TO VIEW JOB ANNOUNCEMENT, CLICK JOB ANNOUNCEMENT URL BELOW.
 

TO VIEW JOB ANNOUNCEMENT, CLICK JOB ANNOUNCEMENT URL BELOW.

TO VIEW JOB ANNOUNCEMENT, CLICK JOB ANNOUNCEMENT URL BELOW.