Utility Database Analyst

City of Alameda•Alameda, CA

About The Position

The City of Alameda is seeking a skilled and forward-thinking Utility Database Analyst to manage, secure, and advance the data infrastructure supporting Alameda Municipal Power (AMP), the City’s community-owned electric utility. The analyst designs, administers, and optimizes relational databases and related 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 and make trusted data accessible and useful throughout the utility. The analyst will also contribute to AMP’s artificial intelligence and data modernization initiatives by identifying opportunities to use AI, advanced analytics, and agentic technologies to improve data access, automate workflows, and enhance operations. Responsibilities include preparing and integrating data for AI-enabled applications, evaluating emerging technologies, and developing secure, practical solutions that support data-driven decisions. These capabilities must adhere to appropriate cybersecurity, data governance, and privacy standards. The position performs varied and complex professional duties independently, using discretion, problem-solving, and independent judgment. It works closely with staff, vendors, and other City departments and may require occasional work outside regular business hours, including responding to after-hours emergencies. Work is performed in an office or station environment.

Requirements

Graduation from an accredited four-year college or university with major coursework in computer information systems, business administration, database administration, business intelligence, systems analysis, system design, or a related field, or an equivalent combination of education and experience.
Two years of responsible experience in database administration, data processing, programming, systems analysis, or systems design.
Knowledge of database management and administration; servers, operating systems, and network infrastructure as related to database management; electronic records storage and handling; business intelligence reporting tools; programming methods, techniques, and languages for supported systems; database security; data storage; project management; software development life cycles; database design, implementation, operation, maintenance, and data manipulation; database research, analysis, and management; ETL methodologies; workflow and process improvement; technical report writing; and computer logic and mathematics.
Ability to work independently in support of information technology business operations, particularly AMP database systems, data management, and analysis.
Ability to write code and scripts and work across database systems and report-development platforms.
Ability to recommend, implement, and monitor rigorous security measures; prepare written procedures for complex database solutions; and write operating instructions and procedures for electronic data processing applications.
Ability to coordinate with vendors, staff, and end users; install, configure, and troubleshoot database-specific desktop/server hardware and software; and maintain and administer security systems and methodologies.
Ability to learn and effectively use software tailored to staff needs; read and interpret technical and maintenance documents; prepare reports, present information, and respond to questions from staff and vendors.
Ability to define problems, collect data, establish facts, draw valid conclusions, interpret technical instructions, and work with abstract and concrete variables.
Ability to schedule and complete work within established timelines, work independently with minimal supervision, maintain accurate records and job-related knowledge, and establish effective working relationships with vendors and staff at all levels.
Willingness and/or ability to work outside regularly scheduled hours to meet operational needs and respond to after-hours emergency calls as required.

Responsibilities

Plan, design, configure, program, test, install, and upgrade relational databases for new and existing systems; analyze data and monitor performance.
Manage database structure files and disk storage; oversee backup management, design and test backup and recovery plans, and perform scheduled backups.
Develop and prepare data queries and reports using reporting interfaces, tools, and applications.
Optimize databases through routine maintenance, including re-indexing and updating statistics; check consistency and detect and repair corruption.
Audit databases for performance and compliance.
Maintain security and privacy across database systems.
Create and maintain user permissions, system privileges, passwords, and other security methods; administer and monitor license-management software and database usage; review logs and files for problems and system failures.
Provide technical support for planning new database systems, including hardware, operating systems, licensing, and storage requirements.
Enforce data quality standards and perform quality-control checks on associated data.
Monitor database security and performance against established standards; detect and troubleshoot problems.
Implement data recovery plans when necessary and prepare project status reports as required.
Coordinate assigned functions with and provide support to internal and external partners, including sections, divisions, departments, and vendors.
Prepare and maintain systems procedures and documentation, including manuals, codebooks, templates, and computer control tables; assist in developing database policies and procedures.
Prepare and integrate data for AI-enabled applications; evaluate emerging technologies and develop secure, practical solutions that improve data access, automate workflows, and support data-driven decisions.
Perform related duties as assigned.

Benefits

Four-day, 36-hour work week, typically Monday through Thursday.
CalPERS retirement: Classic Members receive the 2% at 55 formula with an 8.868% contribution; New Members receive the 2% at 62 formula with an 8.25% contribution.
Medical coverage through CalPERS with multiple HMO and PPO plans and a generous City contribution toward premiums.
Comprehensive dental coverage for employees and eligible dependents.
Vacation starting at 75 hours annually and increasing with years of service.
27 hours of management incentive leave per fiscal year.
11 City holidays.
Four floating holidays.
90 hours of sick leave annually; unused sick leave is converted to service credit at retirement.
Deferred compensation: up to a 1% 457(b) matching City contribution after one year of continuous service.