You are viewing a preview of this job. Log in or register to view more details about this job.
Email

DUTIES

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; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; 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; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties.

REQUIREMENT(S)/MINIMUM QUALIFICATION(S)

  1. 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; AND ONE OF THE FOLLOWING:
  2. 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 in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR
  3. Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR
  4. Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR
  5. Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing.

A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience:

  1. Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP)
  2. DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator
  3. Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA)
  4. MySQL 5.7 or higher – Any operating system, MySQL Certified Database Administrator
  5. MariaDB version 10 or higher – Any operating system, MariaDB Certified Database Administrator
  6. PostgreSQL, version 12 – Any operating system, PostgreSQL Professional Certification
  7. Google Certified Professional Data Engineer