Search Jobs

Highlights of the position:

• Join an innovative and collaborative Information Technology team
• Excellent learning opportunity for advanced computer and networking troubleshooting skills
• Ability to participate in the City’s 5 Year Information Technology Strategic Plan

The Finance Department has an opportunity to staff a Senior Info Technology Technician.  We seek a skilled individual with the competence and experience to address IT challenges confidently and professionally. The successful candidate should have demonstrated skills in the areas of customer focus, communication, teamwork, excellent judgment, and the ability to meet deadlines.

Primary Responsibilities

• Responds to inquiries regarding PC systems and programs at user sites throughout the City
• Troubleshoots hardware and software problems and recommends hardware, software, and configuration changes for City-wide implementation
• Installs desktop/laptop equipment and software; customizes installed software to specific requirements of the user department; reconfigures software to correct problems or conflicts between applications and hardware
• Provide desktop support and troubleshooting to City staff
• Serves as local area network (LAN) administrator; ensures LAN performance, maintains security, creates new users, and installs related hardware
• Installs virus signature files on servers and workstations for use with an anti-virus system; responds to and troubleshoots virus invasions of the City network

Under the administrative direction of the Ports Finance and Administration Division, the Information Systems (IS) Director plans, directs, and coordinates information system operations and activities for the Port of San Francisco. This includes overseeing system design, development, and implementation, as well as coordinating data and information systems across departments. The IS Director is responsible for the operation and maintenance of these systems.

The Port is in the process of replacing several business-critical systems in the next five years, including real estate and work order management systems.  The IS Director will lead these efforts, requiring the creation of a systems strategic plan that aligns different systems with the Port’s primary business needs while integrating with citywide financial and payroll systems.  This plan will involve collaborating with business divisions to identify and prioritize system requirements, such as vacancy, profit and loss, and common area expense allocation reports for the real estate portfolio, as well as berthing management systems for various visiting ships and boats.

The IS Director will also identify necessary business division process changes and establish short- and long-term deliverables. This position oversees two distinct functions: an applications group responsible for implementing and maintaining technology applications tailored to the Port’s needs, and an infrastructure group that ensures a stable and secure environment for desktop and mobile devices.

The essential duties of IS Director include the following:

• Develops and implements the strategic systems plan for the Port.
• Leads the IS division, building capacity and supporting the infrastructure and business applications teams.
• Plans and directs the day-to-day information systems activities for the Port, including application and infrastructure support, desktop administration and IS Help Desk support services.
• Performs continuous evaluation and assessment of all activities, providing timely reports to upper management. 
• Develops and manages the IS budget, including project management and hardware/software procurement.
• Develops and manages the Port’s technology policies, standards, and strategy, ensuring alignment with citywide technology goals and standards.
• Oversees devices and information management, security and compliance, risk management and response, and technology governance.
• Supervises, evaluates, trains, and coach staff and consultants in the performance of their assigned duties, adhering to departmental and city and county standards, policies, and procedures.
• Serves as liaison and representative of the Port with various City and County staff, policy-making officials, and officials of external agencies. 

The City of Livermore is currently accepting applications for the position of Water Resources Mechanic I/II.  There are 2 vacancies can be filled at the I or II level. Apply online at www.LivermoreCA.gov!

WR MECHANIC I - $6,757.36 - $8,199.65 MONTHLY
WR MECHANIC II - $7,621.28 - $9,249.76 MONTHLY

Water Resources Mechanics perform a wide range of tasks involving mechanical maintenance and repairs of pumps, plumbing systems, electric motors, compressors, piping, boilers, underground infrastructure, facilities and buildings, carpentry, HVAC systems, mechanical drives, gear boxes, blowers, collectors, belt filter presses, and chemical feed systems. The work is done at the Water Reclamation Plant, located at 101 West Jack London Boulevard in Livermore.

A Water Resources Mechanic I performs a range of tasks requiring journey level mechanical ability and aptitude. Work assignments are performed according to established rules and procedures. Independent judgment is required and is supported at regular intervals by supervisory review and direction. A Water Resources Mechanic II is distinguished from the WR Mechanic I by the possession of advanced journey level mechanical ability and aptitude and is responsible for solving more difficult technical problems.

The City of Redwood City is recruiting for a dynamic individual to fill the position of BUILDING INSPECTOR.

WHY JOIN THE REDWOOD CITY TEAM?

We offer a wide range of meaningful career opportunities with potential for growth, training and development, competitive salaries, flexible work schedules, paid time off, and robust benefits. The Redwood City team is guided by the core values of excellence, integrity, service, collaboration, inclusion and innovation.  Inherent in these values is a great organizational culture based on trust, strong and supportive leadership, respect, risk-taking, empowerment, and effective communication.

ABOUT THE POSITION

This is an excellent opportunity for an individual who possesses both the interpersonal skills and technical expertise needed to perform a range of moderately difficult combination inspections (building, electrical, plumbing and mechanical) of a variety of residences, commercial and industrial buildings. Redwood City currently has issued several large projects under construction containing several underground parking garages, podium concrete decks and large multi residential high-rise structures above. This opportunity will expand your skills in all phases of large commercial projects to custom residential projects through Redwood City.  To review the projects click here:  current-projects.

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.

THE OPPORTUNITY

The City of Pacifica is recruiting for a Public Works Superintendent within the Department of Public Works. Under direction of the Field Services Manager, the incumbents will be responsible for the field services of the Public Works Department. They will plan, organize, and direct the work of field personnel and perform related work as required. The incumbents will be assigned to oversee various subdivisions such as Streets, Streams, Storm Drains, Street Lighting, and Motor Pool programs.

THE DEPARTMENT

The Public Works Department is responsible for maintaining and repairing the City’s infrastructure and wastewater treatment operations in an efficient and cost-effective manner while providing a high level of customer service and a safe work environment for city employees. The Department maintains parks, playing fields and medians and keeps streets and trails clean and well-maintained. The Department also coordinates the tree program, cleans beaches and coordinates the City Beautification program.

The Public Works Department is organized into three divisions including Wastewater Treatment Operations, Field Services and Engineering. The Wastewater Treatment Operations includes the operation of the Calera Creek water treatment plant and management of the collection system. Field Services oversees the maintenance of city streets, parks, trees, vehicles and public facilities. The Engineering Division manages public infrastructure projects, transportation planning and maintenance and repair of the City’s infrastructure. The Public Works Department is supported by 56 full-time staff and an annual operating budget of $4.6 million, along with a FY2023-2028 CIP appropriation of $ 8.6 million. 

At the City of Pacifica, we are an equal opportunity employer and value diversity. All aspects of employment will be based on merit, competence, performance, and business needs. To us, equal opportunity employment is not just about compliance, it’s about who you are, how you can help our City and who you want to be. We are committed to creating an inclusive environment for all employees and community members. 

If interested, we invite you to explore this opportunity with us.  Please note, this recruitment closes on Friday, June 7, 2024 at 12:00 PM PST so apply today!

THE POSITION

This is a full-time, management position that requires significant independence, initiative, and discretion within established guidelines.  Duties may include but are not limited to the following:

• Plan, organize and direct the work of others involved in public works, operations, including  stream maintenance, tree management and maintenance including street light maintenance, maintenance of the Community Pier and other activities as required.
• Plan, organize and direct the work of others involved in public works operations.
• Assist in the recruitment and placement of new employees.
• Attend public meetings and functions as needed.
• Establish Division goals and maintain exceptional working relationships.

Please refer to attached job description for additional information.

Equipment Mechanic  or Supervising Equipment Mechanic

$39.53-$50.46 per hour (Equipment Mechanic)
$45.46-$58.02 per hour (Supervising Equipment Mechanic)

Closing Date: June 9, 2024 (11:59 p.m.)
Oral Board:  Week of June 17, 2024

This recruitment will be filled at the Equipment Mechanic or Supervising Equipment Mechanic. The salary will depend on the candidate's qualifications.

Are you a skilled mechanic who thrives in a fast-paced environment where no two days are the same? The Town of Los Gatos is recruiting for an Equipment Mechanic or Supervising Equipment Mechanic to join the Parks and Public Works Department. This is a great career opportunity for an independent, highly motivated, customer service-oriented, organized individual to:

• Oversee the maintenance and repair of about 100 vehicles, including emergency response vehicles, and a variety of equipment (e.g., generators, trailers, boom trucks, compressors, wheel loaders, street sweepers, etc.).
• Coordinate regular and preventative maintenance on all vehicles and equipment.
• Diagnose mechanical tissues and perform or coordinate the necessary repairs to ensure vehicles are in optimal working condition and meet proper safety protocols.
• Prioritize and schedule maintenance tasks to minimize downtime and ensure fleet readiness.
• Coordinate with vendors and suppliers to procure parts and equipment.
• Oversee the upfitting process for first responder vehicles, ensuring they are equipped with the necessary tools and technology to support emergency operations.
• Support maintenance of the Department's asset management software to track vehicle and equipment maintenance schedules and inventory.
• Provide excellent customer service to internal stakeholders, promptly responding to repair requests and informing them of maintenance progress. 
• Supervise a part-time mechanic.

For a complete list of duties, see the E Equipment Mechanic or Supervising Equipment Mechanic job classification.

 

Final Filing Date:  First review of applications will be on June 7, 2024. NCPA reserves the right to close this posting once a sufficient number of applications have been received.
 

Under the direction of the IS Operations & Support Assistant Manager, the Database Administrator architects, tests, implements, maintains, and documents Agency databases. The database administrator collaborates closely with IS development and Agency operations personnel to provide backend database solutions for custom applications, including real-time, scheduling, and settlement programs. The database administrator troubleshoots and provides solutions for database problems.

Level III
This classification supports and maintains the Agency’s database infrastructure and related applications. Administers all database objects, including but not limited to schemas, tables, clusters, indexes, and views. Performs database re-organizations as needed to improve performance. Performs impact analysis of changes to be made to database objects before implementing significant schema changes. Ensures security for all databases by creating roles and associated privileges. Controls and monitors user access to databases. This is a journey-level position and is given minimal direction in job duties and responsibilities.  

Level IV
Architects and designs the Agency’s database infrastructure and ensures the highest levels of availability. Leads database projects to establish new database architectures. Oversees upgrades and implementations of new databases or related software.   Position can perform all lower level requirements and works independently with very little direction May be called upon to provide reports or present to the Agency’s Information Technology Committee. May direct the work of lower classifications.     

ESSENTIAL DUTIES AND RESPONSIBILITIES
This position requires that the incumbent reports for work on time and maintains satisfactory attendance in accordance with Agency policy; Ensures work responsibilities are covered when absent; Arrives to meetings and appointments on time; Performs special assignments for the Assistant Manager, Information Services or others as assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Responsibilities:
Design, create and maintain all Oracle databases required for development, testing, and production usage. 

Install, configure, upgrade, and troubleshoot Database server software for both stand-alone instances and Real Application Clusters (RAC). Includes patching both Oracle and Windows. 

Administer all database objects, including schemas, tables, clusters, indexes, views, sequences, constraints, packages, and procedures. This includes creating primary database storage structures (tablespaces) and primary objects (tables, views, indexes). Manage the sharing of resources between applications. 

Troubleshoot problems regarding the databases, servers, applications and development tools. Open technical support cases with support as needed and serve as primary support contact for NCPA. 

Perform capacity planning for all databases. Work closely with IS storage and system administration staff to plan and allocate database system storage. 

Experienced with creating, managing, and maintaining data warehouse technologies.

Perform ongoing monitoring and tuning of all database instances and Windows servers to optimize database performance and reliability. 

Plan and implement backup and recovery of Agency databases. Maintain remote standby databases using archive logs.

Implement and enforce security for all of the Databases through creating and maintaining users and roles, and assigning privileges. Control and monitor user access to the database. 

Perform database re-organizations as required to improve performance and ensure maximum uptime of the database. Modify the database structure from information given by application developers. Gather statistics, create indexes, create or expand tablespaces as needed. 

Perform SQL and PL/SQL tuning and performance monitoring. 

Set up and maintain documentation and standards for database practices and procedures. 

Provide technical support to application developers and database users. 

Perform impact analysis of changes to be made to database objects. Approve and implement/oversee significant schema changes and changes to database design. 

Provide support during non-standard hours (on an as-needed basis, on-call 24x7x365). 

Provide a strategic database direction for the organization.

MINIMUM QUALIFICATIONS

Level III:
Education and/or Experience
A bachelor’s degree from an accredited four-year college or university in Computer Science, Management Information Systems, Engineering, or a related field and five or more years of related experience and/or training, or an equivalent combination of education and experience.

Level IV: 
Education and/or Experience 
A bachelor’s degree from an accredited four-year college or university in Computer Science, Management Information Systems, Engineering, or a related field and eight or more years of related experience and/or training, or an equivalent combination of education and experience.

KNOWLEDGE AND ABILITIES 

Knowledge:
Knowledge of Oracle database; Oracle Recovery Manager (RMAN), Real Application Clusters (RAC); Oracle Automatic Storage Management (ASM), SQL, PL/SQL; Microsoft SQL Server; Windows; networking; virtual machines; batch/cmd scripting; PowerShell, SQL*Plus; Toad, GIT; physical database design; relational database theory; disaster recovery; back-up and recovery, relational database theory; Windows and Linux system administration; the Oracle optimizer and execution plans; troubleshooting and debugging, networking (TCP/IP), database security.

Abilities:
Ability to write complex programs and develop detailed program specifications; Ability to analyze data and situations, reason logically and creatively, identify problems, draw valid conclusions, and develop effective solutions; Ability to apply creative thinking in the design and development of methods of processing data with electronic computers; Ability to establish and maintain cooperative working relationships with those contacted in the course of the work; Ability to communicate effectively verbally and in writing, and prepare effective reports.

SPECIAL REQUIREMENTS

Valid California Driver's License and insurance as occasional travel may be required. 
While performing the duties of this job, the employee is regularly required to sit. The employee is occasionally required to stand and walk. Occasionally, the employee may be required to perform simple grasping and fine manipulation, use telephone, write or use a keyboard to communicate, crouch, crawl, reach and lift equipment up to 40 lbs. 

Level III: This job has no supervisory responsibilities. 

Level IV: This job may have supervisory responsibilities.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually moderate.

All employees are responsible for contributing to an inclusive, safe, and secure work environment that values diverse cultures, perspectives, and experiences and is free from discrimination.
 

The position of Administrative Analyst is a fully qualified journey-level professional classification. Administrative Analyst is distinguished from Management Analyst in that the Management Analyst has a higher level of managerial, budgetary and program administration responsibility. The current vacancy is in the Information Technology Department; however, the eligibility list established from this recruitment may also be used to fill future Administrative Analyst vacancies in other Departments throughout the City.

This position is assigned in the Administration, Fiscal and Performance Management Division, reporting to the IT Admin, Fiscal and Performance Manager. The incumbent will perform professional analysis, administrative support, and conduct research including statistical analysis of the results.  They will be responsible to assist with budget development and management, track and oversee the purchasing process, and manage the department's equipment replacement schedules as well as miscellaneous other management duties as assigned.

The City of Sunnyvale offers:

• provides comprehensive medical, dental, and vision benefits;
• contributes 4% of the 7% employee contribution to CalPERS for classic members, and
• provides retiree medical benefits.

The City of Sunnyvale provides an excellent benefits package.  A complete application packet will consist of a City of Sunnyvale employment application and responses to the required supplemental questions.  The final filing date is June 3, 2024 at 5:00 pm or after receiving 100 qualified applicants, whichever is first.  For complete information regarding this opportunity, please go to Sunnyvale.ca.gov and click jobs.

Salary: $44.27 - $56.50 Hourly