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.
 

For more information and to apply, please visit:

https://www.governmentjobs.com/careers/Cupertino

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.

For more information and to apply, please visit:

https://www.governmentjobs.com/careers/Cupertino

The position will receive a 2.5% base salary increase in July 2024.

THE POSITION

The City Attorney's Office seeks a well-qualified, motivated attorney for the position of Assistant City Attorney. This is an at-will position that serves as part of the City's executive management team. 

The Assistant City Attorney will provide legal advice, counsel, and representation to the City in areas including, but not limited to, land use, real estate, housing, and environmental law. Duties include drafting and reviewing contracts, ordinances, resolutions, deeds, permits, licenses, and other legal documents, conducting research, interpreting and updating the City Municipal Code, and providing advice to City staff. 

The Assistant City Attorney will provide counsel to the Planning Commission, the Community Development Department, other City departments, and assist with the enforcement of City Municipal Code. The Assistant City Attorney receives general direction and supervision from the City Attorney and may provide oversight and supervision to support staff. The Assistant City Attorney will oversee the work of the City Attorney's Office in the absence of the City Attorney. 

To view the full job description, click here.

THE IDEAL CANDIDATE

The ideal candidate will have a broad base of knowledge and experience in a variety of areas of municipal law such as the Brown Act, Political Reform Act, Public Records Act, contracts, personnel matters, public safety, public works, and advisory and litigation services. Extensive expertise in land use, Planning and Zoning, the Subdivision Map Act, CEQA, and Housing is especially desirable. However, applicants without land use expertise are also encouraged to apply.

The ideal candidate will have a high degree of professionalism, careful attention to detail, strong work ethic, and excellent legal judgment. The successful candidate will join a City Attorney’s Office that values collaboration, integrity, witty humor, efficiency, and exemplary customer service.  

THE DEPARTMENT

The City Attorney's Office consists of the City Attorney, Assistant City Attorney, and Department Administrative Specialist and has a departmental budget of, $1,118,400. The City Attorney's Office advises the Rocklin City Council, City Boards and Commissions, and City Departments on the legal propriety of proposed municipal actions. The City Attorney's Office also prepares and/or reviews all ordinances, resolutions. contracts and other documents and represents the City in civil litigation and acts as liaison to outside special counsel.

MINIMUM QUALIFICATIONS

Graduation from a law school accredited by the American Bar Association with a Juris Doctorate degree;

AND

Five (5) years of increasingly responsible experience as an attorney in the practice of civil or municipal law.

Licenses and Certificates:

• Active membership, in good standing, in the State Bar of California.
• A valid California Class C driver license or higher is required at the time of appointment. Individuals who do not meet this requirement due to a disability will be reviewed on a case-by-case basis.

THE POSITION
Join us this summer season for a fun and engaging employment opportunity as a Senior Lifeguard to support the City of Rocklin's upcoming aquatic program and activities taking place at the Rocklin High School pool.

This class is distinguished from the Lifeguard by overall program responsibilities, training and experience. Senior Lifeguards serve as the Lead Lifeguard in providing technical and functional direction over Lifeguards.

Senior Lifeguards play a critical role in ensuring courteous and professional service to all pool attendees, including:

• Providing surveillance of swimmers and guests during City run swim hours. 
• Enforcing rules and regulation of City run aquatic facilities.
• Responding to emergency situations at assigned facilities. Administering and coordinating emergency first aid, as necessary.
• Providing superior customer service to all guests by assisting in a polite and expedient manner.
• Assisting the Parks and Recreation Supervisor with overseeing the safe and proper operation of assigned pool lifeguards. 
• Maintains order with disruptive patrons and exercises crowd control where warranted; refers escalated issues to the Parks and Recreation Supervisor.
• May be assigned other related duties. 

MINIMUM QUALIFICATIONS
One season of experience performing duties similar to that of a Lifeguard. Senior Lifeguard experience is highly desirable.

Must be at least 18 years of age at time of appointment.

REQUIRED LICENSES AND CERTIFICATES

• Possession of a current American Red Cross Lifeguard certificate, or equivalent, by date of appointment.
• Possession of a current American Red Cross CPR/AED certificate, or equivalent, by date of appointment. (Obtained in ARC Lifeguard Certification)
• Possession of a current American Red Cross First Aid certificate, or equivalent, by date of appointment. (Obtained in ARC Lifeguard Certification)

If you do not currently possess the required American Red Cross Lifeguard certificate, or equivalent certificates, you may be eligible to attend a future certification training offered through the City of Rocklin, as a condition of employment. This offering will be City paid and at no cost to the conditional employee.

ADDITIONAL INFORMATION

The following link provides a list of upcoming American Red Cross Lifeguard trainings and associated costs: American Red Cross - Lifeguard Training - Sunrise Recreation and Park District (sunriseparks.com) 

This is a temporary, part-time, at-will classification that assists the Parks and Recreation Department with City aquatic programs and activities. Temporary employees typically work less than twenty-eight (28) hours per week, not to exceed 990 hours in a fiscal year (July 1st through June 30th). The expected duration of the employment is six (6) months or fewer, dependent on the needs of the City. Anticipated scheduling needs are between the hours of 11:30am and 4:30pm.

Temporary employees are not eligible for benefits, excluding those benefits prescribed by law.

Please note: temporary part-time employment with the City of Rocklin is on an 'at-will' basis meaning the City or the employee may terminate employment at any time with or without cause. 

THE POSITION
Join us this summer season for a fun and engaging employment opportunity as a Lifeguard to support the City of Rocklin's upcoming aquatic program and activities taking place at the Rocklin High School pool. 

Lifeguards play a critical role in ensuring courteous and professional service to all pool attendees, including:

• Providing surveillance of swimmers and guests during City run swim hours. 
• Enforcing rules and regulation of City run aquatic facilities.
• Responding to emergency situations at assigned facilities. Administering and coordinating emergency first aid, as necessary.
• Providing superior customer service to all guests by assisting in a polite and expedient manner.
• May be assigned other related duties. 

MINIMUM QUALIFICATIONS
No experience required. Previous lifeguard experience is highly desirable.

Must be at least 16 years of age (under 18 years old must have valid workers' permit).

REQUIRED LICENSES AND CERTIFICATES

• Possession of a current American Red Cross Lifeguard certificate, or equivalent, by date of appointment.
• Possession of a current American Red Cross CPR/AED certificate, or equivalent, by date of appointment. (Obtained in ARC Lifeguard Certification)
• Possession of a current American Red Cross First Aid certificate, or equivalent, by date of appointment. (Obtained in ARC Lifeguard Certification)

If you do not currently possess the required American Red Cross Lifeguard certificate, or equivalent certificates, you may be eligible to attend a future certification training offered through the City of Rocklin, as a condition of employment. This offering will be City paid and at no cost to the conditional employee.

ADDITIONAL INFORMATION

The following link provides a list of upcoming American Red Cross Lifeguard trainings and associated costs: American Red Cross - Lifeguard Training - Sunrise Recreation and Park District (sunriseparks.com) 

This is a temporary, part-time, at-will classification that assists the Parks and Recreation Department with City aquatic programs and activities. Temporary employees typically work less than twenty-eight (28) hours per week, not to exceed 990 hours in a fiscal year (July 1st through June 30th). The expected duration of the employment is six (6) months or fewer, dependent on the needs of the City. Anticipated scheduling needs are between the hours of 11:30am and 4:30pm.

Temporary employees are not eligible for benefits, excluding those benefits prescribed by law.

Please note: temporary part-time employment with the City of Rocklin is on an 'at-will' basis meaning the City or the employee may terminate employment at any time with or without cause. 

The City of Dixon is preparing for the 2024 Aquatic season and is recruiting qualified Lifeguard/ Swim Instructor I/II applicants.

Under the direction of the Recreation Supervisor and Senior Lifeguard/Swim Instructor, Lifeguard/Swim Instructor performs a variety of duties to ensure the City of Dixon swimming pool is a safe and enjoyable aquatic facility. Supervises pool patrons, enforces pool rules, performs first aid and emergency rescues, instructs swim lessons, performs cashiering duties, leads recreational activities; performs related and other work as required.

Staff may be expected to work weekends and on fixed holidays.  Those who work on a City Holiday will earn 1 1/2 times their base hourly salary.

This position is subject to random controlled substance testing and/or breath alcohol testing.

Employment Processing: Those selected are subject to pre-employment drug testing and fingerprinting. In accordance with Federal law, an employee must provide proof of identity and proof that they may legally work in the United States.

Veteran's Preference Points: Veteran's Preference Points will be applied in accordance with the City's Personnel Rules & Regulations. A copy of the DD214 form must be filed at the time of application.

The City of Dixon is an EQUAL OPPORTUNITY EMPLOYER. 

Please do not reply to any emails coming from CalOpps at any time during this process as this correspondence does not come back to our agency.

The position is responsible for the performance of both the day-to-day power settlements among NCPA members, Western, California, and Federal electricity markets, local balancing authority area operators (CAISO, BANC, EIM), as well as settlement activities associated with NCPA Power Management’s Service Customers. Other responsibilities include tracking and meter data management validation duties, GHG (Greenhouse Gas) monitoring and analysis, analysis and testing associated with new CAISO market initiatives, and comprehensive analytic or technical studies, as required, including proceedings before state and federal regulatory agencies and public officials. This is a full journey-level position capable of performing all the duties and responsibilities of the Settlements Analyst I. Performs the full range of duties as assigned, receiving only occasional instruction, training, or assistance as new or unusual situations arise. Additionally, incumbents perform a variety of assigned complex technical and professional work in the areas of power accounts settlements, budgeting, systems development, and audit. Incumbents also provide technical analysis and assistance to staff, Members, contractual participants, and others, as required.

ESSENTIAL DUTIES AND RESPONSIBILITIES
This position requires that the incumbent report for work on time and maintain 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 essential functions.

Responsibilities:
Provides technical advice, functional instruction, and guidance to less experienced Power Settlement staff as needed. Trains new Power Settlements Analysts and cross trains as roles evolve. Recommends personnel actions. Prepares and presents training/tutorials on All Resources Bill, Pre-Bill process, Power Settlement processes overall, and various other topics, as needed, in person or via webinars (s) to NCPA Members and Project Participant staff.

Serves as subject matter expert, working with Information Services, on Power Settlements application requirements, such as All Resources Bill enhancements, and testing system enhancements in development.

Implements and operates complicated power settlements systems. Prepares complex analytical reports and supporting documentation.

Provides analysis, integration, and implementation of new energy market initiatives and/or customers/Scheduling Coordination accounts (e.g., ISO, Western Energy Imbalance Market (“EIM”), renewable generating resources, Community Choice Energy/Aggregators (“CCE”).

Monitors settlements associated with Renewable Energy Credits and acts as or provides support to NCPA’s Qualified Reporting Entity representative; registers credits on the Western Renewable Energy Generation Information System (“WREGIS”) or its successor.

Monitors settlements functions of Western capacity and energy allocations, market purchases and sales, Pool transmission activity, and other transactions as they occur; Prepares or reviews power settlement transactions for proper budget classification.

Conducts special studies requiring complex, voluminous, and detailed analysis of power costs and revenues. Recommends operational changes that provide better value to Members and Participants.

Coordinates and participates in the development, analysis, and monitoring of the Agency's power supply budgets. Acts as power settlements representative to other department managers and supervisors in regard to cost summary and budgetary reports.

Assists with the implementation of systems, policies, and procedures and special projects requiring highly technical study and analyses. Recommends changes or modifications to methods or systems as applicable.

Assists with formal budget and other presentations to upper management and the governing body.
Performs special assignments for the Power Settlements Supervisor or others as assigned, including preparation of testimony and exhibits for presentation before state and national regulatory proceedings.

MINIMUM QUALIFICATIONS

Education and/or Experience
Bachelor's degree (B. A.) from a four-year college or university with an emphasis on quantitative analysis, plus four (4) years of prior experience as a Power Settlements Analyst I or an equivalent combination of education and experience.

KNOWLEDGE AND ABILITIES 
Knowledge:
Knowledge of California Independent System Operator settlements procedures for tariff services and Metered Subsystem services; NCPA settlements procedures for scheduling coordinator services and the ten-member power pool; California Energy Imbalance Markets; NCPA’s Western (WAPA) contracts
California’s Green House Gas rules; CARB renewable energy credits; Knowledge of NCPA settlements procedures for scheduling coordinator services and the ten-member power pool.

Abilities:
Ability to retrieve detailed records and summary-level data from NCPA’s Oracle database systems through the use of Structured Query Language (“SQL”) statements in proprietary software (e.g., SAS, Toad, SQL Developer, Oracle Database Connection [“ODBC”]) and process through proprietary or open-source software programming applications (e.g., SAS, Visual Basic for Applications [“VBA”], R, Python, Excel workbooks); Ability to read, analyze, and interpret CAISO tariff, NCPA operating agreements, and contracts, standard industry power purchase agreements, technical procedures, and governmental regulations; Ability to write reports, business correspondence, and procedure manuals; Ability to present information effectively and respond to questions from groups of managers, clients, customers, and the general public; and the Ability to analyze and interpret settlement formulas expressed in summation notation.

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 frequently required to stand; sit; use hands to finger, handle, or feel; reach with hands and arms and talk or hear. The employee is occasionally required to walk; climb or balance; stoop, kneel, crouch, or crawl, and taste or smell. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and the ability to adjust focus.

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.