Utility Database Analyst

Utility Database Analyst

Salary

$132,942.00 - $161,591.00 Annually

Location

City of Alameda (Alameda Municipal Power), CA

Job Type

Full Time

Job Number

2026-7337-01

Department

Alameda Municipal Power

Opening Date

10/29/2026

Closing Date

11/12/2026 5:00 PM Pacific

FLSA

Exempt

Bargaining Unit

EUPA

FLSA Status

Exempt

• Description
• Benefits
• Questions

Nature of Position

About Alameda Municipal Power

In 1887, the City of Alameda invested $20,000 to install 13 streetlights and a 90-kilowatt generating station to power them. With that investment, the oldest public electric utility west of the Mississippi was established.

Today, Alameda Municipal Power (AMP) continues that legacy of public service. For more than 130 years, AMP has provided safe, reliable, and affordable electricity to the residents and businesses of Alameda. Throughout decades of change and transformation within the utility industry, AMP has remained locally governed and community focused, allowing decisions to be made with the best interests of the Alameda community in mind.

Local ownership enables AMP to reinvest in infrastructure, programs, and services that directly benefit our residents and strengthen the community. By maintaining local control, we can respond to evolving energy needs while delivering long-term value to the islands residents, businesses, and public institutions.

While much has changed since 1887, our commitment has remained constant: providing dependable electric service that our community can rely on. As the energy landscape continues to evolve, AMP will continue to thoughtfully invest in proven and emerging technologies that enhance reliability, improve customer service, support environmental goals, and manage costs responsibly.

About the Division; Utility Information Systems

The Utility Information Systems (UIS) Division provides the strategic leadership, governance, and oversight of Alameda Municipal Powers technology ecosystem, ensuring that utility systems align with AMPs mission of delivering safe, reliable, and affordable electric service. UIS is responsible for the planning, architecture, security, and lifecycle management of the technologies that support critical utility functions, including customer information systems, advanced metering infrastructure, geographic information systems, operational technology, data platforms, and enterprise applications.

Working across all areas of the organization, UIS drives the modernization of AMPs technology landscape through a balanced approach that emphasizes cybersecurity, operational resilience, data accessibility, and business efficiency. The division establishes technology standards, manages strategic investments, and ensures that information systems remain secure, reliable, and adaptable to the evolving needs of the utility.

Through the thoughtful adoption of emerging technologies, data-driven capabilities, and smart utility solutions, UIS enhances the customer experience, strengthens grid intelligence, supports informed decision-making, and helps position AMP to meet the challenges and opportunities of a rapidly changing energy future while managing risk responsibly.

About the Position

The City of Alameda is seeking a skilled and forward-thinking Utility Database Analyst to play an essential role in managing, securing, and advancing the data infrastructure that supports Alameda Municipal Power (AMP), the City's community-owned electric utility.

The Utility Database Analyst designs, administers, and optimizes relational databases and associated infrastructure, ensuring system performance, cybersecurity, data integrity, backup and recovery, and business continuity. The role develops and maintains data integrations, automated workflows, queries, reports, and business intelligence solutions that connect systems, improve operational efficiency, and make trusted data accessible and actionable throughout the utility.

Building on this foundation, the analyst will contribute to advancing AMP's artificial intelligence and data modernization initiatives by identifying opportunities to leverage AI, advanced analytics, and agentic technologies to improve data access, automate workflows, and enhance operational effectiveness. Responsibilities include preparing and integrating data for AI-enabled applications, evaluating emerging technologies, and developing secure, practical solutions that improve information availability and support data-driven decision-making. The analyst will help ensure these capabilities adhere to appropriate cybersecurity, data governance, and privacy standards.

The ideal candidate combines deep expertise in relational database technologies with a commitment to security, resiliency, and continuous improvement, along with the ability to leverage modern data tools and AI to expand the value of AMP's data. This position works closely with staff, vendors, and other City departments and may require occasional work outside regular business hours, including responding to after-hours emergencies.

BENEFITS OF EMPLOYMENT

For a comprehensive list of benefits, see the Benefit Matrix here

• Four-day, 36-hour work week (typically Monday through Thursday)

• CalPERS Retirement: Classic Members: 2% at 55 formula, 8.868% contribution; New Members 2% @ 62 formula, 8.25% contribution.

• Medical: The City contracts with CalPERS to provide comprehensive health coverage to employees. Multiple HMO and PPO plans available, with a generous City contribution towards medical premiums.

• Dental: Comprehensive dental coverage provided to employees and their eligible dependents.

• Vacation: Starting with 75 hours annually and increasing with years of service.

• Management Incentive Leave: 27 hours of management leave per fiscal year.

• Holidays: 11 City Holidays

• Floating Holidays: 4 days

• Sick Leave: 90 hours annually; unused sick leave is converted to service credit at retirement.

• Deferred Compensation: Up to 1% 457(b) matching City contribution after 1 year of continuous service.

Distinguishing Features

Positions in this classification are responsible for independently performing professional duties in support of AMP's database management and administration systems. Incumbents regularly work on tasks which are varied and complex, requiring considerable discretion, problem solving, and independent judgment.

Examples of Duties

The following list of duties is intended only to describe the various types of work that may be performed and the level of technical complexity of the assignment(s) and is not intended to be an all-inclusive list of duties. The omission of a specific duty statement does not exclude it from the position if the work is consistent with the concept of the classification or is similar or closely related to another duty statement.

Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

EXAMPLES OF DUTIES

1. Plans, designs, configures, programs, tests, installs, and upgrades relational databases for new and existing systems; analyzes data and monitors for performance.

2. Manages files for database structures; monitors disk storage space and backup management activities; designs, implements, and tests backup and recovery plans; performs back up activities at scheduled times

3. Develops and prepares data queries and reports as necessary using a variety of reporting interfaces, tools, and applications.

4. Optimizes database systems by performing routine maintenance procedures, including, but not limited to, re-indexing and updating statistics; checks for database consistency; and detects and repairs database corruption.

5. Audits databases for performance and compliance.

6. Ensures security and privacy levels are maintained in all database systems.

7. Creates and maintains user permissions, system privileges, passwords, and other security methods; installs, administers, and monitors license management software; monitors database usage for security purposes; checks logs and files for evidence of problems and system failure.

8. Provides technical support in the planning of new database systems including hardware, operating systems, licensing and storage requirements.

9. Enforces data quality standards and performs quality control checks on associated data.

10. Monitors database security and performance against established standards; detects and troubleshoot problems.

11. Implements data recovery plan when necessary; prepares related project status reports as required.

12. Coordinates assigned functions with and provides support internally and externally, including other sections, divisions, departments, and vendors.

13. Prepares and maintains systems procedures and documentation; maintains and updates manuals, codebooks, templates, computer control tables, etc.; assists in developing database policies and procedures.

Other Duties

14. Performs related duties as assigned.

WORKING CONDITIONS

• Work is performed in an office or station environment.
• Occasional work outside of regularly scheduled hours.
• Noise level is usually moderate, ambient office sounds such as speaking, working office equipment, and software.

PHYSICAL DEMANDS

• Sitting or standing for extended periods of time.
• Operate objects, controls, and/or tools such as but not limited to a computer, computer keyboard, and standard office equipment.
• Ability to interpret, read, and maintain various documents, such as files and reports, in a variety of formats.
• Reach with hands and arms; repetitive movements of hands or wrist; climb or balance; stoop, crouch, squat, crawl, walk; twist and bend from the waist.
• Ability to present and exchange information and communicate with departments and partners.

Employment Standards

Education/Experience

Any combination equivalent to education and experience likely to provide the required knowledge and abilities. A typical way to obtain the knowledge and abilities would be:

Education: Graduation from an accredited four-year college or university with major course work in computer information systems, business administration, database administration, business intelligence, systems analysis, system design, or related field.

Experience: Two years of responsible experience in database administration, data processing, programming, systems analysis, or systems design.

Knowledge

Knowledge of principles and practices of database management and administration, operational characteristics of servers, operating systems and network infrastructure as it relates to database management; electronic records storage and handling techniques; a diverse range of business intelligence reporting tools; programming methods, techniques and languages specific to supported systems; database security methods and techniques; data storage principles; principles and practices of project management; software development life cycle principles and practices; methods and techniques of database design, implementation, operation, maintenance, and data manipulation; research, analysis, and management related to databases; extract transform, and load (ETL) methodologies; workflow and process improvement methodologies; technical report writing procedures; project management principles, practices and tools; and computer logic and mathematics.

Ability

Ability to work independently and perform professional work in support of information technology business operations, specifically AMP database systems, data management and analysis; write codes and scripts; perform tasks within a variety of database systems and report development platforms; recommend, implement, and monitor rigorous security measures; prepare written procedures for complex database solutions; write operating instructions and procedures for electronic data processing machine applications; coordinate with multiple parties, e.g., vendors, staff, and end users; install, configure, trouble-shoot database specific desktop/server hardware and software; maintain and administer security systems and methodologies; learn and effectively use software specific to staff needs; read and interpret documents such as operating and maintenance instructions and technical procedure manuals; prepare reports, effectively present information and respond to questions from staff and vendors; define problems, collect data, establish facts and draw valid conclusions; interpret an extensive variety of technical instructions in diagram form and work effectively with abstract and concrete variables; schedule and perform work to meet established timelines; work independently with minimal supervision; establish and maintain accurate records; maintain level of knowledge required for satisfactory job performance; establish and maintain effective working relationships with vendors and staff at all levels.

Special Requirements

Willingness and/or ability to work outside regularly scheduled hours to meet operational needs and to respond to after-hours emergency calls as required.

SELECTION PROCESS:

It is important that both the application on and questionnaire are completed thoroughly and accurately. The examination process may test for, but is not limited to, the essential knowledge and abilities listed in the job specification and announcement and will be designed to provide a comprehensive review of each candidates technical knowledge and overall suitability for the position. Qualified applicants will be notified of the exact date, time, and location of examinations approximately two weeks in advance. If applicants have not received written notice at least one week prior to the tentative test date listed in the flyer, they should contact the City of Alameda Human Resources Department at (510) 747-4900.

Candidates passing all components of the examination process will be placed on an Eligible List. A list of names is certified to the department(s) having vacancies based on the type of examination conducted pursuant to the provision of the Citys Civil Service Rules. Final selection will be made from the Eligible List by the Department Head subject to approval by the City Manager. The Department Head may utilize additional selection procedures to make a final hiring decision. Placement on an Eligible List does not guarantee employment. Prior to appointment, a thorough reference check will be conducted which may include a credit check and background. The selection process may be evaluated and revised based on the number of qualified applicants. Federal law requires that prior to employment, you must furnish proof of your identity and eligibility for employment in the United States, as required by U.S. Citizenship and Immigration Services.

E-VERIFY:

The City of Alameda utilizes the Federal governments E-Verify program and new employees must provide documentation to establish both identity and work authorization, which includes showing a valid United States Social Security card at the time of hire (photocopies not accepted).

VETERANS PREFERENCE CREDIT:

A job applicant qualifies as a veteran if honorably discharged from active military, reservist, or National Guard duty of at least 18 consecutive months within the past five (5) years of the date of application. In case of discharge attributable to service-connected injuries or illnesses, the 18 months active duty requirement need not be fulfilled. An applicant claiming veterans preference credit must attach to their application, a legible copy of their DD-214 verifying the type of discharge and date(s) of active service. NO OTHER DOCUMENTATION WILL BE ACCEPTED.

AN EQUAL OPPORTUNITY EMPLOYER:

The In compliance with local, state and federal laws and regulations, the City of Alameda will employ and promote qualified individuals without regard to disability. The City is committed to making reasonable accommodations in the examination process and in the work environment. Individuals requesting reasonable accommodations in the examination process must do so no later than the final filing date for receipt of applications, otherwise it may not be possible to arrange accommodations for the selection process. Such requests should be addressed to the Human Resources Department | 1-510-747-4900 | hr@alamedaca.gov | 2263 Santa Clara Avenue, Rm. 290, Alameda, 94501. Requests can be made via email, phone, or in writing via U.S. mail.

The information contained herein is subject to change and does not constitute either an expressed or implied contract.

For Benefits information, please visit our website at www.alamedaca.gov. A detailed summary for this position can be found under EUPA.

01

Be sure to answer the supplemental questions thoroughly and accurately. Answers to the supplemental questions must be supported by the experience section of the application. Additionally, "See Resume" or "N/A" as a response will not be considered sufficient information to determine your eligibility to move forward in the selection process. Incomplete responses, false statements, omissions, or partial information may result in disqualification from the selection process. I have read and understand the statement above concerning submission of supplemental questionnaire responses.

• Yes
• No

02

Are you willing to work outside regularly scheduled hours to meet operational needs, including responding to after-hours emergency calls?

• Yes
• No

03

Do you have at least two years of responsible professional experience in relational database administration, database design and integration, query development, reporting, and business intelligence?

• Yes
• No

04

Describe your experience administering relational databases, such as Microsoft SQL Server, PostgreSQL, or Oracle. Identify the platforms you have worked with, your specific responsibilities, and your years of experience with each. Include experience with installation, configuration, upgrades, maintenance, performance tuning, indexing, statistics management, and database integrity checks. Also describe your role in developing, testing, and maintaining database backup, recovery, and business continuity procedures.

05

Describe your experience managing database security, including user access and privileges, service accounts, data integrations, auditing, and monitoring database logs for errors, vulnerabilities, or unauthorized activity. Provide a specific example of a security, performance, or data integrity issue you identified and resolved. Explain your approach, the actions you took, and the results.

06

Describe your experience developing database queries, reports, data integrations, and business intelligence solutions using tools such as Power BI, Cognos, Crystal Reports, or ETL platforms. Provide an example of how you worked with end users, technical teams, or vendors to translate a business need into a functional data solution. Explain your role, the technologies used, and the benefits achieved.

07

Describe your experience implementing, supporting, or evaluating artificial intelligence and other emerging technologies in an enterprise environment. Provide an example of how you applied, or helped introduce, these technologies to improve data access, automate workflows, enhance reporting, or improve organizational effectiveness. Explain the benefits achieved and the considerations addressed, including data security, privacy, accuracy, governance, and integration with existing systems.

Required Question

Employer City of Alameda

Address 2263 Santa Clara Avenue, Rm. 290

Alameda, California, 94501

Phone (510) 747-4900

Website https://www.alamedaca.gov/Departments/Administration/Human-Resources