DATABASE ARCHITECT 1470 (Revised 05-01-24)

$115,967 - $171,529/Yr

City of Los Angeles - Los Angeles, CA

Full-time - Mid Level

Los Angeles, CA

Executive, Legislative, and Other General Government Support

About the position

A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City's on-premises and cloud-based databases. This role involves assisting in the implementation, maintenance, operation, or overall management of database-level integration between the on-premises and cloud-based databases. The Database Architect is responsible for installing and configuring database software and related administration tools and utilities, developing and implementing production scripts for database maintenance tasks, tuning and optimizing SQL statements and database/system parameters, and developing and conducting training sessions. Additionally, the architect utilizes database tools to perform various types of database backups and recoveries, ensures database security and compliance with SB1386 or data privacy acts, researches current database issues and technologies, and assists application developers in applying sound database technology to new applications. The role may also involve supervising other technical employees in the performance of these tasks and performing related duties as necessary.

Responsibilities

• Develop and implement standards, methods, and techniques for database management.
• Assist in the implementation and maintenance of on-premises and cloud-based databases.
• Install and configure database software and administration tools.
• Develop production scripts for database maintenance tasks.
• Tune and optimize SQL statements and database/system parameters.
• Conduct training sessions for staff on database management.
• Utilize database tools for backups and recoveries.
• Ensure database security and compliance with data privacy acts.
• Research current database issues and technologies.
• Assist application developers with database technology integration.
• Supervise other technical employees as needed.

Requirements

• A bachelor's degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field.
• Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL.
• Two years of full-time paid experience as a database architect or database administrator in the information technology industry.
• Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms.
• A DBA professional certification in one of the specified databases may be substituted for up to one year of the required experience.

Nice-to-haves

• Experience with cloud computing platforms such as AWS or Azure.
• Knowledge of data governance and compliance standards.
• Familiarity with data modeling and database design principles.

Benefits

• Health insurance coverage.
• Dental insurance coverage.
• Vision insurance coverage.
• Retirement savings plan (401k).
• Paid holidays and vacation time.
• Flexible scheduling options.