City of Santa Monica
City of Santa Monica, California, United States
Job Summary Assists with implementing and overseeing the City's cross-connection control program, municipal and plumbing code programs and services. Enforces relevant utility and plumbing codes and investigates violations at residential, commercial, construction and development sites. Performs various water division field duties including complaint resolution, delinquent bill collection, leak detection and inspection of water meters and related equipment inspections. Enforces relevant utility and plumbing codes and investigates violations at a variety of sites. Provides assistance in the maintenance and repair of the City’s water distribution system and performs related work as required. SUPERVISION Receives immediate (Field Inspector I) or general (Field Inspector II) supervision from assigned supervisory or management personnel. Field Inspector II provides technical and functional direction to lower-level staff. Representative Duties DISTINGUISHING CHARACTERISTICS Field Inspector I : This is the entry-level classification in the Field Inspector series. Incumbents perform routine tasks in the inspection of various facilities plumbing systems and enforcement of violations. As experience is gained, assignments become more varied, complex, and difficult; supervision and frequent review of work lessen as an incumbent demonstrates skill to perform the work independently. Positions at this level usually perform most of the duties required of the positions at the II-level, but are not expected to function at the same skill level and usually exercise less independent discretion and judgment in matters related to work procedures and methods of operating heavy equipment. Work is usually supervised while in progress and fits an established structure or pattern. Exceptions or changes in procedures are explained in detail as they arise. Field Inspector II : This is the fully qualified journey-level classification in the Field Inspector series. Positions at this level are distinguished from the Field Inspector I by the performance of the full range of duties as assigned including conducting inspections and investigations, working independently, and exercising judgment and initiative. Positions at this level receive only occasional instruction or assistance as new or unusual situations arise and are fully aware of the operating procedures and policies of the work unit. May work in a lead capacity overseeing staff engaged in the repair or maintenance of the water distribution system. Positions in the Field Inspector class series are flexibly staffed; positions at the II-level may be filled by advancement from the I-level. REPRESENTATIVE DUTIES Inspects various facilities plumbing systems including industrial, commercial, residential, educational, licensed health care, and high-rise buildings to verify compliance with cross-connection regulations. Provides information to appropriate local and state agencies including violation reports and compliance status of local businesses. Issues notices and citations when code violations have not been corrected. May read, inspect and repair water meters/water services/water mains. Performs emergency work on water main breaks and related emergencies as required; assists with temporary and emergency water shutdowns. May turn on and shuts off water as tenants move into or vacate a building. Investigates and resolves complaints regarding water pressure, quality and billing. Communicates orally or in writing with customers concerning delinquent accounts and code violations. Responds to emergencies during non-scheduled working hours, as required. Resolves issues related to hydrant meters including establishing contact with contractors, issuing work orders, and monitoring the progress of renewals. Provides information and assistance to engineers, architects and contractors including backflow prevention device specifications and installation requirements, solutions to eliminate cross connection problems, and related issues which ensures the health and safety of the general public. Inspects recycled water use and ensures proper installation of backflow devices. Coordinates inspection activities with user departments and outside agencies including Los Angeles County Health Department. May assist with the drafting and review of policies, guidelines and reports. Leads, coordinates, and participates in the inspection and verification of residential, commercial, and industrial establishments comply with water code regulations. Coordinates and conducts meetings with user departments, outside agencies, contractors, and consultants related to recycled water use. Reviews and approves construction plans for recycled water project specifications and related compliance issues. Inspects recycled water lines and ensures proper installation of backflow devices. Assists with the development of construction standards and drawings and coordination of construction activities with City staff, contractors and consultants, including installation of service connections, backflow devices, and meters. Maintains and organizes pertinent records and files. Maintains records using a computer tracking system and prepares related reports and correspondence. Serves as liaison between the City and various outside government agencies, businesses and citizen on various water related issues. Performs other duties, as assigned. Requirements Knowledge of: Laws and Codes related to water distribution systems and cross-connection control including the Uniform Plumbing Code and California Code of Regulations Construction methods related to water distribution and reclaimed wastewater use safety Basic plumbing Best management practices Cross-connection control practices Relevant utility and plumbing codes Principles of customer service Effective customer service techniques Supervisory techniques Ability to: Inspect general engineering projects for compliance issues related to water and plumbing regulations and the application of best management practices Read and repair water meters Prepare reports and forms Analyze and resolve water meter problems Read blueprints Enforce health and safety codes related to water quality and water system construction Communicate effectively both orally and in writing Analyze, resolve and report water service problems Work as part of a team and participate in establishing a cohesive work environment Conduct cross-connection surveys Operates a variety of equipment, tools and heavy equipment Explain City policies in a courteous and effective manner Provide effective customer service Establish and maintain effective and cooperative working relationships with City employees and the public Work with persons from diverse social, cultural and economic backgrounds as well as a variety of work styles, personalities, and approaches Identify problems and recommend solutions Work independently and meet established deadlines Coordinate, select, train and supervise staff, as assigned REQUIREMENTS Minimum Qualifications: Education: Graduation from high school or the equivalent. C ollege level coursework in water production, water distribution, and cross-connection control is desirable. Experience: Two years of recent, paid work experience in construction or maintenance which has included performing job duties related to water services. Experience performing field inspections for water code violations and utility is desirable. Municipal experience is desirable. Licenses and Certifications: Possession of a valid Class C driver license. Possession of, or successfully obtain within one year from date of appointment, a valid Class B California Driver’s License to be maintained throughout employment. Possession of, or successfully obtain within six months from date of appointment, a valid Forklift Operator certification, to be maintained throughout employment. Must obtain a Cross-Connection Control Program Specialist Certificate, issued by the University of California Foundation for Cross-Connection Control and Hydraulic Research within one year of date of appointment. Must obtain a Backflow Prevention Assembly Tester Certificate issued by the University of California Foundation for Cross-Connection Control and Hydraulic Research within one year of date of appointment. Must obtain and maintain a Los Angeles County Backflow Prevention Device Tester Certification within one year of date of appointment. Possession and maintenance of a Grade D1 California State Water Resources Control Board (SWRCB) Water Distribution Operator Certificate. Must successfully obtain and maintain a Grade D2 California SWRCB Water Distribution Operator Certificate within one year from date of appointment. WORKING CONDITIONS The work is regularly performed indoors in an office environment and outside in climatic weather conditions at various work sites. Work requires exposure to sewer discharge, chemicals, and occasionally unsanitary conditions. Some tasks may require the use of respiratory protection. Physical demands include standing, sitting, walking, infrequent heavy lifting, carrying, climbing (stairs and ladders), bending and crawling. May be required to work during evening hours, weekends, holidays and during emergencies. Supplemental Information HOW TO APPLY: An online City application must be completed to be considered for this position. All applicants will be reviewed and only those candidates determined to be qualified for the position on the basis of experience, training and education as submitted, will be invited to participate further in the selection process. Resumes, CVs and cover letters are not reviewed as part of the application screening process. NOTE: You must upload a copy of your Grade D1 certification to your online application. Failure to do so will result in your application being disqualified. SELECTION PROCESS: All applicants will be reviewed and only those candidates determined to be qualified on the basis of experience, training and education, as submitted, will be invited to participate further in the selection process. Testing may consist of the following: Written Test: Pass/Fail Tentatively scheduled 6/13/24 Oral Interview: 100% Tentatively scheduled 6/25/24 BACKGROUND INVESTIGATIONS: Candidates who have successfully completed all prior phases of the selection process will be subject to a thorough background investigation. NOTE: If three or more qualified City employees apply and pass the examination, a promotional list will be established in addition to an open-competitive list. If fewer than three qualified City employees pass the examination, the appointing authority, in accordance with the City's civil service rules and regulations, can decline to use a promotional list, in which case a promotional list will not be established for this position. Inclusion & Diversity Statement The City of Santa Monica is a progressive, inclusive and culturally rich community. As leaders in public service, we strive to be an employer of choice by attracting and retaining a highly talented workforce where people of diverse races, religions, cultures and lifestyles thrive. Our goal is to create a welcoming and inclusive environment where our staff are empowered to perform at their highest level and where their differences make a positive impact. The City is an equal opportunity employer and strives to build balanced teams from all walks of life without regard to race, color, ethnicity, religion, national origin, age, sex, sexual orientation, gender identity, marital status, ancestry, disability, genetic information, veteran status, or any other status protected under federal, state and/or local law. We aim to create a workplace that celebrates and embraces the diversity of our employees. Join us! Special assistance with the application and examination process is available, upon request, for persons with disabilities. Call (310) 458-8246, TDD (310) 458-8696 (Hearing Impaired Only). Please note the request for reasonable accommodations must be made to Human Resources at least three work days prior to the examination. The City's liberal fringe benefits for full-time employment include sick leave, holiday and vacation pay, the Public Employees Retirement System, medical, dental and vision insurance, credit union, deferred compensation, tuition reimbursement, Dependent Care Assistance Plan and Marine Park Childcare Center. Closing Date/Time: 5/16/2024 5:30 PM Pacific
Job Summary Assists with implementing and overseeing the City's cross-connection control program, municipal and plumbing code programs and services. Enforces relevant utility and plumbing codes and investigates violations at residential, commercial, construction and development sites. Performs various water division field duties including complaint resolution, delinquent bill collection, leak detection and inspection of water meters and related equipment inspections. Enforces relevant utility and plumbing codes and investigates violations at a variety of sites. Provides assistance in the maintenance and repair of the City’s water distribution system and performs related work as required. SUPERVISION Receives immediate (Field Inspector I) or general (Field Inspector II) supervision from assigned supervisory or management personnel. Field Inspector II provides technical and functional direction to lower-level staff. Representative Duties DISTINGUISHING CHARACTERISTICS Field Inspector I : This is the entry-level classification in the Field Inspector series. Incumbents perform routine tasks in the inspection of various facilities plumbing systems and enforcement of violations. As experience is gained, assignments become more varied, complex, and difficult; supervision and frequent review of work lessen as an incumbent demonstrates skill to perform the work independently. Positions at this level usually perform most of the duties required of the positions at the II-level, but are not expected to function at the same skill level and usually exercise less independent discretion and judgment in matters related to work procedures and methods of operating heavy equipment. Work is usually supervised while in progress and fits an established structure or pattern. Exceptions or changes in procedures are explained in detail as they arise. Field Inspector II : This is the fully qualified journey-level classification in the Field Inspector series. Positions at this level are distinguished from the Field Inspector I by the performance of the full range of duties as assigned including conducting inspections and investigations, working independently, and exercising judgment and initiative. Positions at this level receive only occasional instruction or assistance as new or unusual situations arise and are fully aware of the operating procedures and policies of the work unit. May work in a lead capacity overseeing staff engaged in the repair or maintenance of the water distribution system. Positions in the Field Inspector class series are flexibly staffed; positions at the II-level may be filled by advancement from the I-level. REPRESENTATIVE DUTIES Inspects various facilities plumbing systems including industrial, commercial, residential, educational, licensed health care, and high-rise buildings to verify compliance with cross-connection regulations. Provides information to appropriate local and state agencies including violation reports and compliance status of local businesses. Issues notices and citations when code violations have not been corrected. May read, inspect and repair water meters/water services/water mains. Performs emergency work on water main breaks and related emergencies as required; assists with temporary and emergency water shutdowns. May turn on and shuts off water as tenants move into or vacate a building. Investigates and resolves complaints regarding water pressure, quality and billing. Communicates orally or in writing with customers concerning delinquent accounts and code violations. Responds to emergencies during non-scheduled working hours, as required. Resolves issues related to hydrant meters including establishing contact with contractors, issuing work orders, and monitoring the progress of renewals. Provides information and assistance to engineers, architects and contractors including backflow prevention device specifications and installation requirements, solutions to eliminate cross connection problems, and related issues which ensures the health and safety of the general public. Inspects recycled water use and ensures proper installation of backflow devices. Coordinates inspection activities with user departments and outside agencies including Los Angeles County Health Department. May assist with the drafting and review of policies, guidelines and reports. Leads, coordinates, and participates in the inspection and verification of residential, commercial, and industrial establishments comply with water code regulations. Coordinates and conducts meetings with user departments, outside agencies, contractors, and consultants related to recycled water use. Reviews and approves construction plans for recycled water project specifications and related compliance issues. Inspects recycled water lines and ensures proper installation of backflow devices. Assists with the development of construction standards and drawings and coordination of construction activities with City staff, contractors and consultants, including installation of service connections, backflow devices, and meters. Maintains and organizes pertinent records and files. Maintains records using a computer tracking system and prepares related reports and correspondence. Serves as liaison between the City and various outside government agencies, businesses and citizen on various water related issues. Performs other duties, as assigned. Requirements Knowledge of: Laws and Codes related to water distribution systems and cross-connection control including the Uniform Plumbing Code and California Code of Regulations Construction methods related to water distribution and reclaimed wastewater use safety Basic plumbing Best management practices Cross-connection control practices Relevant utility and plumbing codes Principles of customer service Effective customer service techniques Supervisory techniques Ability to: Inspect general engineering projects for compliance issues related to water and plumbing regulations and the application of best management practices Read and repair water meters Prepare reports and forms Analyze and resolve water meter problems Read blueprints Enforce health and safety codes related to water quality and water system construction Communicate effectively both orally and in writing Analyze, resolve and report water service problems Work as part of a team and participate in establishing a cohesive work environment Conduct cross-connection surveys Operates a variety of equipment, tools and heavy equipment Explain City policies in a courteous and effective manner Provide effective customer service Establish and maintain effective and cooperative working relationships with City employees and the public Work with persons from diverse social, cultural and economic backgrounds as well as a variety of work styles, personalities, and approaches Identify problems and recommend solutions Work independently and meet established deadlines Coordinate, select, train and supervise staff, as assigned REQUIREMENTS Minimum Qualifications: Education: Graduation from high school or the equivalent. C ollege level coursework in water production, water distribution, and cross-connection control is desirable. Experience: Two years of recent, paid work experience in construction or maintenance which has included performing job duties related to water services. Experience performing field inspections for water code violations and utility is desirable. Municipal experience is desirable. Licenses and Certifications: Possession of a valid Class C driver license. Possession of, or successfully obtain within one year from date of appointment, a valid Class B California Driver’s License to be maintained throughout employment. Possession of, or successfully obtain within six months from date of appointment, a valid Forklift Operator certification, to be maintained throughout employment. Must obtain a Cross-Connection Control Program Specialist Certificate, issued by the University of California Foundation for Cross-Connection Control and Hydraulic Research within one year of date of appointment. Must obtain a Backflow Prevention Assembly Tester Certificate issued by the University of California Foundation for Cross-Connection Control and Hydraulic Research within one year of date of appointment. Must obtain and maintain a Los Angeles County Backflow Prevention Device Tester Certification within one year of date of appointment. Possession and maintenance of a Grade D1 California State Water Resources Control Board (SWRCB) Water Distribution Operator Certificate. Must successfully obtain and maintain a Grade D2 California SWRCB Water Distribution Operator Certificate within one year from date of appointment. WORKING CONDITIONS The work is regularly performed indoors in an office environment and outside in climatic weather conditions at various work sites. Work requires exposure to sewer discharge, chemicals, and occasionally unsanitary conditions. Some tasks may require the use of respiratory protection. Physical demands include standing, sitting, walking, infrequent heavy lifting, carrying, climbing (stairs and ladders), bending and crawling. May be required to work during evening hours, weekends, holidays and during emergencies. Supplemental Information HOW TO APPLY: An online City application must be completed to be considered for this position. All applicants will be reviewed and only those candidates determined to be qualified for the position on the basis of experience, training and education as submitted, will be invited to participate further in the selection process. Resumes, CVs and cover letters are not reviewed as part of the application screening process. NOTE: You must upload a copy of your Grade D1 certification to your online application. Failure to do so will result in your application being disqualified. SELECTION PROCESS: All applicants will be reviewed and only those candidates determined to be qualified on the basis of experience, training and education, as submitted, will be invited to participate further in the selection process. Testing may consist of the following: Written Test: Pass/Fail Tentatively scheduled 6/13/24 Oral Interview: 100% Tentatively scheduled 6/25/24 BACKGROUND INVESTIGATIONS: Candidates who have successfully completed all prior phases of the selection process will be subject to a thorough background investigation. NOTE: If three or more qualified City employees apply and pass the examination, a promotional list will be established in addition to an open-competitive list. If fewer than three qualified City employees pass the examination, the appointing authority, in accordance with the City's civil service rules and regulations, can decline to use a promotional list, in which case a promotional list will not be established for this position. Inclusion & Diversity Statement The City of Santa Monica is a progressive, inclusive and culturally rich community. As leaders in public service, we strive to be an employer of choice by attracting and retaining a highly talented workforce where people of diverse races, religions, cultures and lifestyles thrive. Our goal is to create a welcoming and inclusive environment where our staff are empowered to perform at their highest level and where their differences make a positive impact. The City is an equal opportunity employer and strives to build balanced teams from all walks of life without regard to race, color, ethnicity, religion, national origin, age, sex, sexual orientation, gender identity, marital status, ancestry, disability, genetic information, veteran status, or any other status protected under federal, state and/or local law. We aim to create a workplace that celebrates and embraces the diversity of our employees. Join us! Special assistance with the application and examination process is available, upon request, for persons with disabilities. Call (310) 458-8246, TDD (310) 458-8696 (Hearing Impaired Only). Please note the request for reasonable accommodations must be made to Human Resources at least three work days prior to the examination. The City's liberal fringe benefits for full-time employment include sick leave, holiday and vacation pay, the Public Employees Retirement System, medical, dental and vision insurance, credit union, deferred compensation, tuition reimbursement, Dependent Care Assistance Plan and Marine Park Childcare Center. Closing Date/Time: 5/16/2024 5:30 PM Pacific
City of Los Angeles
City Of Los Angeles, California, United States
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 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, September 13, 2024 to Thursday, September 26, 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, SEPTEMBER 13, 2024 and THURSDAY, SEPTEMBER 26, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between TUESDAY, NOVEMBER 5, 2024 and TUESDAY, NOVEMBER 12, 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, SEPTEMBER 13, 2024 and THURSDAY, SEPTEMBER 26, 2024 , it is anticipated that interviews will begin during the period of DECEMBER 2, 2024 to DECEMBER 13, 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: $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 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, September 13, 2024 to Thursday, September 26, 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, SEPTEMBER 13, 2024 and THURSDAY, SEPTEMBER 26, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between TUESDAY, NOVEMBER 5, 2024 and TUESDAY, NOVEMBER 12, 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, SEPTEMBER 13, 2024 and THURSDAY, SEPTEMBER 26, 2024 , it is anticipated that interviews will begin during the period of DECEMBER 2, 2024 to DECEMBER 13, 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