Utility Database Analyst

City of Alameda

Yesterday

Salary: $133k – $162k/yr
Location: City of Alameda (Alameda Municipal Power), CA, CA
Department: IT
Closing date: Today
Source: GovernmentJobs

Description

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

About the Division; Utility Information Systems
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.

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.

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.

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.

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 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 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).

VETERAN'S 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 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.

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 | [email protected] | 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.

Skills

ETLCybersecurityComplianceCustomer ServiceProject Management