$97,781 to $142,944
The salary in the Department of Water and Power is $113,670 to $141,211.

A Database Architect performs technical and administrative work in the development of standards, methods, techniques, procedures, data analyses, data designs, and database implementations necessary for the productive use, integration, sharing, standardization, integrity, security, availability, maintenance and operation of the City's electronic databases and assists in the overall management of the electronic databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; designs, develops and implements databases; enforces databases integrity; monitors and tunes database performance; 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; assist 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.

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. For such positions, only applicants possessing the specific professional certification(s) at the time of filing may be considered. Some positions will require a professional industry certification(s) in one or more of the following:

Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(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 certificate(s). Applicants who fail to submit the certificate(s) at the time of filing by not attaching it to the on-line application will not be considered for this part of selective certification.

Applications will only be accepted on-line. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the "Apply" icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity.
 
NOTE:
 
Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter.
 
Applications and Qualifications Questionnaires must be received by THURSDAY, SEPTEMBER 13, 2018.
 
In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the written test in the following order: 1) Los Angeles City Promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs in the order that applications were received. Applications submitted during the filing period may be kept on file in the event that additional applicants need to be tested to meet hiring needs.
 
QUALIFICATIONS REVIEW
 
Should a large number of qualified candidates file for this examination, each candidate's qualifications for the position of Database Architect may be evaluated based on the candidate's Qualifications Questionnaire. Those candidates considered possessing the greatest likelihood of successfully performing the duties of a Database Architect based solely on the information submitted for qualifications review will continue in the selection process.

The examination will consist of a qualifying written test and interview. In the qualifying written test, the following competencies may be evaluated: analytical ability, attention to detail, and job knowledge, including knowledge of high-availability, high-performance, and disaster recovery databases sufficient to design, implement, and manage databases; database principles and management systems such as Oracle, SQL Server, and DB2 sufficient to design and implement databases, and provide training and consulting services; programming languages such as SQL, Unix Scripts, and Windows Command Scripts; database management technology with emphasis on performance trade-offs, data structures, and relative strengths and weaknesses of the database management system; software tools and technologies used to move or replicate data between databases in one platform or heterogeneous database platforms; database tuning sufficient to optimize the performance of databases, including control systems software and native or third-party tools; database management schemas such as normalized and de-normalized structures; general systems, including systems design theory and methods, and dataflow sufficient to determine database requirements, and understand, analyze, and develop applications; general query and transaction processing concepts; metadata repository concepts and requirements; database design principles and conceptual modeling techniques in order to support OLTP data warehousing and analytic systems; internal systems components sufficient to fulfill external system design requirements; arrangement of data on electronic storage media, including data distribution on database performance and recovery, sufficient to ensure maximum storage accessibility; capabilities of large and midrange computers in order to determine the device required to perform a task; and other necessary skills, knowledge, and abilities.
 
Additional information can be obtained by going to http://per.lacity.org/index.cfm?content=jobanalyses and clicking on Competencies under Database Architect.
 
Candidates will be notified later by e-mail of the time and location of the written test which will be administered in a single half-day session on SATURDAY, NOVEMBER 3, 2018, in Los Angeles.
 
Passing Score for the Qualifying Written Test
 
The passing score for the qualifying written test will be determined by Personnel Department staff after the qualifying written test is administered. Consideration will be given to the number of candidates taking the test and the existing and anticipated number of vacancies, such that there are a sufficient number of eligibles on the list to satisfy current and future vacancies for the next two years. Therefore, the passing score for the qualifying multiple-choice written test may be set either above or below 70%.
 
All candidates who achieve a passing score on the qualifying multiple-choice written test will be invited to participate in the interview.
 
The examination score will be based entirely on the interview. In the interview, the following competencies may be evaluated: judgment and decision making; analytical ability; attention to detail; initiative; innovation; responsiveness and follow-up; teamwork; and job knowledge. Job knowledge areas may include knowledge of database principles and management systems such as Oracle, SQL Server, and DB2 sufficient to design and implement databases, and provide training and consulting services; database management technology with emphasis on performance trade-offs, data structures, and relative strengths and weaknesses of the database management system; software tools and technologies used to move or replicate data between databases in one platform or heterogeneous database platforms; database tuning sufficient to optimize the performance of databases, including control systems software and native or third-party tools; general systems, including systems design theory and methods, and dataflow sufficient to determine database requirements, and understand, analyze, and develop applications; general query and transaction processing concepts; database design principles and conceptual modeling techniques in order to support OLTP data warehousing and analytic systems; internal systems components sufficient to fulfill external system design requirements; and other necessary skills, knowledge and abilities.
 
As part of their evaluation of each candidate's overall qualifications for the job, the interview panel members will also consider the information in the candidate's Qualifications Questionnaire. Candidates may expect panel members to discuss this information during the interviews. Unsolicited supplemental information will not be submitted to the interview panel.
 
Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles.
 
NOTES:

Notice:
 
If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position.
 

THIS EXAMINATION IS TO BE GIVEN BOTH ON AN
INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS

AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER
For additional information and FAQs regarding the City's hiring process, please go to: http://per.lacity.org/index.cfm?content=employmenttestingprocess
?

The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome.