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: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.