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.
 

FACILITIES ATTENDANT

(Two positions available)  

Part-Time/Temporary – No Benefits Available

(Maximum hours worked per fiscal year not to exceed 1,000 hours)

$17.50 - $27.15 per hour, depending on experience

Application Deadline:  OPEN UNTIL FILLED

The City of San Rafael Library and Recreation Department is now accepting applications for the position of Facilities Attendant (two part-time/temporary positions available).  This position provides customer service to renters and program participants while assisting with the supervision of front counter/reception area, set up and breakdown equipment for scheduled activities, custodial and cleaning including but not limited to emptying trash, vacuuming, cleaning windows, cleaning restrooms, etc.; opening and securing facility before and after building use and interacting with instructors, clients, and the general public.  Bilingual in Spanish is desired. 

Qualifications:

• Ability to provide good customer service to instructors, clients, and the general public.
• Ability to use a variety of cleaning equipment and materials.
• Ability to communicate effectively orally and in writing in English.
• Ability to follow written and oral directions.
• Ability to work cooperatively with others.
• Ability to work evenings, weekends and some holidays.
• Ability to regularly lift and/or move up to 50 pounds and occasionally lift and/or move up to 100 pounds.

Application and Selection Process:

City of San Rafael application is required.  Resumes do not substitute for the City application.  Prior to appointment, candidate must pass background check/fingerprinting.  To file an application on-line, go to www.calopps.org.  Select “Member Agencies”.  Select “San Rafael”.  Follow this link to submit your application:  https://www.calopps.org/san-rafael/job-20503599.  

Reasonable Accommodation:  The City of San Rafael will make reasonable accommodations to accommodate disabled applicants.  If you have a disability for which you require accommodation, please contact us at 415-485-3474.  Such accommodation must be requested by the applicant.

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.
 

To learn more about becoming an Academy Graduate Police Officer with the City of Rocklin visit JoinRocklinPD.org

*Effective July 2024 this position will receive a 2% base salary increase

Applications will be reviewed at the following cut-offs:

May 24, 2024
June 21, 2024

THE POSITION

The City of Rocklin is hiring Academy Graduate Police Officers to join the Rocklin Police Department. Academy Graduate Police Officers will join the department and begin an 18-month program to earn their Basic POST certificate. An example of duties that an Academy Graduate Police Officers will perform under close supervision are:

• Assumes responsibility for the preservation of the public peace and the protection of life and property by preventing crime and enforcing all laws.
• Patrols an assigned area in an automobile, other vehicle, or on foot for the purpose of preventing criminal activity and enforcing traffic laws and regulations; issues citations and makes arrests as necessary; responds to calls for protection of life and property and performs enforcement duties.
• Conducts interviews with victims, complainants, witnesses, and suspects; searches crime scenes for evidence; collects, packages, and preserves evidence; testifies in court.
• Detects, pursues, apprehends, and arrests or detains persons involved in crimes or misconduct; confronts and arrests violent combative subjects; books and transports prisoners; serves warrants and subpoenas.
• Conducts preliminary or follow-up investigations; prepares reports on arrests made, activities performed, and unusual incidents observed.
• Directs traffic and/or performs crowd control during special events and in emergency situations.
• Responds to and resolves difficult and sensitive citizen inquiries and complaints. • Actively develops and fosters community partnerships and demonstrates integrity and professionalism within the organization and community.
• Represents the City and the department in a courteous, professional manner.
• Performs related duties as assigned.

MINIMUM REQUIREMENTS

Equivalent to graduation from high school, supplemented by 30 college-level semester units from a regionally accredited educational institution.

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.
• Certificate of completion from a POST approved California law enforcement academy.

Working Conditions

Must be 21 years of age at time of appointment. Must be legally authorized to work in the United States under federal law. Candidates must pass a thorough background investigation.

Must be willing to work emergencies as well as evenings, weekends, and holidays.

Must meet physical, psychological, and background standards established by POST as well as ongoing peace officer requirements pursuant to federal, state, and local legislation. This classification requires wearing respiratory protective equipment at times. When assigned to such work, facial hair must be shaven when it interferes with the safe fitting of respiratory protective equipment. This classification functions as a peace officer within the authority and limits of California Penal Code Sections 830.1(a) and 832.

APPLICATION PROCESS

Applicants will be screened against the minimum requirements. Candidates who meet the minimum requirements will be invited to attend a Physical Agility Test (PAT). 

Those who receive a passing score on the PAT will be invited to a Structured Oral Examination.

Depending on the number of applications received, additional screening may be conducted.

The City of Dixon is opening a great opportunity for those interested in contributing to local law enforcement efforts for the position of Police Volunteer in the Police Department. Under the direction and supervision of experienced police personnel, volunteers will provide critical support across various functions, complementing the efforts of sworn officers and civilian staff.

This is a volunteer position intended as an educational and community service experience. In addition to serving a support role within the Police Department, this classification is exposed to a wide variety of law enforcement duties and will have different opportunities, based on level of interest, to support community policing efforts and activities.

Work involves irregular, often non-scheduled, hours during the day and evenings, and on the weekdays, weekends, and holidays. Some appointments and events would require some short distance travel to other City department locations.

Employment Processing: Those selected for hire must successfully complete and pass the following: a personal background investigation, and a pre-employment medical examination. In accordance with Federal law, an employee must provide proof of identity and legal right to work in the United States.

Veteran’s Preference Points: Veteran’s Preference points will be applied. A copy of the DD214 form must be filed as a PDF attachment at the time of application. 

The City of Dixon is an EQUAL OPPORTUNITY EMPLOYER. Reasonable Accommodation in the application, examination and selection process will be made upon request by calling (707) 678-7000.

Please do not reply to emails from CalOpps during this process at any time as this correspondence does not come back to our agency.

The City of Dixon is opening a great opportunity for those curious to learn about the ins and outs of police work for the position of Police Cadet in the Police Department. Under the supervision of veteran Police Officer's the cadet experiences what it takes to develop important cadet skills. Examples: cadet patrol, traffic control, attending meetings, delivery of witness subpoenas, report taking, provide assistance to the various bureaus within the department, directing phone calls to the appropriate personnel, learns how to interact with the community during all kinds of problem-solving situations.

This is an entry-level, volunteer position intended as an educational and career development internship. In addition to serving a support role within the Police Department, this classification is exposed to a wide variety of law enforcement duties and will gain experience in the work place.

A Cadet volunteers a minimum of 8 hours per month and work is conducted both in a police station and in the field. Work involves irregular, often non-scheduled, hours during the day and evenings, and on the weekdays, weekends, and holidays.

Employment Processing: Those selected for hire must successfully complete and pass the following: a personal background investigation, and a pre-employment medical examination. In accordance with Federal law, an employee must provide proof of identity and legal right to work in the United States.

Veteran’s Preference Points: Veteran’s Preference points will be applied. A copy of the DD214 form must be filed as a PDF attachment at the time of application. 

The City of Dixon is an EQUAL OPPORTUNITY EMPLOYER. Reasonable Accommodation in the application, examination and selection process will be made upon request by calling (707) 678-7000.

Please do not reply to emails from CalOpps during this process at any time as this correspondence does not come back to our agency.

The City of Sausalito Invites Applications for the Position of

POLICE OFFICER (LATERAL/ ACADEMY GRADUATE)

Salary: $7,218 - $9,673 Monthly

$3,332 - $4,465 Biweekly

Plus an excellent benefits package and additional incentives

OPEN UNTIL FILLED

Hiring Bonus: $5,000 after successful completion of Field Training and $5,000 after Probationary Period.

Under general supervision, the Police Officer performs a wide variety of patrol and related duties involving the prevention of crime, the protection of life and property, and the enforcement of Federal, State, and local laws and ordinances. The incumbent makes investigations, assists in the preparation of cases, and testifies in court; serves in specialized departmental roles as assigned. This is a sworn journey-level law enforcement classification that performs all assignments found in a municipal police department. The Police Officer provides information and assistance to the public; performs related work as assigned. 

Enjoy working outdoors?  Want to make a difference in your community?  School Crossing Guards play an important role in helping children who walk or bicycle to school by helping them safely cross the street at key crosswalk locations.

The City is interviewing to fill several openings for part-time positions.  Apply immediately to be considered.  Regular assignment and substitute (on-call) positions are available.  Hours for the 23-24 school year are typically 1-1.5 hours in the morning and 1-1.5 hours in the afternoon depending on the school location and schedule.

Primary responsibilities:

• Monitor and assist in crossing of school-age children during peak traffic times at select locations.
• Provide appropriate safety instruction for children crossing streets and intersections.
• Watch traffic flow and wait for an appropriate gap between vehicles to lead groups of school children safely across a street.

Are you looking for a great opportunity to connect with your community while investing in your future? Do you want to see first-hand what it’s like to engage in active, multi-generational work that directly contributes to the well-being of our greater Mill Valley community?  If you answered yes, then you belong with Mill Valley Recreation!  With our team, you will create memorable experiences while cultivating new and lasting connections within our greater Southern Marin Community. You will have the opportunity to grow and learn through consistent, quality training and, apply your learning through direct hands-on experience. Must be 18 years or older to apply for this position. 

DEFINITION: Under general supervision, responsibilities will include but not be limited to light office tasks, customer service, set up and take down of facility equipment and janitorial tasks. Perform related work as required.

Lead Facilities Attendants are expected to oversee Facility Attendant staff, supporting ongoing training, communication, and tracking of facility rentals, as well as speak and respond to rental related needs/ issues.   This is a part-time, year-round position.

EXAMPLES OF DUTIES:

• Set up and take down tables, chairs, audio-visual equipment, and other related material and equipment.
• Greet public and provide general information for all Recreation department classes, programs, and events.
• Daily janitorial/maintenance duties such as routine and special cleaning of restrooms, community center rooms (i.e. wipe counters, vacuum floors, sweep walkways, empty trash receptacles, replace paper products and litter pick-up).
• Monitors guest activities in the community center and enforce all rules, regulations and safety principals.
• Assist in opening and closing procedures for the entire Community Center.
• Occasionally assist with the coordination and execution of Department-sponsored outdoor events or classes.
• Maintain records and reports as required.
• Enforce all rules, regulations and safety principals. 
• Willingness and ability to work flexible hours including evenings, weekends and holidays.
• Ability to take the lead in completing assignments when working with a partner or on a team. 
• Respond professionally to emergencies, provide care as indicated under the scope of training.
• Deal tactfully and courteously with the public and build positive relationships with other staff.
• Actively attend and participate in required staff training.
• Reads and follows diagrams and instruction written in English.
• Ability to communicate clearly both orally and in writing.
• Perform related duties as required.

TRAINING & EXPERIENCE: Any combination of education, training, and experience, which likely provides the required knowledge and abilities.

PRE-EMPLOYMENT CONDITIONS:
Candidates receiving a conditional job offer must pass a pre-placement fingerprint review. The employee must satisfactorily complete an evaluatory period before obtaining regular status. Candidates must possess a current CPR/AED and First Aid certificate and be comfortable calling 911 in an emergency.