City of Los Angeles
City Of Los Angeles, California, United States
DUTIES ANNUAL SALARY: $112,564 to $164,576 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 http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . 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) 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 : 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 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 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 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: 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 Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google 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 driver’s 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%20Institutions%2008-21-08.pdf . 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 Administrator Microsoft 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: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : 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), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. 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 will only be accepted on-line on the dates listed below: Friday, October 6, 2023 to Thursday, October 19, 2023 Friday, May 3, 2024 to Thursday, May 16, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. 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 selection process 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 based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, NOVEMBER 27, 2023 and MONDAY, DECEMBER 4, 2023 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, JUNE 24, 2024 and MONDAY, JULY 1, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that interviews will begin during the period of DECEMBER 26, 2023 to JANUARY 5, 2024 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that interviews will begin during the period of July 22, 2024 to August 2, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . 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. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS 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. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous
DUTIES ANNUAL SALARY: $112,564 to $164,576 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 http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . 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) 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 : 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 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 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 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: 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 Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google 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 driver’s 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%20Institutions%2008-21-08.pdf . 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 Administrator Microsoft 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: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : 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), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. 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 will only be accepted on-line on the dates listed below: Friday, October 6, 2023 to Thursday, October 19, 2023 Friday, May 3, 2024 to Thursday, May 16, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. 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 selection process 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 based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, NOVEMBER 27, 2023 and MONDAY, DECEMBER 4, 2023 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, JUNE 24, 2024 and MONDAY, JULY 1, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that interviews will begin during the period of DECEMBER 26, 2023 to JANUARY 5, 2024 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that interviews will begin during the period of July 22, 2024 to August 2, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . 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. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS 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. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous
City of Long Beach, CA
City of Long Beach, California, United States
DESCRIPTION RECRUITMENT BROCHURE: CLICK HERE THE COMMUNITY Ideally located on the Pacific Ocean south of Los Angeles, adjacent to Orange County, the City of Long Beach, California (population 470,000) is frequently described as a series of strong, diverse interwoven smaller communities within a large city. Enjoying an ideal Southern California climate, Long Beach is home to an abundance of cultural and recreational options. The Long Beach Convention Center, Aquarium of the Pacific, Queen Mary, and the annual Acura Grand Prix of Long Beach, plus a wide variety of other attractions (two historic ranchos, three marinas, and five golf courses), serve to draw 6.5 million visitors a year. The City is also home to California State University, Long Beach, and Long Beach City College. Cal State Long Beach is the second largest university in the state and was recently ranked the No. 3 best-value public college in the nation. Covering approximately 50 square miles, Long Beach is supported by a wide mix of industries with education, health and social services, manufacturing, retail trade, and professional services comprising the highest representation. Known for its livable and desirable neighborhoods, Long Beach was named by America’s Promise Alliance as one of the 100 Best Communities for Young People two years in a row. While it offers all the amenities of a large metropolis, many say Long Beach offers the added benefit of having maintained a strong sense of community and cohesiveness despite its growth. A superb climate, quality schools, a vibrant downtown, and a wide variety of neighborhoods help make Long Beach one of the most livable communities in the country. CITY GOVERNMENT Long Beach, a charter city formed in 1897, is governed by nine City Council Members elected by district and a city-wide elected Mayor. Other elected officials include the City Attorney, City Auditor, and City Prosecutor. The elected officials are elected to staggered four-year terms. The City Council appoints the City Manager and City Clerk. The City Manager is responsible for the efficient administration of all City departments, excluding those under the direction of a separately elected official, Board or Commission. Long Beach is one of only three cities in California with its own Health Department and one of the very few municipalities with its own Utilities Department (Water and Gas) and Energy Resources Departments. The City is supported by a FY 2024 total budget of approximately $3.3 billion with a General Fund budget of $719 million. More than 6,000 full and part-time employees support municipal operations with the vast majority being represented by twelve employee associations. To learn more about the City of Long Beach, go to: www.longbeach.gov . THE DEPARTMENT T he Technology & Inn ovation Department (TID) plans and develops the technology infrastructure for the City and provides a centralized resource for technology deployment and support throughout the City . The Department integrates people, processes, and technology to increase the efficiency and effectiveness of City services through the work of its 19 7 FTEs while operating on a FY 202 4 annual operating budget of nearly $7 2 million and multi-year capital projects budget of $101 million. TID is organized into five bureaus: Business Operations, Digital Services, Enterprise Information Services, Infrastructure Services, and Technology Engagement & Support. The Department also manages LBTV, a production studio that develops custom programming and distributes City multimedia content via its broadcast TV station and social media platforms. Additional information about the department is available at www.longbeach.gov/ti . EXAMPLES OF DUTIES THE POSITION The Information Systems Officer position reports directly to the Enterprise Information Services Bureau Manager and oversee s the Business Intelligence Division which is currently comprised of five team members. The position is part of TID’s management team which leads and advises Long Beach to effectively respond to a rapidly evolving technology environment. The Business Intelligence Divisio n is responsible for the system administration of several systems related to reporting, data management, and payment technologies . Examples of these systems include iNovah , Kubra, and Simpler Systems. The primary focus of this position is to provide effective data management and oversee the planning, acquisition, deployment, and ongoing support of these systems. The team also provides database administration support for Oracle databases , develops data integratio ns between various internal and external systems, and partners with other technical resources on projects . EXA MPLES OF DUTIES The specific responsibilities of the position include: Plans, organizes, and directs the activities of Business Intelligence division staff, i.e., the Business Intelligence and Payment Systems teams, including managing allocation of staff and resources, hiring, staff development, mentoring, and performance management. Leads technology adoption and growth for a broad set of stakeholders. Responsible for the overall system administration and support for systems supported by the division including the planning and management of system upgrades. This position will be responsible for data requests, data integrations, data warehousing, business intelligence (reporting), technical support, technical system design, and workflow automation. Works with department stakeholders to ensure an accurate understanding of technology needs. Provides a leadership role for data transformation and integrations. Develops and maintains batch processes, requirements, and processes. Modernizes legacy systems and /or processes. Assists with negotiating contracts for goods and services with third-party vendors. Ensures compliance with IT standards, policies, and procedures. THE IDEAL CANDIDATE The ideal candidate for this position is a seasoned technologist with robust leadership experience . They are organized, thinks “big picture ”, and comfortable staying abreast with current technology trends. The candidate must be an exceptional communicator that can establish and maintain relationships with a broad set of stakeholders. Technical acumen, leadership, and communication are key qualities for this role. Success in this position will require a deep understanding of data management and a willingness to leverage cloud-based solution s . REQUIREMENTS TO FILE Education A Bachelor’s Degree from an accredited college or university . Related experience beyond the minimum requirement may be substituted for required education on a year-for-year basis. Experience Five (5) years of increasingly responsible experience in technology management and system administration of enterprise systems. Three (3) years of which served as experience in a supervisory or lead capacity. The following are desirable: A Master’s Degree Professional certifications Knowledge of data management and data governance principles Knowledge of information management practices, system development lifecycle management, IT service management, and IT infrastructure library frameworks . Knowledge of business ecosystems such as Software as a Service (SaaS), Infrastructure as a Service (IaaS), Platform as a Service (PaaS), Service Oriented Architecture (SOA), Application Programming Interfaces (API), and Open Data concepts . SELECTION PROCEDURE This recruitment will close on 11:59 p.m. on Sunday, May 5, 2024. T o be considered for this opportunity applicants must submit an online application, including a resume and cover letter, that reflects the scope and level of their current/most recent positions and responsibilities. Online applications can be filed at https://www.governmentjobs.com/careers/cpshrrs/jobs/4448641-0/information-systems-officer-business-intelligence For additional information about this position, please contact: Maricarmen Peoples, Senior HR Consultant at 916-471-3365 Following the close of filing, applications will be reviewed, and those candidates determined to be the best qualified will be invited to participate in the selection process which will include an oral interview by a selection panel. The City of Long Beach is an Equal Opportunity Employer . We value and encourage diversity in our workforce. The City of Long Beach is committed to creating a workplace where every employee is valued for who they are. Having our workforce reflect the diversity of our community at various levels of the organization is a continuous goal embraced by our departments, management staff, and policymakers. To support efforts of fairness and diversity, City Leadership is committed to incorporating equity and inclusion into our work by supporting staff and community partners. We are committed to promoting transparency by publishing updated demographic information for employees, including workforce diversity data and pay by race and gender. The City of Long Beach will consider qualified applicants with a criminal history pursuant to the California Fair Chance Act. You are not required to disclose your criminal history or participate in a background check until you receive a conditional job offer. If the City of Long Beach has concerns about a conviction that is directly related to the job after making a conditional job offer and conducting a background check, you will have the opportunity to explain the circumstances surrounding the conviction, provide evidence to mitigate concerns, or challenge the accuracy of the background report. Find out more about the Fair Chance Act by visiting https://calcivilrights.ca.gov/fair-chance-act . The City of Long Beach intends to provide reasonable accommodations in accordance with the Americans with Disabilities Act of 1990. If a special accommodation is desired, or if you would like to request this information in an alternative format, please call (562) 570-6272. The City of Long Beach offers its employees opportunities to grow personally and professionally.As a permanent employee, you are eligible to receive fringe benefits that include: Retirement: California Public Employees' Retirement System (PERS) defined benefit retirement plan, which is coordinated with Social Security. The benefit is 2.5% or 2.7% (depending on hire date) @55 for "Classic" members and 2% @62 for new members as defined by PEPRA, subject to the compensation limitations set by PERS. Both the City and the employee contributes toward CalPERS retirement contributions. The city also participates in Social Security. Health and Dental Insurance: The City offers the choice of HMO and PPO plans. The city pays major portion of the premium for employee and dependents depending on the health/ dental plan selected. Life Insurance: City-paid term life insurance policy equal to three (3) times annual salary to a maximum of $500,000. Disability Insurance: City-paid short-term and long-term disability insurance. Management Physical: Annual City-paid physical examination. Vacation: Twelve (12) vacation days after the first year of service; 15 days after four years, six months of service; 20 days after 19 years, six months of service. Executive Leave: Forty (40) hours Executive Leave per year. The City Manager has discretion to grant an additional 40 hours each year. Sick Leave : One day earned per month; unlimited accumulation; conversion upon retirement to cash credit toward health and/or dental insurance premiums, or to pension credits. Holidays: Eleven (11) designated holidays per year, plus four personal holidays to be used at the employee's discretion. Transportation Allowance: Monthly allowance is allocated by classifications below; Department Head $650.00 Deputy Director/Manager/Director (Harbor/Utilities) $550.00 Division Officer/Superintendent/ Chief of Staff / Administrator / Principal DCA $450.00 Assistant to Executive / Executive Assistant / Executive Secretary/ Executive Support Staff $300.00 Deferred Compensation Plan: Optional for employee contribution to a supplementary retirement savings program available through Mission Square Retirement formerly ICMA-RC Retirement Corporation). Classic CalPERS Members: The City will contribute a maximum of up to two percent (2%) of base salary* for all qualified Classic CalPERS members. Public Employees’ Pension Reform Act (PEPRA) CalPERS Members: Effective the second full pay period following City Council adoption, the City contribution will increase from two percent (2%) to three percent (3%) of base salary* for all qualified PEPRA CalPERS members. Flexible Spending Account (FSA): Optional election for employees to reduce taxable income for payment of allowable childcare or medical expenses. Flexible/Hybrid Work Schedule: Available (subject to City Manager approval). Paid Parental Leave: The City provides one hundred and sixty (160) hours of Paid Parental Leave at 100% of salary, for the birth, adoption or foster placement of a child, regardless of the gender, marital status or sexual orientation of the parent. Closing Date/Time: 5/5/2024 11:59 PM Pacific
DESCRIPTION RECRUITMENT BROCHURE: CLICK HERE THE COMMUNITY Ideally located on the Pacific Ocean south of Los Angeles, adjacent to Orange County, the City of Long Beach, California (population 470,000) is frequently described as a series of strong, diverse interwoven smaller communities within a large city. Enjoying an ideal Southern California climate, Long Beach is home to an abundance of cultural and recreational options. The Long Beach Convention Center, Aquarium of the Pacific, Queen Mary, and the annual Acura Grand Prix of Long Beach, plus a wide variety of other attractions (two historic ranchos, three marinas, and five golf courses), serve to draw 6.5 million visitors a year. The City is also home to California State University, Long Beach, and Long Beach City College. Cal State Long Beach is the second largest university in the state and was recently ranked the No. 3 best-value public college in the nation. Covering approximately 50 square miles, Long Beach is supported by a wide mix of industries with education, health and social services, manufacturing, retail trade, and professional services comprising the highest representation. Known for its livable and desirable neighborhoods, Long Beach was named by America’s Promise Alliance as one of the 100 Best Communities for Young People two years in a row. While it offers all the amenities of a large metropolis, many say Long Beach offers the added benefit of having maintained a strong sense of community and cohesiveness despite its growth. A superb climate, quality schools, a vibrant downtown, and a wide variety of neighborhoods help make Long Beach one of the most livable communities in the country. CITY GOVERNMENT Long Beach, a charter city formed in 1897, is governed by nine City Council Members elected by district and a city-wide elected Mayor. Other elected officials include the City Attorney, City Auditor, and City Prosecutor. The elected officials are elected to staggered four-year terms. The City Council appoints the City Manager and City Clerk. The City Manager is responsible for the efficient administration of all City departments, excluding those under the direction of a separately elected official, Board or Commission. Long Beach is one of only three cities in California with its own Health Department and one of the very few municipalities with its own Utilities Department (Water and Gas) and Energy Resources Departments. The City is supported by a FY 2024 total budget of approximately $3.3 billion with a General Fund budget of $719 million. More than 6,000 full and part-time employees support municipal operations with the vast majority being represented by twelve employee associations. To learn more about the City of Long Beach, go to: www.longbeach.gov . THE DEPARTMENT T he Technology & Inn ovation Department (TID) plans and develops the technology infrastructure for the City and provides a centralized resource for technology deployment and support throughout the City . The Department integrates people, processes, and technology to increase the efficiency and effectiveness of City services through the work of its 19 7 FTEs while operating on a FY 202 4 annual operating budget of nearly $7 2 million and multi-year capital projects budget of $101 million. TID is organized into five bureaus: Business Operations, Digital Services, Enterprise Information Services, Infrastructure Services, and Technology Engagement & Support. The Department also manages LBTV, a production studio that develops custom programming and distributes City multimedia content via its broadcast TV station and social media platforms. Additional information about the department is available at www.longbeach.gov/ti . EXAMPLES OF DUTIES THE POSITION The Information Systems Officer position reports directly to the Enterprise Information Services Bureau Manager and oversee s the Business Intelligence Division which is currently comprised of five team members. The position is part of TID’s management team which leads and advises Long Beach to effectively respond to a rapidly evolving technology environment. The Business Intelligence Divisio n is responsible for the system administration of several systems related to reporting, data management, and payment technologies . Examples of these systems include iNovah , Kubra, and Simpler Systems. The primary focus of this position is to provide effective data management and oversee the planning, acquisition, deployment, and ongoing support of these systems. The team also provides database administration support for Oracle databases , develops data integratio ns between various internal and external systems, and partners with other technical resources on projects . EXA MPLES OF DUTIES The specific responsibilities of the position include: Plans, organizes, and directs the activities of Business Intelligence division staff, i.e., the Business Intelligence and Payment Systems teams, including managing allocation of staff and resources, hiring, staff development, mentoring, and performance management. Leads technology adoption and growth for a broad set of stakeholders. Responsible for the overall system administration and support for systems supported by the division including the planning and management of system upgrades. This position will be responsible for data requests, data integrations, data warehousing, business intelligence (reporting), technical support, technical system design, and workflow automation. Works with department stakeholders to ensure an accurate understanding of technology needs. Provides a leadership role for data transformation and integrations. Develops and maintains batch processes, requirements, and processes. Modernizes legacy systems and /or processes. Assists with negotiating contracts for goods and services with third-party vendors. Ensures compliance with IT standards, policies, and procedures. THE IDEAL CANDIDATE The ideal candidate for this position is a seasoned technologist with robust leadership experience . They are organized, thinks “big picture ”, and comfortable staying abreast with current technology trends. The candidate must be an exceptional communicator that can establish and maintain relationships with a broad set of stakeholders. Technical acumen, leadership, and communication are key qualities for this role. Success in this position will require a deep understanding of data management and a willingness to leverage cloud-based solution s . REQUIREMENTS TO FILE Education A Bachelor’s Degree from an accredited college or university . Related experience beyond the minimum requirement may be substituted for required education on a year-for-year basis. Experience Five (5) years of increasingly responsible experience in technology management and system administration of enterprise systems. Three (3) years of which served as experience in a supervisory or lead capacity. The following are desirable: A Master’s Degree Professional certifications Knowledge of data management and data governance principles Knowledge of information management practices, system development lifecycle management, IT service management, and IT infrastructure library frameworks . Knowledge of business ecosystems such as Software as a Service (SaaS), Infrastructure as a Service (IaaS), Platform as a Service (PaaS), Service Oriented Architecture (SOA), Application Programming Interfaces (API), and Open Data concepts . SELECTION PROCEDURE This recruitment will close on 11:59 p.m. on Sunday, May 5, 2024. T o be considered for this opportunity applicants must submit an online application, including a resume and cover letter, that reflects the scope and level of their current/most recent positions and responsibilities. Online applications can be filed at https://www.governmentjobs.com/careers/cpshrrs/jobs/4448641-0/information-systems-officer-business-intelligence For additional information about this position, please contact: Maricarmen Peoples, Senior HR Consultant at 916-471-3365 Following the close of filing, applications will be reviewed, and those candidates determined to be the best qualified will be invited to participate in the selection process which will include an oral interview by a selection panel. The City of Long Beach is an Equal Opportunity Employer . We value and encourage diversity in our workforce. The City of Long Beach is committed to creating a workplace where every employee is valued for who they are. Having our workforce reflect the diversity of our community at various levels of the organization is a continuous goal embraced by our departments, management staff, and policymakers. To support efforts of fairness and diversity, City Leadership is committed to incorporating equity and inclusion into our work by supporting staff and community partners. We are committed to promoting transparency by publishing updated demographic information for employees, including workforce diversity data and pay by race and gender. The City of Long Beach will consider qualified applicants with a criminal history pursuant to the California Fair Chance Act. You are not required to disclose your criminal history or participate in a background check until you receive a conditional job offer. If the City of Long Beach has concerns about a conviction that is directly related to the job after making a conditional job offer and conducting a background check, you will have the opportunity to explain the circumstances surrounding the conviction, provide evidence to mitigate concerns, or challenge the accuracy of the background report. Find out more about the Fair Chance Act by visiting https://calcivilrights.ca.gov/fair-chance-act . The City of Long Beach intends to provide reasonable accommodations in accordance with the Americans with Disabilities Act of 1990. If a special accommodation is desired, or if you would like to request this information in an alternative format, please call (562) 570-6272. The City of Long Beach offers its employees opportunities to grow personally and professionally.As a permanent employee, you are eligible to receive fringe benefits that include: Retirement: California Public Employees' Retirement System (PERS) defined benefit retirement plan, which is coordinated with Social Security. The benefit is 2.5% or 2.7% (depending on hire date) @55 for "Classic" members and 2% @62 for new members as defined by PEPRA, subject to the compensation limitations set by PERS. Both the City and the employee contributes toward CalPERS retirement contributions. The city also participates in Social Security. Health and Dental Insurance: The City offers the choice of HMO and PPO plans. The city pays major portion of the premium for employee and dependents depending on the health/ dental plan selected. Life Insurance: City-paid term life insurance policy equal to three (3) times annual salary to a maximum of $500,000. Disability Insurance: City-paid short-term and long-term disability insurance. Management Physical: Annual City-paid physical examination. Vacation: Twelve (12) vacation days after the first year of service; 15 days after four years, six months of service; 20 days after 19 years, six months of service. Executive Leave: Forty (40) hours Executive Leave per year. The City Manager has discretion to grant an additional 40 hours each year. Sick Leave : One day earned per month; unlimited accumulation; conversion upon retirement to cash credit toward health and/or dental insurance premiums, or to pension credits. Holidays: Eleven (11) designated holidays per year, plus four personal holidays to be used at the employee's discretion. Transportation Allowance: Monthly allowance is allocated by classifications below; Department Head $650.00 Deputy Director/Manager/Director (Harbor/Utilities) $550.00 Division Officer/Superintendent/ Chief of Staff / Administrator / Principal DCA $450.00 Assistant to Executive / Executive Assistant / Executive Secretary/ Executive Support Staff $300.00 Deferred Compensation Plan: Optional for employee contribution to a supplementary retirement savings program available through Mission Square Retirement formerly ICMA-RC Retirement Corporation). Classic CalPERS Members: The City will contribute a maximum of up to two percent (2%) of base salary* for all qualified Classic CalPERS members. Public Employees’ Pension Reform Act (PEPRA) CalPERS Members: Effective the second full pay period following City Council adoption, the City contribution will increase from two percent (2%) to three percent (3%) of base salary* for all qualified PEPRA CalPERS members. Flexible Spending Account (FSA): Optional election for employees to reduce taxable income for payment of allowable childcare or medical expenses. Flexible/Hybrid Work Schedule: Available (subject to City Manager approval). Paid Parental Leave: The City provides one hundred and sixty (160) hours of Paid Parental Leave at 100% of salary, for the birth, adoption or foster placement of a child, regardless of the gender, marital status or sexual orientation of the parent. Closing Date/Time: 5/5/2024 11:59 PM Pacific