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 Department: The Suisun City Police Department is a progressive and proactive law enforcement agency. As a result of its proximity to neighboring jurisdictions, the employees of the Suisun City Police Department remain extremely busy as they address the needs of the community. Candidates interested in testing for this position must be prepared to take on the challenges of a fast-paced work environment serving both the Police and Fire Departments.

The Position: Under supervision (Public Safety Dispatcher I) or general supervision (Public Safety Dispatcher II)  the incumbent performs a variety of duties involved in receiving, evaluating, prioritizing, and relaying calls for emergency and non-emergency public safety assistance; dispatches appropriate units and coordinates response of emergency personnel; maintains, processes, and distributes police records; operates a variety of telecommunications equipment, including radio, telephone, and CAD systems; and performs a wide variety of specialized clerical duties involved in the preparation, maintenance, and release of materials related to law enforcement activities.

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.
 

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.

The City of Lincoln is creating an applicant pool for the position of Public Safety Dispatcher I/II within the Police Department.  Interested applicants may submit their application to be part of the applicant pool.  As new vacancies occur, the recruitment team will review applications for consideration.

The Lincoln Police Department is authorized for 23 sworn officers, six dispatchers, and various other civilian and volunteer positions.  The dispatch center provides public safety dispatch services for the Lincoln Police Department and three Lincoln Fire stations. The communications center is staffed 24/7 and dispatchers work in pairs or solo. Public safety dispatchers answer emergency and non-emergency calls for police, fire and other city services.  Dispatchers prioritize calls and dispatch public safety units as needed.  Heavy phone and radio use is a primary duty of the position.  Other duties include clerical and specialized record keeping functions.

Under immediate supervision, this position performs a wide variety of technical and clerical law enforcement support duties related to taking police, fire and medical emergency requests for service from the public and tracks and dispatches field units as appropriate; gathers, records, maintains, retrieves and distributes law enforcement data and information; enters reports and data into a variety of automated law enforcement records systems; ensures that records and information are accurate, clear and comprehensive for law enforcement personnel and the general public; learns applicable policies, procedures and work methods associated with assigned duties; performs other related duties as required.

DISTINGUISHING CHARACTERISTICS
The Public Safety Dispatcher I is the entry level class in which incumbents learn to perform and perform Police Dispatcher duties under immediate supervision. This classification is alternatively staffed with Public Safety Officer II and incumbents may advance to the higher level after gaining experience and demonstrating a level of proficiency that meets the qualifications of the higher class.

The Public Safety Dispatcher II is the working level class in which incumbents are expected to perform the full range of Police Dispatcher duties with minimum supervision and apply sound judgment regarding their scope of authority in dispatching personnel. This classification is distinguished from the Community Service Officer series in that the latter performs duties involving work in taking reports in the field and performing face-to-face public service activities.

SUPERVISION RECEIVED/EXERCISED
The Public Safety Dispatcher I receives immediate supervision from the Police Office Supervisor or a Watch Commander. Incumbents of this class do not routinely exercise supervision. The Public Safety Dispatcher II receives supervision from the Police Office Supervisor or a Watch Commander. Incumbents of this class do not routinely exercise supervision.

ESSENTIAL FUNCTIONS
Include but are not limited to the following:

• Receives and enters calls for police, fire and medical service in CAD; dispatches and tracks field units; interprets level of service needed through information obtained from field officers or citizens; coordinates multi-agency responses when necessary; transfers calls to appropriate agencies if warranted.
• Responds to questions and concerns from the general public, department staff and other agencies; takes and records telephone and counter reports; provides information as appropriate and resolves service issues and complaints.
• Enters and maintains accurate data and information into the California Law Enforcement Telecommunications System (CLETS) including stolen vehicles, and missing and unidentified persons; enters and retrieves information from a variety of state and local automated systems; validates selected records from the Department of Justice files including vehicles, boats and missing persons; releases impounded vehicles; processes reports and citations; collects and maintains statistical information.
• Learns and develops an understanding of applicable policies, procedures, and work methods associated with assigned duties.
• Photocopies and distributes crime, incident, arrest and accident reports to the general public and various agencies such as the Department of Justice (DOJ), California Highway Patrol, District Attorney, Department of Motor Vehicles (DMV) and insurance companies; prepares reports for court; applies federal, state and local laws when releasing information.
• Establishes positive working relationships with representatives of community organizations, state/local agencies and associations, City management and staff, and the public.

PHYSICAL, MENTAL AND ENVIRONMENTAL WORKING CONDITIONS
This position requires prolonged sitting, standing, walking, reaching, twisting, turning, kneeling, bending, squatting, and stooping in the performance of daily office activities. The position also requires grasping, repetitive hand movement, and fine coordination in preparing reports and retrieving and entering data using a computer keyboard. Additionally, the position requires near and far vision in reading work related documents and using the computer, and acute hearing is required when providing phone, dispatch and face to face service. The need to lift, drag, and push files, paper, and documents weighing up to 25 pounds also is required.

KNOWLEDGE/ABILITIES/SKILLS
The following are a representative sample of the KAS’s necessary to perform essential duties of the position. The level and scope of the knowledge and abilities listed below vary between the I and II levels.

Knowledge of: Civil, criminal, and municipal provisions relating to the various activities of the Police Department; law enforcement, fire, and other operating procedures and functions of the Department as they relate to the dispatch function; geography of the City and the surrounding environment; legal and procedural techniques and regulations regarding transmission and reception of public safety radio traffic; basic radio and related equipment maintenance.

Ability to: Perform a variety of complex work with speed and accuracy; remain calm under emergency situations; learn to operate specialized law enforcement automated information and communication systems; work flexible hours including evenings, weekends and split shifts; learn basic Spanish speaking skills that allow for communication regarding addresses, locations, time descriptions, etc.; interpret, explain and apply applicable laws, codes and regulations; read, interpret and record data accurately; organize, prioritize and follow-up on work assignments; work independently and as part of a team; make sound decisions within established guidelines; follow written and oral directions; observe safety principles and work in a safe manner; communicate clearly and concisely, both orally and in writing; establish and maintain effective working relationships.

Skill to: Operate an office computer and a variety of word processing and software applications; effectively operate specialized law enforcement automated information and communication systems; type accurately from clear copy at a rate of 35 words per minute.

THE SELECTION PROCESS

To be considered, candidates must possess one of the following at the time of application:

• POST Entry-Level Dispatcher Exam with a T-score of 48 or higher
• A valid POST-certified Public Safety Dispatcher Basic Course Certificate

The process may include an in-basket exercise, individual interviews, panel interviews and/or other related components.  Only those candidates who have the best combination of qualifications in relation to the requirements and duties of the position will continue in the selection process. Meeting the minimum qualifications does not guarantee an invitation to the process. The candidate selected for the position will be required to complete a background check including reference checks, fingerprint check, medical/drug-test evaluation and/or other related components.

Human Resources will make reasonable efforts in the examination process to accommodate persons with disabilities.  Please advise HR of any special needs a minimum of five days in advance of the selection process exam by calling (916) 434-3229. The City of Lincoln is an Equal Opportunity Employer.

The information contained herein is subject to change and does not constitute either an expressed or implied contract.

TO VIEW THE JOB ANNOUNCEMENT, CLICK 'JOB URL OR JOB PDF' BELOW