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:
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

Nature of Position
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

• 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 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 El