DEPARTMENT OF WATER & POWER CITY OF LOS ANGELES
Database Architect
DEPARTMENT OF WATER & POWER CITY OF LOS ANGELES, Los Angeles, California, United States, 90079
DUTIES
ANNUAL SALARY:
$115,967 to $169,503
The salary in the Department of Water and Power is $138,058 to $171,529.
NOTES:
Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer.For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to (Download PDF reader) {target="_blank"}.
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 Citys 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)
A bachelors 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: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; ORTwo 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; ORTwo 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; ORTwo 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:
Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP)DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database AdministratorMicrosoft SQL Se ver version 2012 or higher - Microsoft Certified Database Administrator (MCDBA)MySQL 5.7 or higher - Any operating system, MySQL Certified Database AdministratorMariaDB version 10 or higher - Any operating system, MariaDB Certified Database AdministratorPostgreSQL, version 12 - Any operating system, PostgreSQL Professional CertificationGoogle Certified Professional Data Engineer
PROCESS NOTES:
Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met.Some positions may require a valid California drivers license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI).Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed.Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited Institutions 08-21-08.pdf (Download PDF reader) {target="_blank"}.Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section.Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing.Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to:
Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP)DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database AdministratorMicrosoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA)
SELECTIVE CERTIFICATION:
In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions:
ANNUAL SALARY:
$115,967 to $169,503
The salary in the Department of Water and Power is $138,058 to $171,529.
NOTES:
Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer.For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to (Download PDF reader) {target="_blank"}.
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 Citys 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)
A bachelors 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: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; ORTwo 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; ORTwo 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; ORTwo 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:
Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP)DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database AdministratorMicrosoft SQL Se ver version 2012 or higher - Microsoft Certified Database Administrator (MCDBA)MySQL 5.7 or higher - Any operating system, MySQL Certified Database AdministratorMariaDB version 10 or higher - Any operating system, MariaDB Certified Database AdministratorPostgreSQL, version 12 - Any operating system, PostgreSQL Professional CertificationGoogle Certified Professional Data Engineer
PROCESS NOTES:
Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met.Some positions may require a valid California drivers license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI).Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed.Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited Institutions 08-21-08.pdf (Download PDF reader) {target="_blank"}.Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section.Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing.Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to:
Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP)DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database AdministratorMicrosoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA)
SELECTIVE CERTIFICATION:
In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: