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.
 

PARAPROFESSIONAL TEMP - INTERN

THE DEPARTMENT:
The Community and Economic Development Department is committed to improving the quality of life in the San Rafael community.  Our mission is to make San Rafael a great place to live and to business.  The five department core functions are:

• Planning
• Building
• Code Enforcement
• Housing and Homelessness
• Economic Development and Innovation

The Economic Development and Innovation Division is dedicated to fostering economic vitality by facilitating collaboration between businesses, community, and the city.  Our mission is to increase investments in San Rafael that contribute to the growth of the City's economy, foster fiscal sustainability, expand job opportunities for all residents, and enhance the community's quality of life.

THE ROLE AND PROJECTS:
Reporting to the Economic Development Program Manager, the Intern will be engaged in project-based work to advance key economic development strategic initiatives.  Examples of the work include, but are not limited to the following:

• Implement tasks outlined in the San Rafael Economic Development Strategic Plan.
• Develop a business support communications plan in collaboration with business support partners.
• Support Division Manager to activate outreach to businesses.
• Learn and assist with contract management.
• Evaluate resources available to various business groups through an equity lens.  Research strategies for business support for underserved sectors in San Rafael.
• Support activation of the Downtown San Rafael Arts District Strategic Plan.
• Administrative tasks as assigned.

HOURS, COMPENSATION & BENEFITS:
This position will work approximately 12-20 hours per week.  The candidate will have hands-on learning and work experience at San Rafael City Hall and outreach in the community.

This is a temporary position and hours worked may not exceed 1,000 hours in a fiscal year (July 1 thru June 30).

In accordance with the salary resolution, this position receives no benefits with the exception of Paid Sick Leave and a retirement plan.  

• Temporary employees are entitled to receive sick leave in accordance with California's Paid Sick Leave Law (AB 1522).
• Participation in a retirement plan is mandated by Federal Law and you will be enrolled in the Public Agency Retirement System (PARS):
  • Employee contributes 3.75% of salary
  • City of San Rafael contributes 3.75% of salary

APPLICATION PROCESS:
City of San Rafael application is required.  Resumes do not substitute for the City application.  To file an application online, go to www.calopps.org.  Select "Member Agencies."  Select "City of San Rafael."  Follow this link to submit your application:  https://www.calopps.org/san-rafael/job-20507019.  

REASONABLE ACCOMMODATION:
The City of San Rafael will make reasonable accommodations at any phase of the application and interview process to accommodate persons with disabilities.  If you have a disability for which you require accommodation, please advise Human Resources upon submittal of your application.  For examination accommodation, please contact Human Resources at least seven (7) calendar days before the test/interview date at 415-485-3474.

This position will perform a variety of responsible law enforcement and crime prevention work, including patrolling assigned areas, answering calls and complaints, investigating crimes, serving civil papers, and providing court room security; enforce all federal and state laws and local ordinances related to public safety and welfare.

WHAT YOU’LL DO

• Performs routine patrol duties, including but not limited to patrolling assigned areas of the County; responding to emergency calls and/or public calls for assistance; investigating disturbances, prowlers, burglaries, thefts, vehicle accidents and other crimes; checking buildings for physical security, etc.

• Administers first aid in emergency situations.

• Issues traffic citations.

• Serves warrants, subpoenas and civil documents.

• Apprehends and arrests suspects and violent persons; transports prisoners; seizes property and/or criminal evidence; interrogates suspects, witnesses and complainants; gathers and preserves evidence.

• Assists with County search and rescue operations.

• Prepares various reports on investigations, including arrest and unusual incidents observed.

• Assists with criminal investigations as required.

• Prepares case files; testifies and presents evidence in court.

• Works with other law enforcement agencies in matters related to the investigation of crimes and apprehension of offenders.

• May serve as special duty officer as assigned, including responsibilities such as serving on the narcotics task force, serving as Deputy Coroner, providing court security, serving as school resource officer, serving as K-9 handler, serving on gang task force, etc.

• Participates in other special projects and programs as assigned.

• Performs duties related to crime prevention and community relations.

• Performs general administrative work, including but not limited to attending meetings, preparing correspondence and reports, entering computer data, maintaining files, answering the phone, etc..

• Performs related duties as assigned.

This position performs a variety of work in the monitoring of county, state and federal detainees and maintains the security and safety of inmates and staff.

WHAT YOU’LL DO

• Performs booking procedures, including receiving, booking and assigning prisoners to cells; performing body searches; fingerprinting, and photographing prisoners, etc.
• Maintains custody of prisoners’ private property.
• Maintains the safe and orderly operation of the County jail facility; monitors security cameras and door warning lights; screens and monitors visitors. Inspects all of inmates’ incoming and outgoing mail and telegrams.
• Inspects facilities regularly.
• Monitors the condition and activities of prisoners.
• Prepares prisoners for court appearances; provides transportation as necessary.
• Administers First Aid in emergency situations.
• Performs general office work, including but not limited to entering computer data, copying and filing documents, etc.
• Prepares and submits required records and reports.
• Performs related duties as assigned.

LATERAL HIRING INCENTIVES

Hiring Bonus $2,500 - $10,000 (DOE)

 50 Hrs. Sick & 50 Hrs. Vacation (@ Hire)

Reduced Field Training Program

Reduced Probationary Period

Relocation Assistance May Be Available

(*Lateral Hiring Incentives Eligibility: Must be currently employed in a California municipal or state police agency, county sheriff’s department or California Highway Patrol, or similar as defined in California Penal Code §830.1 or §830.2)

About The Position:

The County of Yuba is actively recruiting to fill current vacancies and establish an eligibility list for the position of Deputy Sheriff. Deputy Sheriff’s perform a wide variety of patrol officer and related duties required to effectively respond to and resolve the normal scope of peace situations, including the protection of life and property, enforcement of laws and ordinances, criminal investigation, report writing, crime prevention and suppression, case preparation and testimony, and providing information and assistance to the public and perform related duties as assigned. Incumbents may be assigned to a specific geographic area for patrol, investigations, crime prevention or other peace officer-related functions. 

*LATERAL HIRING INCENTIVES

· Hiring Bonus $2,500 - $10,000 (DOE)

· 50 Hrs. Sick & 50 Hrs. Vacation @ Hire

· Reduced Training Period

· Reduced Probationary Period

· Relocation Assistance May Be Available

*Lateral Hiring Incentives Eligibility: Must be currently employed with an adult county, state, or federal correctional institution.

The Yuba County Sheriff’s Department is currently accepting applications to establish an eligibility list for the classification of Correctional Officer.  Under continuing supervision incumbents perform a wide variety of support in two areas: corrections, in which incumbents ensure the security, safety and care of individuals in custody; and bailiff, in which incumbents ensure the safety and security of the courts and their personnel during court proceedings; and perform related work as assigned. Incumbents may be assigned to either County Jail security or Court security. 

About the Sheriff’s Department :

The Yuba County Sheriff's Department is responsible for the administration of the Yuba County Jail and Jail staff. The Mission of the Yuba County Jail is to provide safe, efficient, humane and secure custody of all persons incarcerated. The county prisoner population is made up of those who are sentenced to county jail, those serving state prison sentences in the county jail under AB109, and those who are pre-trial and who have not yet been sentenced. The jail provides a necessary link in the criminal justice system. There are numerous programs operating within the facility including medical, kitchen, exercise, commissary, visiting, law library, inmate education, work programs, work furlough program, and inmate classification.

This position is a working level civilian class in law enforcement, performing a variety of non-sworn duties in support of law enforcement activities.  Incumbents may perform civil, code enforcement, and criminal services including a variety of routine to more complex non-sworn law enforcement and crime prevention work including patrolling assigned areas, answering calls for service and complaints, serving civil papers, providing court room security; and enforcing local ordinances related to public safety and welfare.  As a County Services Officer he/she will enforce Division 14 of the Agricultural Code of the State of California and enforce the County ordinance governing the animal and rabies control program, in an effort to maintain public safety and welfare.  This position is scheduled for forty (40) hours per week. 

WHAT YOU’LL DO

• Enforce Title 8 of the County Code and Division 14 of the California Agricultural Code pertaining to animal control and treatment.
• Prepares various reports and case files on investigations, issues citations and warnings for violations of ordinances; files charges with District Attorney as appropriate; testifies and presents evidence in court.
• Works with other law enforcement agencies in matters related to the investigation of crimes and apprehension of offenders. 
• Process and serve documents involved in civil actions including summons, complaints, claims of plaintiffs and orders; declarations and orders of examinations, Notice of Entries of Judgments, civil and criminal subpoenas, Notice to Vacate Premise and process writs of execution including the preparation of orders for wage garnishment.
• Performs general office work as required, including but not limited to preparing reports, maintaining records and files, and entering computer data.

Program Overview:

As an intern at the City of Simi Valley, you will be provided with on-the-job training and experience working in local government while you continue to work on obtaining your educational degree. In addition, you will build employment skills, and establish a professional network.

Details:

• Start Date: Monday, August 12, 2024
• Temporary, part-time position 
• In-person in Simi Valley (we do not offer remote internships)
• $16 per hour for a maximum of 20 hours per week
• Up to a maximum of one calendar year (depending on department need and budget)
• Multiple departments and focus areas available (see list below)
• Most assignments are flexible around your schedule during regular business hours!
   

Qualifications:
Current enrollment in an accredited college, university, or community college and enrolled in at least three (3) units of academic coursework. If hired, you still need to continue to be enrolled and attend school to remain in the position.

Typical Student Intern Duties:

• Prepare, from rough draft, or verbal instructions, such materials as reports, letters, receipts, lists, orders, schedules, notices, statistical data, social media, and copies of documents.    
• Provide customer service to the public or act as a receptionist, answer routine questions of the public, in person or by telephone.    
• Perform all types of filing (alphabetical, numerical, etc.)
• Post data, keep records, and prepare reports using predetermined forms and procedures.    
• Perform work related to bills, orders, notes, receipts, permits, licenses, etc.    
• Operate various office machines or equipment requiring little specialized training.    
• Collect and deliver correspondence, records, packages, etc. 
• Open, sort, and route incoming mail; stuff, seal, stamp, meter, and register outgoing mail.    
• Search records and files for data.    
• Compare and proofread documents; take notes.   
• Sort and arrange documents, correspondence, or other material. 

Assignments Available (Hours Per Week & Position Focus Areas):
On your application, you will be asked to indicate which assignment(s) you would like to be considered for. Below is a list of the assignments available. Assignments are flexible to your availability during regular business hours (Monday to Friday 8 am to 5 pm) unless otherwise noted below.

• Administrative Services (20 hrs/wk): Data Compilation, Information Technology, Facilities, Research / Analysis
• Administrative Services (20 hrs/wk): Accounting / Finance, Clerical
• City Attorney (8-12 hrs/wk): Human Resources, Research / Analysis, Legal, Law Enforcement
• Public Works (20 hrs/wk): Data Compilation, Research / Analysis    
• Public Works (10-20 hrs/wk): Clerical, Public Information, Research / Analysis, Engineering/Environmental Science 
• City Manager (15-20 hrs/wk): Administration, Public Information, Public Relations, Social Media     
   

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.