Posting number: 2026-7337-01
Department: Alameda Municipal Power
Job classification: Utility Database Analyst
Posting type: Open
Categories: IT and Computers, Telecommunications, Communications
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 island's 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.
The Utility Information Systems (UIS) Division provides the strategic leadership, governance, and oversight of Alameda Municipal Power's technology ecosystem, ensuring that utility systems align with AMP's 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 AMP's 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.
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.
For a comprehensive list of benefits, see the Benefit Matrix here
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.
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.
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.
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 candidate's 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 City's 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.
The City of Alameda utilizes the Federal government's 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).
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 veteran's 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.
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.
The City of Alameda, California is a unique island community of approximately 76,000 residents in the San Francisco Bay Area. With connections to the East Bay mainland by four bridges, two underwater tubes, and highly-desirable ferry service to San Francisco, we are within minutes of numerous cultural activities in San Francisco, Oakland, and Berkeley. People are drawn to Alameda for our safe and inviting residential communities with distinguished neighborhood schools, boutique shopping, and a broad mix of destination restaurants. Alameda takes pride in being a vibrant community with a rich maritime history and small-town charm. We offer a diverse mix of housing, including multi-family units and historic Victorian homes along tree-lined streets. According to Money Magazine, the City of Alameda compares favorably to the “best places to live” in America.
Alameda was incorporated in 1854 and became a charter city in 1916 with a Council-Manager form of government. The five-member Mayor/Council serves four-year terms, staggered at even numbered years. The City is a full-service organization providing residents with a range of municipal services including police and fire protection; construction and maintenance of streets, storm drains, and other infrastructure; a state-of-the-art library system; economic development; an active planning and building permit center; and over 400 acres of parks and recreational facilities including multi-use athletic fields, picnic sites, a skate park, a swim center, and a full service senior center. The city employs approximately 500 full-time employees in the departments of the City Manager, City Attorney, City Clerk, Finance, Information Technology, Human Resources, Fire, Police, Community Development, Base Reuse, Public Works, Recreation & Parks, Library, and Alameda Municipal Power.
