Search Jobs

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Perform SQL and PL/SQL tuning and performance monitoring. 

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

Provide technical support to application developers and database users. 

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

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

Provide a strategic database direction for the organization.

MINIMUM QUALIFICATIONS

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

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

KNOWLEDGE AND ABILITIES 

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

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

SPECIAL REQUIREMENTS

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

Level III: This job has no supervisory responsibilities. 

Level IV: This job may have supervisory responsibilities.

WORK ENVIRONMENT

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

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

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.

The City of Sausalito Invites Applications for the Position of

POLICE COMMUNITY SERVICE and EVIDENCE TECHNICIAN

Open Until Filled - First Screening Will Occur on May 20, 2024

The City of Sausalito Police Department is seeking a dedicated and detail-oriented individual to join our team as a Police Community Service and Evidence Technician. This vital role supports our mission to maintain public safety and maintaining evidence, as well as enforcement of parking rules and regulations

This is a journey-level non-sworn classification in the Police Department that performs the full range of duties related property and evidence as well as assists the patrol officers with minor evidence collection, reporting writing and responding to related calls for service as needed to effectively provide police services. Incumbents are expected to work independently and exercise judgment and initiative.

StopWaste is hiring an Energy Council Program Services Specialist to work on Bay Area Regional Energy Network (BayREN) programs. The position will conduct community outreach and engage with stakeholders to make energy upgrades and electrify multifamily and single family buildings in Alameda County and the larger Bay Area. It will also work on growing and strengthening the clean energy workforce to help achieve energy and climate goals. The ideal candidate will have deep experience engaging and developing relationships with community partners. The position may be filled at the Program Services Specialist I, II, or Senior role depending on the applicant pool and the discretion of StopWaste staff. 

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

The City of Berkeley invites applications for the position of Housing Inspector II (Certified)! In this role, you will perform skilled inspection work with City residential housing inspection programs. You will independently perform the full scope of work in the investigation, reporting and follow-up of housing deficiencies to gain compliance with housing, building, zoning, fire, mechanical, plumbing, electrical, and related codes and regulations.

Assignments are varied and generally require close interaction with the public, providing information and interpretation of applicable ordinances, codes and regulations. We'll expect you to exercise considerable independence and discretion in conducting inspections, resolving complaints and enforcing inspection results.

MINIMUM QUALIFICATIONS

A typical way of gaining the knowledge, skills, and abilities for this position is:

Equivalent to graduation from high school and at least two years of full-time experience equivalent to Housing Inspector or Building Inspector or Code Enforcement Inspector for a public agency. 

Must possess:

• An International Code Council (ICC) OR California (CA) certification in Residential Building or Housing Inspection or in Code Enforcement; and
• ICC or CA Residential or Commercial Electrical Inspector certification and ICC or CA Residential or Commercial Plumbing Inspector certification, or equivalent ICC or CA Legacy Certification for either Combination Inspector or Combination Dwelling Inspector.

Other requirements: Must be able to travel to various locations within and outside the City of Berkeley to meet the program needs and to fulfill the job responsibilities. When driving on City business, incumbent is required to maintain a valid California driver's license as well as a satisfactory driving record.

In addition to the qualifications above, the ideal candidate will have effective and courteous communication skills in order to discuss housing violations, violation remedy and necessary inspections and fees and participate in depositions and court hearings as requested. The ideal candidate can support a work environment that highlights efficiency and team collaboration in a professional and friendly atmosphere for the inspectors and administrative staff.

APPLICATION PROCESS

For first consideration, please apply by May 13, 2024.

Applicants must submit a completed application and responses to the supplemental questionnaire. Please note that resumes are not a substitute for a completed application.

Applications are available in alternative formats (audio-format, braille, large print, electronic text, etc.) upon request to ada@berkeleyca.gov. Please allow 10 days for production of the material in an alternative format.

The Marysville Police Department is recruiting for the position of Public Safety Dispatcher. 

We are seeking energetic and outstanding individuals to join our team.  Ideal candidates are committed to working with their community in total partnership as we work together to improve the quality of life for everyone who works, lives and plays in our city. Public Safety Dispatchers are tasked with dispatching first responders including police, fire and medical services.

About the Highway Program Deputy Director

The Highway Program Deputy Director, reporting to the Chief of Engineering and Program Delivery, manages a diverse and talented team of seasoned staff who is well-versed on the delivery of capital projects related to the State highway system and other roadways in the county. This position is responsible for directing and leading collaboration on planning, design development (including technical analysis in support of preliminary engineering and final design), project-related right-of-way activities (in coordination with VTA Real Estate), construction management and close out, overall program/project management (including scopes, costs, schedules and quality of work), management of staff resources (both VTA and consultant), coordination with project stakeholders within VTA and beyond (e.g., local agencies, Caltrans, federal agencies, resources agencies, utilities, etc.), and community and other outreach (working with VTA public information and government affairs staff).
 

The City of Thousand Oaks has an exciting opportunity for a Code Compliance Supervisor in the Community Development Department! We are seeking a highly motivated and results-oriented individual to supervise and lead staff in the enforcement of municipal code compliance, investigation techniques and practices, and interpretation of regulations.

The Code Compliance Supervisor must be highly knowledgeable in code compliance programs and federal, state, and local policies, laws, and regulations.

Primary responsibilities:

• Plans, organizes, supervises, and evaluates code compliance program activities and operations within the Community Development Department; develops, implements, and monitors work plans to achieve goals and objectives;
• Provides leadership and works with staff to ensure a high-performance, customer service-oriented work environment through selection, training, and day-to-day supervision practices that support achieving the Department’s and the City’s mission, objectives, and values;
• Recommends and implements goals, objectives, policies, and procedures for providing code compliance programs;
• Performs the more technical and complex tasks of the work unit including the most difficult and complex municipal code violations for residential and/or commercial buildings to ensure compliance with City, state and federal regulations governing code compliance;
• Keeps informed of changes and new legislation pertaining to zoning compliance and regulations affecting work of the department, ensuring that appropriate staff is informed and current.

Join the City of Berkeley's Planning and Development Department in its effort to protect the health, safety, and welfare of citizens by enforcing building codes and regulations. As a Certified Building Inspector I or II, you will perform skilled inspection work in the enforcement of building, mechanical, plumbing, electrical, zoning and related codes and regulations that govern new building and housing construction, additions, alterations, repairs and use of existing buildings. This work includes resolving problems and complaints to final resolution.

These classifications differ in that the Building Inspector I works under closer supervision and performs less complex inspection work than the Building Inspector II.

MINIMUM QUALIFICATIONS

A typical way of gaining the knowledge, skills, and abilities is:
Equivalent to graduation from high school and experience as specified below.

• Building Inspector I:
  • One year of full-time experience as a building inspector with a public agency, OR
  • Four years of full-time experience as a journey level carpenter, electrician, plumber, building plans examiner, public works inspector or permit specialist, OR
  • Three years of full-time experience in the building construction field as a licensed general, plumbing, electrical or mechanical contractor, OR
  • Completion of a two year AA program or equivalent in construction technology or a related field and a minimum of four ICC certificates including building, plumbing, mechanical and electrical.
• Building Inspector II:
  • Three years of full time experience in building inspection work with a public agency.

Other requirements include possession of a valid International Code Council (ICC) Commercial and Residential Building Inspector Certificate or equivalent. In addition, Building Inspector II requires possession of a valid ICC Commercial and Residential Electrical Inspector Certification or equivalent. Equivalency shall be determined by the building official in accordance with state law. Required certifications must be maintained as a condition of employment.

Incumbents in both positions must be able to travel to various locations within and outside the City of Berkeley to meet the program needs and to fulfill the job responsibilities. When driving on City business, maintenance of a valid California driver's license and satisfactory driving record is required.