Search Jobs

Located in Middletown, CA!

The Mechanic Operator position consists of five levels of competency.  Individuals can either enter into the classification at the beginning level of the job or somewhere between the entry level and the top step depending on the qualifications brought with them.  It is the expectation of NCPA that all employees progress to the top level.  In order to progress to the top level an employee must complete all components in a competency level within the associated training matrix.  Employees who successfully complete a training level matrix and who received a rating of “meets requirements” or higher by their immediate supervisor will be promoted when qualified.  Upon completion/demonstration of competencies employees will be expected to perform work in all completed levels and other job-related duties as required. All employees have the right to challenge any component in the training matrix by proving proficiencies verbally and practically.

General Scope of the Job
Under general supervision of the Mechanical Maintenance Supervisor and at times under the general direction of the Mechanic Operator Lead Person; to maintain, repair, adjust, install, and test, powerplant steam field, water injection systems and equipment and maintain lease site grounds.  The measure of accuracy and reliability is the safe, effective and efficient performance of the Facilities.  This position is predominately mechanic based with operation support as outlined below.

Description of Duties and Responsibilities
Level III:
This level of the Mechanic Operator position requires the completion of all Level III training requirements. The employee must perform the duties as described below and as defined in lower levels while attaining Level IV skills and experience through academic and hands-on training. Level III knowledge and skills focus on journey level mechanical duties and responsibilities.
•    Inspects, tests, calibrates, installs, rebuilds, adjusts, repairs and aligns all mechanical equipment such as hydraulic control systems, turbines, generators, cooling tower, pumps, electric motors, valves, gear reducers, compressors, blowers heat exchangers, HVAC systems excluding refrigerant replacement, fire protection systems, diesel and gas engines, mufflers, separators, traps, rock catchers, tanks, pipeline and pipe supports.
•    Maintains facility structures. 
•    Performs basic inspections and repairs various rigging equipment, fixtures and cranes.
•    Assists the scaffolding qualified journeyman in maintaining, and repairing scaffolding. 
•    Inspects and maintains safety devices such as harnesses and rescue equipment.
•    Works with Safety Manager to maintain records of regulated equipment.
•    Keeps accurate records of equipment history, reports and work orders on computer for CMMS.  Works with CMMS personnel for accuracy and reliability.
•    Performs preventative maintenance and assessments on various plant equipment.
•    Writes Work/Operating Procedures within area of expertise.
•    Requisitions replacement parts and supplies to carry out assigned tasks.
•    Makes working drawings of components and changes made to Plant systems relative to area of expertise.
•    Installs, inspects, tests, repairs, rebuilds, and maintains equipment such as portable and fixed site pumps, valves, mufflers, separators, traps, rock catchers, turbines, generators, motors, gear reducers, compressors and hydraulic control systems, pipelines, tanks, pipeline supports, effluent piping components.
•    Maintains lease site grounds structures, culverts, roads, drains and ditches.
•    Examines and diagnoses malfunctions or defective equipment on pumps, motors, valves, separators, vents, air vacuum breakers and compressors; disassembles/reassembles, overhauls and adjusts defective equipment
•    Installs, fits and calibrates equipment replacement parts.  Observes equipment operation.  Adjusts equipment to operational specifications using specialized tools and precision measuring instruments.
•    Disassembles, removes, repairs, replaces, assembles and aligns pipes, pipeline components, and valves repairing or replacing broken and worn parts using various hand tools.
•    Observes and directs contractors while digging trenches, cleaning tanks and maintaining lease site grounds.
•    Under the direction and training of operations, assists with clearances on steam field and effluent pipeline equipment for maintenance purposes.
•    Will be trained to Rig and lift equipment to install, repair or replace equipment.
•    Instructs and trains workers in repair and maintenance procedures of steam field, power plant and effluent pipeline equipment.
•    Maintains inventory of tools and materials for the maintenance work at the steam field and effluent pipeline.
•    Maintains steam field equipment records on work completed on CMMS or equivalent maintenance program.
•    Assists other classifications when needed.
•    Performs other job-related duties as required.
•    Acquire OSHA certified training to meet business needs.
•    Trains and advises other workers in the maintenance and operation of steam field and effluent pipeline equipment.
•    Maintains and repairs Hydraulic Control Systems.

Level IV:
This level of the Mechanic Operator position requires the completion of all Level IV training requirements for operational duties and responsibilities.  The employee must perform the duties as described below and as defined in lower levels while attaining Level V skills and experience through academic and hands-on training.
•    Reviews, coordinates and reports work orders, work activities and equipment clearances with appropriate personnel.  
•    Checks equipment to be cleared in advance to guarantee its condition to others.  Informs Operator Technician Lead Person and Supervisors of the status of equipment and systems.  
•    Under direction of the Operator Technician Lead Person or a designee, operates various equipment and performs basic equipment clearances on low voltages (<600 volt) electrical breakers, steam line equipment and effluent equipment.  
•    Terminates and connects motor wiring to facilitate bearing repairs (less than 600 volts.).
•    Conducts online test of equipment before certifying its status and performance.

Machinist Duties and Responsibilities
•     Sets up and operates machine tools to repair or reproduce equipment parts and fittings working from blueprints or defective parts using precision tools and measuring instruments.
•    Fabricates special tools, rigging equipment and replacement parts to repair equipment.   
•    Fabricates, modifies, shapes and repairs equipment parts using a variety of metal working machines.
•    Chips, grinds, bores, and drills equipment parts.
•    Verifies conformance of finished work piece to specifications, using precision measuring instruments.
•    Calibrates, fits and assembles equipment parts according to drawings and specifications using machine tools, power tools, and measuring instruments.
•    Installs machined replacement parts; starts and observes equipment operation to detect malfunctions or out-of-tolerance performance, adjusts as necessary.
•    Maintains shop equipment and tools.
•    Maintains inventory of machining tools.

Representative Physical and Job Demands
•    Regularly talks and listens to others to exchange and obtain information to direct the operation and maintenance of Geothermal Facility steam field and effluent equipment.
•    Regularly reaches, grasps, pushes and pulls various wrenches, hand tools, and other objects using manual dexterity and eye hand coordination to operate and maintain equipment.
•    Regularly climb ladders and walks on platforms near high temperature surfaces; works on slippery or uneven surfaces in precarious places.
•    Frequently walks, reaches, kneels and crouches using feet, legs, hands and manual strength to access and operate plant equipment.
•    Occasionally lifts and moves pumps motors and pipe weighing up to 50 pounds.
•    Routinely works near heated surfaces; works on slippery or uneven surfaces in precarious places to adjust or operate equipment.
•    Occasionally exposed to high voltage and other electrical hazards while working on equipment.
•    Routinely works in outside weather conditions and is exposed to chemicals, wet and humid conditions, extreme cold and heat while inspecting and maintaining equipment.  The noise level is frequently very loud.
•    Routinely listens to operating sounds of equipment to diagnosis equipment malfunctions.
•    Frequently operates forklifts cranes, air compressors, sandblasters and power tools to maintain and repair equipment.
•    Frequently operates Agency vehicles going to and from job locations.

Job Expectations
Acquisition and Use of Technical Knowledge
•    Possesses or acquires as needed the ability to detect, diagnose disassemble and repair steam and water equipment with a fundamental knowledge of; turbine equipment, and auxiliary systems and their capabilities; operation processes, mechanical and electrical theory and background to operate equipment; measuring devices and hand tools for maintenance work; general contamination and control practices and procedures; basic math, geothermal powerplant rules and regulations; clearance procedures, physics including pump mechanics; basic principles of thermodynamics and fluid flow.  Given this basic knowledge, understands own role within the plant and how that role requires the use of knowledge applied to practical, day to day, operations and maintenance demands.  Hold self-accountable to acquire knowledge that may be needed when a job situation changes, new tasks are introduced to the job, or when improved performance requires acquiring extended or specialized information.
•    Possesses or acquires as needed an extensive knowledge of safety, fire, and security rules and procedures.  Given the emphasis of safety at the plant, uses knowledge to improve plant conditions and the organization’s safety record.
•    Acquires knowledge of operations and maintenance procedures on a continuing basis to stay current as a significant contributor to plant solutions, safety performance, and operations and maintenance improvements.
•    Confers with Operator Technician Lead Person or Operations Supervisor to resolve system problems and offers a variety of workable solutions to complex problems and report status of systems and equipment.  
•    Identifies problems or trends with systems and equipment early to prevent operator or electrical errors. 
•    Passes knowledge on to other employees as a way to contribute to the performance of others, or get a job done.
•    Assesses own limitations with the fundamental knowledge needed to perform in the job.

Application of Technical and General Job Skills
Technical and job skills are indicated by demonstrating an ability to:
•    Efficiently and effectively operate, control, and maintain equipment, and be accountable for aspects of the job at the Geothermal Facility. 
•    Implement or use existing methods to control the waste of time, money and material resources, such as:
o    Acting to improve work procedures 
o    Conserving resources 
o    Expediting a job
o    Completing a work assignment efficiently
o    Completing long term work in an orderly fashion
•    Work with management to identify and learn from mistakes made and apply what is learned to future situations or plant conditions.
•    Establish and maintain effective work relationships with those contacted in the performance of required duties.
•    Review own action to determine the cause of poor working relationships so those relationships can be improved
•    May be required to work extended hours and on normal days off.
•    Operate Agency vehicles and equipment safely.

Training and Experience Requirements
Level III: Completion of the NCPA Level III training program or three years of equivalent journey-level mechanical experience.
Level IV: Completion of the NCPA Level IV training program or three years of equivalent journey-level mechanical experience and operations experience.

Driver’s License Requirement
Possession of an unrestricted Class C California operator’s license issued by the State of California, Department of Motor Vehicles.  Possession and maintenance of a good driving record as demonstrated by the absence of multiple or serious traffic violations or accidents within the last three (3) years.

Desired Qualifications 
•    Possession, or ability to obtain with training, a Class A California operator’s license issued by the State of California Department of motor Vehicles.
•    Ability to set up and operates machine tools to repair or reproduce equipment parts and fittings working from blueprints or defective parts using precision tools and measuring instruments.
•    Ability to Fabricate special tools, rigging equipment and replacement parts to repair equipment.   
•    Ability to Fabricate, modifies, shapes and repairs equipment parts using a variety of metal working machines.
•    Chips, grinds, bores, and drills equipment parts.
•    Verifies conformance of finished work piece to specifications, using precision measuring instruments.
•    Calibrates, fits and assembles equipment parts according to drawings and specifications using machine tools, power tools, and measuring instruments.
•    Installs machined replacement parts; starts and observes equipment operation to detect malfunctions or out-of-tolerance performance, adjusts as necessary.

EOE

The Town of Moraga values the contributions made by students of all ages and backgrounds and is seeking bright innovative, results-oriented individuals to join our Internship Program. This program has been developed to provide college, university or graduate students with the opportunity to gain both academic and practical experience working in local government. The internships are designed to provide the participants with the opportunity to apply academic skills to various “real world” assignments. Students will have the opportunity to learn about local government and the services they provide.

PLANNING INTERN JOB DESCRIPTION AND DUTIES

The Planning Intern will have the opportunity to assist in a variety of tasks and duties involved in day to day operations of the Planning Department. The Planning Department is responsible for overseeing and guiding development in the Town of Moraga.

Typical Duties:

• Assist staff with Town permit applications, land use and zoning information.
• Assist staff with reviewing and processing development proposals.
• Complying with county, state and federal land use and environmental programs and regulations.
• Provide staff assistance to the Planning Commission, Design Review Board and Town Council.
• Assist in preparation, maintenance and/or verification of accounting, financial, statistical records, logs, ledgers and files.
• Conducts research on projects, studies, reports and related information for decision-making process.
• Perform administrative work such as answering phones, copying, and filing.
• Performs other related duties as required that may not be specifically listed in the job description but are within the general responsibility level associated with this class.

The Fremont Police Department - Animal Services Division is recruiting for the position of Veterinarian.

First Review of Applications 
The first review of applications is May 27, 2024 at 5:00 PM (PT). Interested applicants are encouraged to apply immediately. A resume must be submitted with the completed online application. Applications submitted without a resume may not be considered. Only online applications will be accepted.

Job Responsibilities:

• Performs high volume, high quality spay/neuter surgeries of shelter animals and owned animals including dogs, cats, and rabbits
• Determines the need for diagnostic procedures and medical treatments
• Provides high quality shelter medicine by performing physical exams, treatments, and surgical procedures on shelter animals
• Monitors and evaluates the shelter population for behavioral conditions
• Administers injections to humanely euthanize animals in accordance with California State Law and Department guidelines and policies

Desirable Qualifications:

• Experience in the following areas:
  • High volume spay/neuter
  • High volume herd health
  • Shelter medicine
  • Emergency triage
  • Community cats spay/neuter

The Fremont Police Department - Animal Services Division is recruiting for the position of Veterinary Technician. 

First Review of Applications 
The first review of applications is June 5, 2024 at 5:00 PM (PT). Interested applicants are encouraged to apply immediately. A resume must be submitted with the completed online application. Applications submitted without a resume may not be considered. Only online applications will be accepted.
 

Job Responsibilities:
The Veterinary Technician will perform  basic physical examination of animals on intake; understand infectious disease; communicate effectively with colleagues and the public; perform functions required for pre- and post-surgical care including inducing anesthesia; maintain all necessary controlled substance drug logs and patient records.

Example of Job Duties

• Provide intake examinations and interviews.
• Assess, record and maintain health and temperament information on all animals.
• Conduct pre-adoption health evaluations for dogs, cats, and other species.
• Vaccinate animals, provide treatment, and administer medications as prescribed by a veterinarian.
• Assist veterinarians with high volume spay/neuter surgeries and other medical procedures.
• Administer injections including, but not limited to, anesthetics, pain medications, and vaccinations.
• Intubate animals, place intravenous catheters, perform venipuncture and administer fluids as needed.
• Monitor vital signs of sedated and anesthetized patients in pre-operative, operative, and post-operative phases.
• Ensure anesthetic machines, pulse oximeters, scales, and other equipment are functional and report equipment that is not working properly.
• Work with coworkers to clean and disinfect animal areas, equipment, instruments and facility while utilizing appropriate personal protective equipment.
• Maintain inventory of all pharmaceuticals, medical equipment, and supplies.
• Maintain accurate and thorough records of all surgeries, drugs administered, and other information according to all mandated federal, state, local, and professional standards, and procedures.
• Provide technical and functional lead supervision and training to animal services staff and volunteers.
• Conduct humane euthanasia of domestic animals and wildlife.
• Communicate with all clients in a non-judgmental, effective and professional manner.
• Communicate basic veterinary medical concepts to clients, including, but not limited to vaccine protocols and anesthetic risks.
• Explain information provided by the veterinarian about an animal’s condition to clients.
• Collaborate and foster good communication with colleagues.
• Support any field staff as assigned.

The Application Programmer performs or assists in the design, documentation, coding, testing, and implementation of new application programs or enhancements to existing application programs consistent with the Software Development Life Cycle (SDLC) best practices and applicable computer programming standards and frameworks. The position is primarily responsible for the suite of Bid-to-Bill applications as well as other business applications in use by the Agency. The position will work with other developer staff and supervisor during probationary status to learn and develop proficiency in the use of the Agency's software development frameworks, processes, and documentation design standards.

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 as assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Level I: 
This classification is an entry-level position that is not expected to perform with the same level of independence of direction and judgment as higher levels. The level I works closely with other senior-level CTAs and is often given direction to complete tasks, install and troubleshoot hardware and software, perform system upgrades, evaluate and apply patches to systems, work closely with customers, and provide application support through help desk requests, and creates and maintains documentation.

Level II: 
This classification requires having all Level I duties and responsibilities with a minimum of two years of experience in software application development. Level II receives occasional direction and guidance from other senior-level CTAs; otherwise, uses developed experience and professional judgment to successfully complete projects in accordance with defined requirements and established timelines.

Responsibilities:
•    Within a specific hardware and operating system environment, work to define and design the operating features of new programs or enhancements
•    Produce appropriate conceptual-level application documentation for review and approval by the supervisor
•    Produce appropriate programming documentation for the review of the Supervisor, with sufficient detail on which to base programming activities
•    Develop computer programs in accordance with design documentation, closely following coding standards and conventions used within NCPA
•    Test applications using prescribed test methodology and tools
•    Develop an implementation plan, prepare production rollout for approval by the supervisor, and coordinate with the Ops team to execute the rollout
•    Maintain and enhance software applications
•    Conduct independent communications with user departments in a cooperative and professional manner
•    Provide emergency system support outside normal working hours as needed, on a rotational basis with other department employees
•    Travel to NCPA remote field sites to provide support to remote users as needed 
•    Assist in the evaluation of proposed new or modified computer system hardware and software

MINIMUM QUALIFICATIONS

Level I:
Education and/or Experience      
Bachelor's degree in Computer Science, Management Information Systems, Computer Engineering, or related field from an accredited four-year college or university and at least six months of related programming experience and training.

Level II:
Education and/or Experience      
Bachelor’s degree in Computer Science, Management Information Systems, Computer Engineering or related field from an accredited four-year college or university and at least two years of related programming experience and training. A minimum of two years in design and programming experience including some experience programming interactive programs. Experience must include exposure to systems analysis techniques.

KNOWLEDGE AND ABILITIES 
Knowledge:
Knowledge of VB.Net and/or C# as core programming language is essential; Integrated development environment (IDE) such as Microsoft Visual Studio; Source control management tools such as Team Foundation Server (TFS) and Git; JavaScript, HTML5, and Cascading Style Sheets (CSS) for developing web pages is highly desired; Oracle PL/SQL, SQL-Server T-SQL or similar SQL experience and understanding of relational database principles. Knowledge of software testing methodologies and tools, computer equipment and capabilities, data communications and local area networking, and client-server software is essential; Principles and programming techniques used to implement online interactive applications, technical report writing, systems analysis techniques, database management concepts, and management information system concepts; DevOps and related best practices; and knowledge of the Component-based Scalable Logical Architecture (CSLA) is an advantage.

Abilities:
Ability to write moderately complex programs and develop detailed program specifications; Demonstrate an understanding of MVC (Model-View-Controller; Stay up to date with related software development technologies through training, product research, and participating in conferences and user groups. Ability to work effectively with a broad, diverse cross-section of peers and various individual personalities; listen effectively, communicate with, and maintain a professional working relationship with co-workers; communicate clearly, efficiently, and professionally both over the phone and in person; Maintain strong organizational skills; and the ability to complete quality and timely work with minimal supervision.

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 regularly required to sit and view and operate a computer, use hands to finger, handle, or feel, reach with hands and arms, and talk or hear. Requires manual finger dexterity and eye-hand coordination to operate and adjust office equipment such as computers. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, color vision, and the ability to adjust focus.

The noise level in the work environment is usually quiet.

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.

Glenn County Health and Human Services Agency is seeking a dedicated and compassionate individual to serve as a Volunteer Behavioral Health Hearing Officer. In this role, you will play a vital part in ensuring fair and just hearings for individuals facing behavioral health challenges. As a Hearing Officer, you will be responsible for conducting hearings, reviewing cases, and making decisions that uphold the rights and well-being of those involved. This position offers a unique opportunity to contribute to the mental health and overall welfare of your community. This role meets all requirements for a hearing officer set forth by CA Welf & Inst Code § 5256.1 (2022).
 

MINIMUM QUALIFICATIONS

Experience: Five years' experience in mental health.

License: The certification review hearing officer shall be either a state qualified administrative law hearing officer, a physician and surgeon, a licensed psychologist, a registered nurse, a lawyer, a certified law student, a licensed clinical social worker, a licensed marriage and family therapist, or a licensed professional clinical counselor.

THE POSITION

Tri-City is currently hiring to fill one full-time vacancy for the position of Peer Support Specialist I/II (PSS) within the Adult Outpatient (AOP) Department. The PSS position provides peer to peer support services in the office and/or in the field including, but not limited to outreach, support, encouragement, guidance, advocacy, and referrals to external resources and services for clients and their families; builds rapport with clients and their families through sharing stories of lived experience and recovery.

This position is responsible for a variety of ongoing responsibilities including, but not limited to:

• Encourages and supports clients to fully engage in services; provides outreach and assists clients in addressing and overcoming barriers to treatment.

• Provides resources and referrals to address basic needs and other barriers to wellness and recovery including food, housing, clothing, transportation, and other financial resources.

• Assists clients with setting, implementing, and tracking wellness and recovery goals; develops individual Wellness and Recovery Action Plans (WRAP); models and shares effective coping strategies.

• Assists clients and families to understand behavioral health problems and steps to recovery.

• Provides support and guidance in navigating systems and obtaining additional support services; attends meetings and therapy sessions with clients (as needed); assists with completing applications and forms; and ensures client concerns are address and processes understood.

THE POSITION

Tri-City is currently hiring to fill one part-time vacancy for the position of Peer Support Specialist I (PSS) within the Children's Outpatient (COP) Department. The PSS position provides peer to peer support services in the office and/or in the field including, but not limited to outreach, support, encouragement, guidance, advocacy, and referrals to external resources and services for clients and their families; builds rapport with clients and their families through sharing stories of lived experience and recovery.

This position is responsible for a variety of ongoing responsibilities including, but not limited to:

• Encourages and supports clients to fully engage in services; provides outreach and assists clients in addressing and overcoming barriers to treatment.

• Provides resources and referrals to address basic needs and other barriers to wellness and recovery including food, housing, clothing, transportation, and other financial resources.

• Assists clients with setting, implementing, and tracking wellness and recovery goals; develops individual Wellness and Recovery Action Plans (WRAP); models and shares effective coping strategies.

• Assists clients and families to understand behavioral health problems and steps to recovery.

• Provides support and guidance in navigating systems and obtaining additional support services; attends meetings and therapy sessions with clients (as needed); assists with completing applications and forms; and ensures client concerns are address and processes understood.

The City of Vacaville - A beautiful place to live, a great place to work!

With more than 600 employees, the City of Vacaville values work-life integration and offers flexible/hybrid work schedules, every other Friday off, employee social and wellness activities, casual dress days, competitive pay and a generous benefits and retirement package.

Contribute to our vibrant community and join the City of Vacaville!

The City of Vacaville is accepting applications for the position of Assistant/Associate Planner in the Community Development Department. Currently, one (1) vacancy exists in the Advance Planning Division, but this recruitment will also establish an eligibility list to be used for any future Assistant/Associate Planner vacancies over the next 12-month period.  

The Assistant/Associate Planner position is flexible in staffing and may be filled at either the Assistant (entry) level or Associate (journey) level, depending on candidates' qualifications and departmental needs. Individuals in the Assistant Planner role may progress to the Associate Planner level upon meeting higher-level qualifications. 

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

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.