Search Jobs

The City of Woodland offers a competitive total compensation package including:

• Starting income ranging from $7,208.32 to $9,199.84 per month based on skills and years of experience, with incremental pay increases.
• Robust Retirement Program including CalPERS defined benefit pension plan, Retirement Health Savings Plan & 457 Deferred Comp plans with a 3% City match
• Low-Cost & No-Cost Health Benefits, including choice of CalPERS Medical plans, and City-paid Dental Insurance, Vision insurance and Employee Assistance Program
• Paid Training & Career Development, including City-paid Professional Growth Incentive, City-provided training, and professional advancement opportunities
• Home-Life Balance, inclusive work environment and predictable work schedule, as well as paid holiday, vacation, sick and administrative leaves

POSITION

Supervise, plan and coordinate the functions of the Laboratory, Industrial Wastewater Pretreatment Program (WPP), and related environmental compliance programs.  Performs and reviews analysis of potable water, wastewater, stormwater and related materials. Ensures sampling, monitoring, testing, reporting, WPP, and other environmental compliance programs comply with Federal, State and local requirements for potable water, wastewater and stormwater utilities.  The purpose of this recruitment is to fill a current vacancy in the Public Works Department, as well as establish an eligibility list for future vacancies.

IDEAL CANDIDATE

The Ideal Candidate for the Laboratory Supervisor position will have experience working in a wastewater or water laboratory, with knowledge of State, Federal and Local regulation and rules. This person will be familiar with water, wastewater, storm water, industrial pretreatment and related programs, and have a laboratory background in chemistry and microbiology as it applies to water, wastewater, stormwater, industrial pretreatment compliance programs.  In addition to meeting the minimum requirements of the position, the Ideal Candidate will be an independent thinker who is well organized, has excellent communication skills (written and oral), and good time management skills.  Previous supervisory experience is very desirable as this position will be responsible for supervising, mentoring and counseling division staff and programs as necessary.

Plan, program and supervise monitoring, sampling, and testing to ensure WPCF processes, potable water production, potable water distribution, and stormwater runoff comply with State and Federal standards. Supervise and coordinate laboratory quality assurance and quality control programs; develop new methods of laboratory analysis consistent with Federal and State guidelines. Work with and direct outside labs or environmental firms on water quality matters. Plan, program and supervise the goals and objectives of the Industrial Wastewater Pretreatment program. Coordinate pretreatment program activities for the Sanitary Sewer Management Plan and Stormwater NPDES Phase II permit. Review and approve quarterly and annual pretreatment reports. Interpret and enforce regulations related to pretreatment, wastewater collection and stormwater collection. Prepare detailed draft budgets, assist in preparation of final budgets and administer adopted budgets. Monitor legislation and make recommendations concerning compliance issues related to potable water, wastewater, stormwater, pretreatment and related programs. Compile, sign and submit monitoring and compliance reports to appropriate State and Federal Agencies. Perform advanced analysis on data to provide information for decision making. Represent the City on routine basis with State and Federal agencies, and other public bodies. Participate in professional groups and committees and with the general public regarding potable water, wastewater and stormwater, pretreatment and related programs. Participate in the hiring, training, supervision and evaluation of subordinates. Regular and consistent attendance. 

OTHER JOB FUNCTIONS

Assist with studies to audit and improve plant operations; conduct and assist with tours and regulatory inspection; respond to questions and requests from the general public. Ensure laboratory and pretreatment shop are maintained in a safe, clean and orderly condition. Ensure that maintenance, repair and calibration of laboratory and pretreatment equipment complies with process safety manual and manufacture recommendations. Observe safe work methods, practices and precautions; use appropriate safety devices and equipment in accordance with laboratory and pretreatment standard operating procedures. Plan safety and training programs and ensure that safety precautions and regulations are adhered to by subordinates. Perform related duties as assigned.

QUALIFICATIONS

Education: Bachelor of Science degree with major course work in chemistry and biology or a closely related field.

Experience:  Two (2) years of experience conducting chemical or biological laboratory analyses including two (2) years of experience performing laboratory analysis of water, wastewater or stormwater. Two (2) years of increasingly responsible experience in pretreatment and environmental compliance desirable.

License and Certificate:  Required upon hire, possession of a valid California Driver's License.  Possession of a current California Water Environment Association Grade II.  Laboratory Analyst certificate within 18 months of appointment.  Possession of a current California Water Environment Association Grade I Environmental Compliance Inspector certificate is desirable.

APPLICATION

Apply with a City of Woodland application online at www.cityofwoodland.gov/employment or by visiting the Human Resources Office, City Hall, 300 First Street, Woodland, CA 95695 by 5:00PM on Monday, June 17, 2024.  Supplemental questionnaire must be submitted with application by the final filing date to be considered.  Résumés and cover letters are encouraged but will not be accepted in lieu of the application form.  Postmarks will not be accepted.  

Review Process:  Based on the information provided in the application documents, the best qualified applicants will be invited for further examination.  All applicants meeting the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination.  Depending upon the number of applications received, the examination may consist of an application screening, written and/or practical exam, oral interview or any combination thereof.  Applicants will be required to take and pass a medical examination by a City of Woodland physician to ensure their physical suitability to perform the assigned duties. 

If you have a disability that requires accommodation during the selection process, please notify Human Resources at least seven (7) days prior to the event.

Panel interviews are tentatively scheduled for the week of June 24, 2024.

BENEFITS*

Current Salary:                      
$7,208.32 - $9,199.84/month ($3,326.92 - $4,246.08/bi-weekly)

Retirement:                            
CalPERS Retirement system (2% @ 60 Formula for Classic CalPERS members and 2% @ 62 Formula for new CalPERS members).  The City does not participate in social security

Deferred Compensation:                     
Choice of deferred compensation plans (Traditional and Roth).  City will match up to 3% of employee’s base salary

Medical:                                 
CalPERS Medical Insurance Plans, including HMOs & PPOs.  City gives an allowance toward the cost of insurance

Maximum Family Allowance for 2024: $2,195.79/Month

Dental/Vision:                         
City paid Delta Dental and VSP Vision Insurance

STD/LTD:                               
City paid wage protection for short- and long-term disabilities

Life Insurance:                       
City provides $50,000 life insurance policy

Voluntary Benefits:                
Voluntary Supplemental Life, Cancer, Accident Only, STD/LTD, and Critical Illness insurances, and Flexible Spending Accounts available

Vacation:                                
7 hours per month during first 3 years of service

Sick Leave:                            
8 hours per month

Administrative Leave:            
96 hours of leave time given each fiscal year

Holidays:                                
12.5 paid holidays (including two floating holidays)

Bilingual Pay:                         
$200 per month upon certification

Professional Growth Incentive:          
$625 per year for additional educational or professional activities

* Please note that Mid-Management/Professional Association (MMPA) is currently in negotiations with the City of Woodland, which may impact future salary and benefits.

The City of Woodland hires only U.S. citizens and individuals lawfully authorized to work in the U.S.  The City of Woodland is an Equal Opportunity Employer

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 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.

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.
 

San José Clean Energy, or SJCE, is San José's local, not-for-profit electricity supplier operated by the City of San José's Energy Department. Since 2019, our dedicated and motivated team has provided clean energy for residents and businesses at competitive rates, while also offering community programs, local benefits, and increased transparency and accessibility.

San José Clean Energy serves more than 350,000 customers and has a peak load of almost 1 GW. SJCE is responsible for purchasing over 4,500 GWh of electricity annually and has an annual operating budget of over $300 million. Serving our community with respect and integrity is at the core of what we do. Joining our team means that you will be making a big impact and in the forefront in the fight against climate change. SJCE plays an important role in meeting San José's ambitious goal to be carbon neutral by 2030 and in implementing Climate Smart San José, the City's climate action plan.

SJCE centers equity in its drive to provide clean, renewable energy at competitive rates and provide local benefits. Since inception, SJCE has sprinted ahead to now provide 60% renewable and 95% carbon-free energy in our base product and has contracted to add over 1GW of new solar, wind, and battery storage to the grid. SJCE's low carbon energy supply is foundational as we work to meet the electrification goals outlined in Climate Smart San José. For more information about San José Clean Energy, please visit: www.sanjosecleanenergy.org .

This department is seeking to fill one (1) full-time Power Resources Specialist I/II position to support the Risk Management and Contracts Administration Division.

This position is part of an exciting fast-paced team responsible for mitigating risks and managing a power portfolio comprised of hundreds of megawatts of renewable energy projects.

The selected candidate will have the following duties and responsibilities:

• Evaluate, review, and validate the accuracy of market positions and risk metrics such as mark-to-market, value at risk, gross margin at risk.
• Perform quantitative and analytical data modeling to quantify risks, evaluate risk reduction strategies, aid strategic/ operational decision making and provide insights.
• Update, manage and validate accuracy of Power BI business intelligence dashboards related to energy risk management such as risk limits, forward prices, collateral.
• Execute monthly and ad-hoc data reporting and quantitative modeling tasks.
• Validate and forecast collateral calls from counterparties and the CAISO and verify accuracy of collateral records.
• Collaborate with different divisions and IT department to support the build and implementation of data repository.
• Provide analytical support for power purchase and sale agreements and power supply audits.
• Compile reports, summaries, and presentations to communicate findings to management.
• Understand SJCE Risk Management Policy and Regulations and manage reviews and amendments.
• Support the development of middle office procedures.
• Monitor and evaluate energy market risks and market events. Develop and share knowledge of energy industry trends, new developments, and emerging risks.
• Perform other duties that may be assigned from time to time.

The ideal candidate is a highly motivated individual with strong analytical, quantitative, and problem-solving skills. The candidate should have effective communication skills, show attention to detail, and be able to work independently. Candidates that are highly collaborative with colleagues and outside stakeholders are ideal.

The Risk Management and Contracts Administration Division is responsible for providing independent oversight of the risks in transacting for energy products and services as well as ensuring compliance with adopted risk management policies and procedures. This unit provides strategic support to facilitate the development and execution of various contracts, and also manages the contracts administration and settlements function.

Competencies

The ideal candidate will possess the following competencies, as demonstrated in past and current employment history. Desirable competencies for this position include:

• Job Expertise - Demonstrates knowledge of applicable professional/technical principles and practices, Citywide and departmental procedures/policies and federal and state rules and regulations.
• Analytical Thinking - Approaches a problem or situation by using a logical, systematic, sequential approach.
• Initiative - Exhibits resourceful behaviors toward meeting job objectives; anticipates problems, is proactive, and avoids difficulties by planning ahead; displays willingness to assume extra responsibility and challenges; pursues continuing education opportunities that promotes job performance.
• Problem Solving - Approaches a situation or problem by defining the problem or issue; determines the significance of problem; collects information; uses logic and intuition to arrive at decisions or solutions to problems that achieve the desired outcome.
• Teamwork & Interpersonal Skills - Develops effective relationships with co-workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.
• Multi-Tasking - Can handle multiple projects and responsibilities simultaneously; has handled a wide variety of assignments in past and/or current position(s).
• Computer Skills - Experienced with common business computer applications including but not limited to: MS Outlook, MS Word, MS PowerPoint, MS Access, MS Excel, as well as data visualization and modeling tools.
• Communication Skills - Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills and displays openness to other people's ideas and thoughts. Demonstrates basic knowledge of negotiation skills.

Salary Information:

Power Resources Specialist I is $99,503.04 - $121,255.68.

Power Resources Specialist II is $108,282.72-$131,913.60.

This range includes an approximate five (5%) ongoing on-pensionable pay. Actual pay shall be determined by the candidate's qualifications and experience.

Hours: Casual non-benefited employees are limited to working no more than twenty-five (25) hours per week and no more than 900 hours in a fiscal year (July 1-June 30). Varying shifts are available including Monday through Friday between 8:30 a.m. and 8 p.m. and Saturdays and Sundays from 8 a.m. to 6 p.m.

Under general supervision, individuals assigned to this classification assist the organization to develop and design reports, websites, social media collateral and other marketing and presentation materials. This classification focuses on the development of written and graphic representation for division or department materials. Individuals in this classification are primarily focused on enhancing the Division’s social media presence, developing all written material, performing administrative tasks, attending fairs and events to promote Recreation Services programs; and perform/ related work as required.

This position is characterized by developing new and innovative marketing collateral with limited structure or routine work. Work assignments are performed in collaboration with various divisions and levels of staff, independently, with responsibility for following through on development. Contacts are regularly made both internally and externally at all levels of the organization involving tact, discretion, good listening and customer service skills. The position requires creative ability, knowledge of how to generate graphics using The Adobe Suite, Canva, Microsoft Publisher, Word and Excel and the ability to exercise a reasonable degree of independent judgment. This classification assists with development and implementation of standards for consistency in materials, written and posted on the internet. Additionally, the position requires good written communication skills, public relations, interpersonal, and problem-solving skills and abilities. The Marketing Associate receives direction from program supervisors and management staff.

Essential Job Functions

(May include, but are not limited to, the following):

• Design and produce effective collateral for digital and print to promote programs, events and services
• Design and produce graphics materials using computer-based and traditional methods to meet organizational standards and deadlines
• Produce highly creative work within an established organizational style
• Edit electronic newsletter articles and blurbs, program descriptions for activity guide/fliers/online descriptions and social media posts
• Follow all City standards related to branding and writing (Associated Press style), or as otherwise directed, and meet deadlines
• Develop written content and edit for brochures, reports, logos and other marketing and presentation materials
• Consult with City staff and provide technical coaching and training to colleagues
• Participate in the planning, development and production of written and graphics materials
• Assist staff in the development of presentations using PowerPoint and other presentation software
• Create, develop and monitor posts and comments for social media accounts
• Represent the division at community outreach events (such as fairs, special events, etc.) by promoting community services programs and services
• Perform other duties as required

WORKING CONDITIONS
Position is required to work on the Community Center campus and may not work from home. Position requires prolonged sitting, standing, walking, reaching, twisting, turning, kneeling, bending, squatting and stooping in the performance of daily activities. The position also requires grasping, repetitive hand movement and fine coordination when using a computer keyboard. Additionally, the position requires near and far vision when reading and using a computer. Acute hearing is required when providing phone and personal service. The need to lift, push and pull files, paper and documents weighing up to 25 pounds also is required. Some of these requirements may be accommodated for otherwise qualified individuals requiring and requesting such accommodations.

Minimum Qualifications

Education and Experience:
The minimum qualifications for education and experience can be met in the following way:

• A bachelor's degree from an accredited college or university in marketing, communications, graphic arts or a closely related field; AND
• One year of related work experience that provides the required knowledge and abilities.

Knowledge of:

• Computer programs utilized in the production of marketing collateral; specifically, the Adobe Creative Suite, Canva, Microsoft Publisher, Word, Excel and PowerPoint
• Dynamics of development of social media sites
• Basic principles of graphic design
• The Associated Press writing style

Ability to:

• Follow general instructions, directions and procedures;
• Accomplish assigned work and administrative tasks working independently or with a minimum of supervision;
• Process information and data in a relevant manner to reach reasonable conclusions and make practical decisions;
• Demonstrate flexibility of style relative to specific job assignments, working environments, shift schedules and hours;
• Interact well as part of a team;
• Perform relatively complex computer applications;
• Communicate with high proficiency in both written and spoken English;
• Use independent reasoning to solve programs of moderate complexity:
• Perform the essential functions of this position.

Skill in:

• Utilizing a personal computer and software relevant to this classification·
• Working effectively with others, as a contributing group or team member on multiple assignments
• Establishing and maintaining effective work relationships with a variety of people, including City staff, the public and outside consultants;
• Prioritize assignments and workload appropriately and responding to multiple deadlines
• Perform other duties as required

Licenses/Certifications: Possession and continued maintenance of a valid class C CA driver's license and a safe driving record.
 
DESIRABLE QUALIFICATIONS

• Previous experience in writing marketing collateral, graphic design and social media collateral

Application Process

If you are interested in this opportunity, please submit a completed application and responses to the supplemental questions to the Department of Human Resources.

City application forms, completed in full and responses to the supplemental questions are required. Candidates are asked to fully describe any training, education, experience and/or skills relevant to this position. Resumes are not accepted in lieu of the application, please do not indicate "see resume." Electronic applications may be submitted online through the City's employment page; go to Sunnyvale.ca.gov, Search: Jobs. Late or incomplete applications will also not be accepted. Please submit application materials as soon as possible to be considered for this position as this job posting may close without notice. 
 

Please click on the Job PDF to view the announcement.

Please click on the Job PDF to view the announcement.

Please click the Job PDF button below to view the full job announcement brochure.