9 jobs found

ABOUT THE POSITION The Clark County Information Technology Department is seeking qualified candidates to apply for the Programmer Analyst I/II position. This position performs applications systems design and modification and programming of a routine to complex nature in support of County and local government administrative and business services for multiple computer platform applications. This is an open and continuous recruitment, scheduling dates will vary depending on when the application was received and reviewed by Human Resources. Programmer Analyst I: $29.44 - $45.66 Hourly Programmer Analyst II: $31.79 - $49.33 Hourly The Programmer Analyst I is a training underfill position, upon successful completion of the training program the successful candidate will be non-competitively promoted to Programmer Analyst II. This examination will establish an Open Competitive Eligibility list to fill current and/or future vacancies that may occur within the next six (6) months at either level or may be extended as needed by Human Resources. Human Resources reserves the right to call only the most qualified applicants to the selection process. MINIMUM REQUIREMENTS Education and Experience: Programmer Analyst I - Equivalent to a Bachelor's Degree in Computer Science, Management Information Systems, or a related field. Some large-scale programming and/or systems analysis experience is desirable. Additional experience in systems analysis and/or programming may be substituted for the education on a year-for-year basis to a maximum of two (2) years. Programmer Analyst II - In addition to the above: Two (2) years of full-time professional level experience in systems analysis and programming in a large multi-processing environment. Qualifying education and experience must be clearly documented in the “Education” and “Work Experience” sections of the application. Do not substitute a resume for your application or write "see attached resume" on your application. Working Conditions: Work extended shifts or be called back in emergency situations. Licensing and Certifications: Specified positions must possess a valid Nevada Class C Driver's License at time of appointment. Background Investigation: Employment is contingent upon successful completion of a background investigation. Periodically after employment background investigations may be conducted. Pre-Employment Drug Testing: Employment is contingent on the results of a pre-employment drug examination. EXAMPLES OF DUTIES Gathers and analyzes information regarding customer systems and requirements and develops or modifies automated systems to fulfill these needs. Conducts feasibility studies and develops system, time, equipment and cost requirements. Using computer generated techniques, simulates hardware and software problems, tests and evaluates alternative solutions, and recommends and implements appropriate applications design. Develops program logic and processing steps; codes programs in varied languages. Plans and develops test data to validate new or modified programs; designs input and output forms and documents. Troubleshoots software problems as needed, for customers, other agencies and information systems personnel. Writes program documentation, customer procedures and instructions; assists customer departments and staff in implementing new or modified programs and applications; tracks and evaluates project and systems progress. Writes utility programs to support and validate adopted systems and programs. Confers with user department staff regarding assigned functional program areas. Maintains records and prepares periodic and special reports of work performed. Maintains current knowledge of technology and new computer customer applications. Contributes to the efficiency and effectiveness of the unit's service to its customers by offering suggestions and directing or participating as an active member of a work team. Uses standard office equipment in the course of the work; may drive a personal or County motor vehicle or be able to provide for appropriate transportation between various work sites, depending upon departments and/or projects assigned. PHYSICAL DEMANDS Mobility to work in a typical office setting and use standard office equipment, stamina to remain seated and maintain concentration for an extended period of time, vision to read printed materials and a computer screen, and hearing and speech to communicate in person or over the telephone. Accommodation may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodation. Come Make a Difference and Join the Clark County Family where we offer a comprehensive benefits package that includes: Flexible Schedules including 4/10 options More Money in Your Pocket 100% Employer Paid Defined Benefit Retirement No Social Security Deduction No State Income Taxes Two Employer Sponsored Health Plans Offered - Choice of PPO or EPO (hybrid of HMO) Medical - Employer pays 90% of premium Pharmacy Benefits (30, 90-day retail or mail order fills) 24/7 Telephone Advice Nurse - no employee cost Teledoc, Doctoroo, and Dispatch Health Retiree insurance - eligible after 5 years of service Dental Vision Life Insurance - Employer Paid AD&D - Employer Paid Long Term Disability - Employer Paid Generous Leave Accruals that include: 13Paid Holidays includinga Floating Birthday Holiday Paid Vacation Leave Paid Sick Leave Holiday Leave Other leave options Catastrophic Leave Parental Leave - Up to 90 days Wide Variety of Voluntary Benefits that include Guardian - Accident, Cancer, Critical Illness, Hospital Indemnity, and Short-Term Disability Insurance. Trustmark - Permanent Life Insurance benefits and long-term care. Sunlife Financial - Basic and Voluntary Life Insurance, AD&D, and long-term disability insurance TASC - Flexible Spending Account - FSA & Dependent Day Care Debit Card Available Morgan Stanley - Deferred Compensation Plan Employee Assistance Program Onsite Fitness Center - $12/month*Benefits vary and are subject to change depending on assignment, hiring organization and bargaining unit. Closing Date/Time: Continuous

Description SALARY RANGE: Current: $103,884 - $139,212 Effective July 2024: $106,992 - $143,388 annually There is currently one (1) full-time vacancy (assigned to General Programming). Position works onsite. THE POSITION: Under general supervision, performs work of routine difficulty in the development and modification of software application programs in support of the information processing needs of city departments; to perform both routine and complex technical and administrative tasks related to the development and operation of the system; and to perform related duties as required. Incumbents may be assigned to any of the following assignments: General Programming or Geographic Information Systems (GIS) and related programming. (There is no current vacancy in GIS. This recruitment is for the General Programming assignment) . CLASS CHARACTERISTICS: This position receives functional supervision from the Systems and Programming Supervisor and performs a variety of software analysis functions in support of various user department needs. This position may receive technical direction from the Senior Programmer Analyst in completing particular assignments. This position requires knowledge of a broader range of applications programs, operating systems and division operations than the Programmer Analyst I classification. APPLICATION AND SELECTION PROCESS: Applications will be reviewed on a continuous basis until vacancy is filled. Applications must be completed and submitted online. This recruitment will remain open until filled and may close without prior notice, therefore prompt application is encouraged. Candidates are required to provide specific information regarding their education and experience as it relates to the position by completing all fields of the application. Applications may be rejected if incomplete. Based upon the information presented on the application, a limited number of candidates who possess qualifications most pertinent to the position will be invited to participate in the selection process. The selection process may include, but is not limited to the following components: application review and evaluation, written examination or exercise, physical examination, practical exercise and interview evaluation. Please notify the Human Resources Division 72 hours in advance of the test date if you have a disability which requires accommodation for the testing process. The eligibility list will be in effect for one (1) year, unless exhausted sooner. The eligibility list established from this recruitment may be utilized to fill lower-level vacancies which occur during the life of the list. It is recommended you use a personal email address on your application instead of a work email address. Notifications during this recruitment will be sent by email only (regardless of the notification preference selected during the online application process). Notifications will be sent to the email address that is listed on your online application. All employment offers made by the City are contingent upon establishing proof of a prospective candidate's legal authorization to work in the United States and successfully passing all components of the pre-employment process which includes a comprehensive background investigation facilitated by the Costa Mesa Police Department that includes, but is not limited to, a criminal history check (Live Scan fingerprint check) and a polygraph examination. Please refer to supplemental questions 11-28 for more information. Note: The provisions of this job bulletin do not constitute an expressed or implied contract. Any provisions contained within may be modified or revoked without notice. Essential Functions These functions may not be present in all positions in this class. When a position is to be filled, the essential functions will be noted in the announcement of position availability. Management reserves the right to add, modify, change or rescind work assignments as needed. Provide technical support and guidance to City departments by analyzing user requirements for modifications to existing computer programs and requests for new programs. Research and adopt methods to install new or improve existing software applications. Meet with various department representatives to define specific procedures and activities that can be converted to computer applications programs; answer related questions concerning the feasibility and impact of proposed changes. Establish reasons for application failures and errors, including user errors or application errors. Analyze, debug and document software applications problems. Apply appropriate fixes and upgrades in test mode; check for proper operation before applying software to production environment. Conduct training sessions in computer applications for end users. When assigned to General Programming : (Current vacancy) Create and update processes, programs, and reports to resolve problems such as new application designs, scripts, data tables, formulas, documents, security features and test operations. Provide technical support and guidance to City departments in relational database design, connectivity, access and quality assurance. Create and execute SQL queries and/or Crystal reports. Assist users in learning new software and potential department applications. Responsible for other systems and data such as web application development. To view the complete Programmer Analyst II job description, please click here: Programmer Analyst II Qualification Guidelines A typical way to obtain the requisite knowledge and abilities to perform the duties and responsibilities of this classification is as follows: EDUCATION, TRAINING AND/OR EXPERIENCE: Graduation from an accredited four-year college or university with major course work in management information systems, computer science, mathematics, geography or a related field. Three or more years of progressively responsible experience in computer programming. An equivalent combination of education and relevant experience that provides the desired knowledge, skills and abilities to successfully perform essential functions may also be considered. LICENSE AND/OR CERTIFICATE: Possession of a valid California Driver's License Class C. Revocation of license during employment may result in disciplinary action or reassignment. REQUISITE KNOWLEDGE AND SKILL LEVELS: Knowledge of the principles and practices of computer science, computer programming languages, and processing principles. Knowledge of relational or database concepts, methodology, design and administration. Knowledge of cross-platform computer solutions and software connectivity issues. Knowledge of business processes and workflow. Knowledge of data conversion methodologies. When assigned to General Programming : (Current vacancy) Knowledge of modern software development. Knowledge of accounting, human resources, permitting and specialized database application programs. Knowledge of programming languages including JavaScript, .Net and Java Language. Knowledge of web application development software including Microsoft.Net framework. To view the complete Programmer Analyst II job description, please click here: Programmer Analyst II REQUISITE ABILITIES: Ability to organize and complete work independently and in accordance with established deadlines. Ability to independently analyze and solve a variety of complex computer software application and database utilization problems. Ability to communicate effectively both orally and in writing. Ability to establish and maintain cooperative working relationships with management, supervisors, co-workers, and other departmental representatives. Supplemental Information PUBLIC EMPLOYEE DISASTER SERVICE WORKER: In accordance with Government Code Section 3100 - all City of Costa Mesa employees are required to perform assigned disaster service worker duties in the event of an emergency or a disaster. PHYSICAL TASKS AND ENVIRONMENTAL CONDITIONS: Please contact human resources for a summary of the essential tasks and environmental factors for this classification. Employee accommodations for physical or mental disabilities will be considered on a case-by-case basis. To view benefit information for all groups, Click Here New employees contribute 9% of their salary on a pre-tax basis towards the 2%@60 or 2%@62 CalPERS retirement formula depending on eligibility. Salary Increases: Effective July 2024: 3% increase Employees receive the following health insurance flexible benefits contribution: Current: $1,550monthly Effective January 2024: $1,600monthly Effective January 2025: $1,650monthly The City does not participate in the Social Security system; however, federal mandate requires new employees to contribute 1.45% of wages to Medicare. As a condition of employment, all new employees are required to enroll and participate in the direct deposit program. Closing Date/Time: Continuous

DUTIES ANNUAL SALARY $124,486 to $146,494; $107,782 to $157,581; and $116,802 to $170,735 The salary in the Department of Water and Power is $124,340 to $154,491; $134,070 to $166,559; and $148,248 to $184,182. NOTES : Candidates from the eligible list are normally appointed to vacancies in the lower pay grade positions.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 Systems Programmer (Systems Administrator) evaluates, develops, maintains, implements, and modifies operating systems, hardware, middleware, software, storage, and networking in a business applications environment; performs hardware-software studies; designs and implements systems architecture; analyzes systems problems and optimizes systems performance; performs systems upgrades; follows Information Technology Infrastructure Library (ITIL) and security best practices for incident, change and release management, and all aspects of network and server operations; provides technical assistance to other data processing personnel and user divisions or departments; may supervise and direct the work of employees engaged in such activities; applies sound supervisory principles and techniques in building and maintaining an effective work force; and fulfills equal employment opportunity responsibilities. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor's degree from an accredited four-year college or university; and two (2) years of full-time paid systems implementation experience in either: 1) installing, configuring, maintaining, performance tuning, patching, troubleshooting and securing enterprise level servers and networks; or 2) planning, configuring, and implementing enterprise systems and applications operating over large computing networks serving local and remote facilities; or 3) preparing programs by analyzing specifications developed by systems professionals and determining computer processing requirements, systems and/or programming flowcharts, code programs, and software solutions; or Two years of full-time paid experience with the City of Los Angeles as a Programmer Analyst; or Four years of full-time paid systems implementation experience with the City of Los Angeles as a Systems Analyst with experience in either 1) installing, configuring, maintaining, performance tuning, patching, and securing enterprise level servers; or 2) planning, configuring, and implementing enterprise systems and applications operating over large computing networks serving local and remote facilities. PROCESS NOTES Additional full-time paid experience as described above in Requirement No. 1 may be substituted on a year for year basis for the required bachelor's degree noted in Requirement No.1. One academic year is equivalent to 30 semester or 45 quarter units.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 completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree and/or course work. Applicants who wish to expedite this process may attach a copy of their qualifying degree in the Attachments section of the on-line application at the time of filing. 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 in one or more of the following areas. For such positions, only applicants possessing the specific professional certification(s) at the time of filing, may be considered. A copy of the Certificate of Completion must be submitted at the time of filing. The certificate must be attached to the on-line application BEFORE the application is submitted. If the certificate 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. Applicants who fail to submit the certificate at the time of filing by not attaching it to the on-line application will not be considered for this part of selective certification. AWS Certified Advanced Networking - SpecialtyAWS Certified Alexa Skill Builder - SpecialtyAWS Certified Big Data - Specialty AWS Certified Cloud Practitioner AWS Certified Developer - Associate AWS Certified DevOps Engineer - Professional AWS Certified Machine Learning - Specialty AWS Certified Security - Specialty AWS Certified Solutions Architect - Associate AWS Certified Solutions Architect - Professional AWS Certified SysOps Administrator - Associate CCIE Data CenterCCIE SecurityCCIE WirelessCCNP Data CenterCCNP Routing and SwitchingCCNP WirelessCCNP SecurityCCSACCSECertification as a Certified Information Systems Security Professional (CISSP).Certification as a Checkpoint Certified Security Administrator (CCSA) or as a Checkpoint Certified Security ExpertCertification as a CISCO Certified DevNet AssociateCertification as a CISCO Certified Network Professional (CCNP) or as a CISCO Certified Internetwork Expert (CCIE).Certification as a Cisco Certified Security Professional or as a CISCO Certified Internetwork Expert in Security.Certification as a DNS/BIND AssociateCertification as a Global Information Assurance Certification (G9ac) Security Essentials (GSEC)Certification as a Microsoft Certified System Engineer (MCSE) on Windows server platform.Certification as an Oracle 9i/10g/11g or latest version or as an Oracle Database 10g/11g or latest version of Administrator Certified Master.Certification as CompTIA Security +Certified other Database Provider (such as Microsoft SQL) CCIE Routing and SwitchingCertified with other Linus/Unix Operating System Microsoft Certified Solutions Expert (MCSE)Certified with other Linux/Unit Operating SystemCertified with other Network Provider (such as Juniper.)CISCO Certified DevNet ProfessionalCisco Certified DevNet SpecialistCISSP ISC2Core InfrastructureData center Virtualization 2019 (VCP-DCV 2019); VMWare Certified Advanced Professional 6.5Data Center Virtualization; Cloud Management (VCAP-CMA) (VCP6.5-DCV); Network virtualization (VCP-NV)Financial Management Certified Implementation SpecialistIBM Certified Database Administrator - DB2 for z/OSIBM Certified Deployment Professional Certification as a Sun Certified System Administrator for the Solaris Operating System.IBM Certified Infrastructure Deployment Professional - Maximo Asset Management v7.X VMWare certified ProfessionalIBM Certified System AdministratorIBM Certified System Administrator - DB2 for z/OSJava EnterpriseMicrosoft Certified : Azure Administrator AssociateOracle Certified ProfessionalOracle Database 12c Administrator Certified Master (OCM)Oracle Database 12c Administrator Certified Professional (OCP)Oracle Database 9i/10/11g Administrator Certified Associate (OCA)Oracle Database 9i/10/11g Administrator Certified Professional (OCP)Oracle Database Certified Associate (OCA)Oracle E-Business Suite 12Oracle Solaris11Oracle WebCenter Certified Implementation Specialist' Oracle Certified AssociateOracle WebLogic Server 11g/12c System AdministratorOracle WebLogic Server 12c AdministratorOracle WebLogic Server 12c Certified Implementation Specialist; Oracle Certified ProfessionalPeopleSoft 9.2 Financial Certified Implementation SpecialistPeopleSoft People Tools 8.5 Certified Implementation SpecialistRed Hat Certified System Administrator (RHCSA)SAP Certified Technology Associate - System Administration (Max DB) with SAP NetWeaver 7.4VM Certified Advanced ProfessionalWebSphere Application Server Network Deployment V9.0 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. APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed below: From Friday, September 29, 2023 to Thursday, October 12, 2023 From Friday, January 5, 2024 to Thursday, January 18, 2024 From Friday, April 5, 2024 to Thursday, April 18, 2024 Additional filing periods may be added based on the City’s hiring needs. 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 weighted multiple-choice test in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs 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 Weight: Multiple-Choice Test . . . . . . . .100% The examination will consist entirely of a weighted multiple-choice test administered and proctored on-line. In the on-line multiple-choice test, the following competencies may be evaluated: Analytical Ability; Self-Management; Teamwork; Project Management; Job Knowledge, including knowledge of: capabilities, uses, characteristics, and limitations of servers - virtual, physical and cloud, computers and peripheral equipment, operating software systems (Windows, Linux, Unix, MacOS, etc.), software such as assemblers, generators, subroutine libraries, compilers and vendor written application programs; programming languages such as C/C++, Java, .NET - VB, ASP, MVC, C#, PHP, Perl, Hadoop, Python, PowerShell or command languages for distributed and large scale computers and/or network and associated programming aids; Local Area Networks (LANs), Wide Area Networks (WANs), Metropolitan and cloud networks, and IP Protocols; Storage Area Network (SAN) and Network Attached Storage (NAS); system optimization techniques and performance tuning; storage, backup and disaster recovery procedures, and other business resumption and data protection technologies; framework or detailed plan to prepare documentation, procedures, tests, corrections, and take other steps necessary for the planned implementation and modification of programs; methods to identify security exposures and provide mitigation controls as they apply to information and management information systems including software distribution and patch management in cyber security, software and threats; techniques and tools necessary to support internet, intranet, and cloud application environments; and other necessary skills, knowledge, and abilities. The multiple-choice test will be proctored and administered on-line during a single session. Candidates invited to participate in the on-line multiple-choice test will be able to take the test from a remote location (i.e., their home) using a computer with a webcam and a reliable internet connection. Candidates will receive an e-mail from the City of Los Angeles outlining the dates and specific steps on how to take the multiple-choice test on-line. Candidates who do not complete and submit the multiple-choice test on-line using a computer by the specified date and time will not be considered further in this examination. Additional test dates may be added as needed. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Systems Programmer (Systems Administrator). For candidates who apply between September 29, 2023 and October 12, 2023, it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, NOVEMBER 28, 2023 AND MONDAY, DECEMBER 4, 2023. For candidates who apply between January 5, 2024 and January 18, 2024, it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, MARCH 5, 2024 AND MONDAY, MARCH 11, 2024. For candidates who apply between April 5, 2024 and April 18, 2024, it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, JUNE 4, 2024 AND MONDAY, JUNE 10, 2024. FAQs for on-line testing are available at https://per.lacity.org/faqs/employment-testing-process.html . Due to COVID-19 and social distancing requirements, only candidates who demonstrate a hardship may be offered the option to take the multiple-choice test onsite at a City facility. NOTES : This examination is based on a validation study, and as provided by Civil Service Commission Rule 4.20, the multiple-choice test will not be subject to candidate inspection.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.A final average score of 70% or higher is required to be placed on the eligible list.In conjunction with Civil Service Rules, applicants who are currently eligible City employees 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 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 Systems Programmer (Systems Administrator) multiple-choice test only once every 365 days.Your name may be removed from the open competitive list after six (6) months.Your rank on the eligible list may change as scores of candidates from other administrations of this examination are merged onto one 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 AN 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://personnel.lacity.gov/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:

ABOUT THE POSITION The Clark County District Attorney's Office is seeking qualified candidates to apply for the Data Base Administrator I/II position. This position performs data base development, implementation, maintenance support and related staff training of a routine to complex nature in support of County administrative and business services for centralized and distributed network database applications. Data Base Administrator I: $31.79 - $49.33 Hourly Data Base Administrator II: $34.35 - $53.28 Hourly The Data Base Administrator I is a training underfill position, upon successful completion of the training program the successful candidate will be non-competitively promoted to Data Base Administrator II. This is an open and continuous recruitment, scheduling dates will vary depending on when the application was received and reviewed by Human Resources. Human Resources reserves the right to call only the most qualified applicants to the selection process. Employment is contingent upon the results of a background investigation, which may include both a pre-and post-offer background check for positions within the District Attorney’s Office. MINIMUM REQUIREMENTS Education and Experience: Data Base Administrator I - Equivalent to a Bachelor's Degree in Computer Science, Management Information Systems, or a closely related field AND two (2) years of full-time systems analysis and/or applications programming experience, preferably in a large-scale computer system environment. Data Base Administrator II - In addition to the above: Minimum of one (1) year of full-time professional level experience in complex data base definition and installation in a large-scale computer system environment. Qualifying education and experience must be clearly documented in the “Education” and “Work Experience” sections of the application. Do not substitute a resume for your application or write "see attached resume" on your application. Background Investigation: Employment is contingent upon successful completion of a background investigation. Periodically after employment background investigations may be conducted. Pre-Employment Drug Testing: Employment is contingent upon the results of a pre-employment drug examination. EXAMPLES OF DUTIES Plans, prepares, defines, structures, develops and implements data base systems. Defines and implements interfaces to insure that various applications and user-installed or vendor-developed systems interact with the required data base systems. Tests, troubleshoots, refines and documents systems; applies quality assurance and security standards to ensure against the loss of data and a minimal interruption of usage in the event of equipment failure. Plans and develops test data to validate new or modified data base applications; monitors system performance by the use of appropriate utilities, online capabilities and batch reports. Confers with programmer/analyst and customer staff to define functional requirements, perform data modeling and implement final products; resolves errors and interface problems and ensures integrated systems in accordance with development standards. Writes program documentation and user procedures and instructions and assists user departments and staff in implementing new or modified data base applications; tracks and evaluates project and systems progress. Confers with customer staff regarding assigned functional program areas; serves on a variety of committees, project teams and task forces and provides "help desk" support, as assigned. Maintains records and prepares periodic and special reports of work performed. Maintains current knowledge of technology and data base applications and systems. Contributes to the efficiency and effectiveness of the unit's service to its customers by offering suggestions and directing or participating as an active member of a work team. Uses standard office equipment in the course of the work; may drive a County motor vehicle or be able to arrange for appropriate transportation between various work sites. PHYSICAL DEMANDS Mobility to work in a typical office setting and use standard office equipment, stamina to remain seated and maintain concentration for an extended period of time, vision to read printed materials and a computer screen, and hearing and speech to communicate in person or over the telephone. Accommodation may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodation. Come Make a Difference and Join the Clark County Family where we offer a comprehensive benefits package that includes: Flexible Schedules including 4/10 options More Money in Your Pocket 100% Employer Paid Defined Benefit Retirement No Social Security Deduction No State Income Taxes Two Employer Sponsored Health Plans Offered - Choice of PPO or EPO (hybrid of HMO) Medical - Employer pays 90% of premium Pharmacy Benefits (30, 90-day retail or mail order fills) 24/7 Telephone Advice Nurse - no employee cost Teledoc, Doctoroo, and Dispatch Health Retiree insurance - eligible after 5 years of service Dental Vision Life Insurance - Employer Paid AD&D - Employer Paid Long Term Disability - Employer Paid Generous Leave Accruals that include: 13Paid Holidays includinga Floating Birthday Holiday Paid Vacation Leave Paid Sick Leave Holiday Leave Other leave options Catastrophic Leave Parental Leave - Up to 90 days Wide Variety of Voluntary Benefits that include Guardian - Accident, Cancer, Critical Illness, Hospital Indemnity, and Short-Term Disability Insurance. Trustmark - Permanent Life Insurance benefits and long-term care. Sunlife Financial - Basic and Voluntary Life Insurance, AD&D, and long-term disability insurance TASC - Flexible Spending Account - FSA & Dependent Day Care Debit Card Available Morgan Stanley - Deferred Compensation Plan Employee Assistance Program Onsite Fitness Center - $12/month*Benefits vary and are subject to change depending on assignment, hiring organization and bargaining unit. Closing Date/Time: Continuous

DUTIES ANNUAL SALARY $73,789 to $107,886; $78,738 to $115,111; $85,921 to $125,614; $93,041 to $136,033; and $100,203 to $146,494 The salary in the Department of Water and Power is $97,572 to $121,229; $104,316 to $129,623; $114,150 to $141,837; $123,588 to $153,530; and $132,817 to $164,993. NOTES : Candidates from the eligible list are normally appointed to vacancies in the lower pay grade positions. 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 Programmer Analyst (Software Developer) does technically difficult programming and application or software support; analyzes existing systems and procedures; determines the feasibility of data processing applications; designs and participates in the implementation of systems of computer programs; and may act as a lead analyst or project leader in supervising technical employees who are performing such work. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor's degree from an accredited four-year college or university with completion of 24 semester or 36 quarter units in information systems, computer engineering, or computer science and two years of full-time paid experience in the analysis, design, development, testing, and implementation of software applications; or Two years of full-time paid experience as an Applications Programmer with the City of Los Angeles. Additional full-time paid programming analyst experience as described in Requirement #1 above may be substituted on a year for year basis for the required bachelor's degree. One academic year is equivalent to 30 semester or 45 quarter units. 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).Experience working in one or more of the following areas is highly preferred: Internet and/or Client/Server Applications utilizing programs such as .NET Framework (C# or VB.NET); ASP.Net; PeopleSoft; PeopleTools; ColdFusion; Java; Javascript; PowerBuilder; C/C++; UDB; PL SQL for Oracle; Transact SQL for SQL Server with Oracle or SQL Server as a backend; Component Object Model (COM); HTML 5; JQuery; AJAX; DB2 as a backend; and MYSQL as a backend;Web services implementation, SOAP and different Remote Procedure Call technologies such as .NET Remoting, CORBA DCOM, JAVA RMI, and REST;GIS Programming (Autodesk or ESRI);Object-Oriented Design concepts and Object-Oriented Design patterns;Web servers such as IIS and Apache;Core Computer Programming concepts such as data structures and algorithm design;Relational Database Design concepts such a normalization and entity-relationship diagramming;Implementation of Enterprise Resource Planning (ERP) packages such as AMS Advantage Financial, SAP, PeopleSoft Financials, or Oracle Financials;Business Intelligence (BI) tools such as Cognos Crystal Reports, and Oracle OBIEE;Integrated Development Environments (IDE) such as IBM's Rational Suite or Versata Design Studio;Application Servers such as IBM's Websphere, Oracle, or TOMCAT;Mobile application development technologies such as Apache Cordova and Dojo;Content management system such as Oracle's Application Development Framework. Applicants filing under Requirement No. 1 who did not receive a degree in information systems, computer engineering, or computer science must indicate the required course information, including the course title, the number of units (semester or quarter), date completed, and the name of the school in the Supplemental Questions section of the on-line application at the time of filing. Applicants who fail to do so will not be considered further in this examination and their applications will not be processed. General education courses and elective units taken outside of the specified major/areas need not be listed. We recommend that you have your course work information with you before you go on-line to file your application.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 .Applicants completing the exam 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 in the Attachments section of the on-line application at the time of filing. 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 certifications in one or more of the following areas. Only persons possessing the following at the time of filing may be considered for appointment to fill such positions. Selective Certifications 1 through 23 require Certificates of Completion. You must submit a Certificate of Completion for the following: Certification as a Microsoft Certified Applications Developer, Microsoft Certified Solutions Developer or Microsoft Certified Programmer.Certification as an Oracle Application Developer.Certification as a SAP Solution Consultant or SAP Development Consultant.COBOL/CIS and COBOL using z/OS.DB2: IBM Professional, DB2 (for z/OS); Database Administrator; COBOL Application Programming; IBM Application Developer; CICS Transaction Server for z/OS, IBM System Programmer; CISC Transaction Server V5.2 for z/OS; IBM Certified Application Developer; or DB2 11 for z/OS.Oracle Certified Professional, Java SE 8 Programmer; JAVA SE; JAVA EE; or Java EE Training & CertificationPower BuilderC/CC++Microsoft MCSD App Builder; or Microsoft Visual StudioAdobe ColdFusion 9HTML 5Oracle Advanced PS/SQL; Developer Certified Professional; SQL and PL/SQL Certification PathAJAXOracle People Tools; Application Developer; Certified Expert Certification; PeopleSoft Tools and TechnologySAP Certified Application Associate; Financial Accounting with SAP ERP 6.0 EHP5IBM Deployment Professional FileNet; IBM Certified Specialist; IBM Enterprise Content Management; Filenet Content, Documentum; LaserficheCrystal Reports (SAP); Oracle Business Intelligence; IBM Certified Solution Expert; Cognos BI; or Oracle BI Enterprise Edition (BI EE)jQueryCOBRAAssociate Android Developer; iOS Developer; or iOS Application DevelopmentOracle SOA Suite Certified; Implementation Specialist, Oracle AIA; or PIPHP Technical Certified I - Exstream Software - Design and ProductionOracle Business Intelligence Foundation Suite Certified Implementation Specialist; or Oracle BI PublisherMicrosoft MCSA: SQL Server Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s). Applicants who fail to submit the certificate(s) at the time of filing by not attaching it to the on-line application will not be considered for this part of selective certification. 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. APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed below: Thursday , June 29, 2023 to Thursday, July 13, 2023 Friday, October 6, 2023 to Thursday, October 19, 2023 Additional filing periods may be added based on the City’s hiring needs. 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 weighted multiple-choice test in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs 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 Weight: Multiple-Choice Test: 100% The examination will consist entirely of a weighted multiple-choice test administered and proctored on-line. In the on-line multiple-choice test the following competencies may be evaluated: Analytical Ability; Attention to Detail; Customer Service; Teamwork; Follow Written Directions; Job Knowledge, including knowledge of: database and programming languages such as C#, C++, HTML5, Java, Javascript, VB, Coldfusion , PHP, .NET, Pearl, mobile programming languages, SQL queries, stored procedures, triggers, views, and big data tools; the systems development life cycle (SDLC) and the required documentation; technical design and documentation such as data modeling, database, flowcharts and diagrams; database platforms and structures such as Oracle, SQL, DB2, big data infrastructures, relational, hierarchical, and object-oriented; and other necessary skills, knowledge and abilities. The multiple-choice test will be proctored and administered on-line during a single session. Candidates invited to participate in the on-line multiple-choice test will be able to take the test from a remote location (i.e., their home) using a computer with a webcam and a reliable internet connection. Candidates will receive an e-mail from the City of Los Angeles outlining the dates and specific steps on how to take the multiple-choice test on-line. Candidates who do not complete and submit the multiple-choice test on-line using a computer by the specified date and time will not be considered further in this examination. Additional test dates may be added as needed. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Programmer Analyst (Software Developer). For candidates who apply between June 29 , 2023 and July 13, 2023 , it is anticipated that the on-line multiple-choice test will be administered between WEDNESDAY, AUGUST 30, 2023 AND TUESDAY, SEPTEMBER 5, 2023. For candidates who apply between October 6, 2023 and October 19, 2023 , it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, DECEMBER 12, 2023 AND MONDAY, DECEMBER 18, 2023 . FAQs for on-line testing are available at https://per.lacity.org/faqs/employment-testing-process.html . Due to COVID-19 and social distancing requirements, only candidates who demonstrate a hardship may be offered the option to take the multiple-choice test onsite at a City facility. NOTES : This examination is based on a validation study and as provided by Civil Service Commission Rule 4.20, the multiple-choice test will not be subject to candidate inspection.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.A final average score of 70% or higher is required to be placed on the eligible list.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 Programmer Analyst (Software Developer) multiple-choice test only once every 24 months under this bulletin. Your name may be removed from the open competitive list after six (6) months.Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one 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. 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 $64,915 to $94,941 The salary in the Department of Water and Power is $76,921 to $95,567 and $88,907 to $110,455. NOTES : Candidates from the eligible list are normally appointed to vacancies in the lower pay grade positions.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. An Applications Programmer (IT Specialist) prepares programs by analyzing specifications developed by systems professionals; determines computer processing requirements; develops systems and/or programming flowcharts, codes programs and/or integrates and enhances Commercial Off the Shelf (COTS) software solutions; tests, debugs, and corrects errors in programs; prepares program and systems documentation; assists in analyzing and resolution of computer systems problems; and performs basic network configuration, scripting, network and implementation tasks; maintains configuration databases and related processing; write SQL queries and distribute routine reporting for RDBMS; and performs other related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) Graduation from an accredited four-year college or university with completion of 24 semester or 36 quarter units in either information systems, computer engineering, or computer science; or Successful completion of a two-year course of study in information technology (IT) from an accredited college or trade school with at least 12 semester or 18 quarter units in IT coursework and two years of full-time paid experience performing systems or programming tasks in a professional IT environment. PROCESS NOTES Applicants must list in the Supplemental Questions section of the on-line application IT coursework, including courses taken in information systems, computer engineering or computer science. Applicants must list the course title, the number of units (semester or quarter), date completed, the name of the school, and the grade received. For classes in which applicants are currently enrolled, applicants will need to list the course title, the number of units (semester or quarter), anticipated completion date, and the name of the school. General education courses and elective units taken outside of the specified major/areas need not be listed. We recommend that applicants have their course work information at hand before going on-line to file their applications.Employment as an Applications Programmer (IT Specialist) is limited to a maximum of three years, during which time employees are required to promote to other City classes.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. Applicants completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying four-year degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree or transcripts in the Attachments section of the on-line application at the time of filing. 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 http://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. APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed below: From Friday, September 29, 2023 to Thursday, October 12, 2023 From Friday, March 15, 2024 to Thursday, March 28, 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 multiple-choice test in the following order: 1) Applicants currently employed by the City of Los Angeles who meet the minimum requirements, or are on a reserve list; 2) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified applicants. 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 Weight: Multiple-Choice Test: 100% The examination will consist entirely of a weighted multiple-choice test administered and proctored on-line. In the on-line multiple-choice test, the following competencies may be evaluated: Reading Comprehension; Fact Finding; Interpersonal Skills; Mathematics; Written Communication; Job Knowledge, including knowledge of: structured programming and object oriented techniques such as sequence, selection, iteration, encapsulation and data abstraction; terminology necessary to read, understand, and accurately follow program specifications; software standard products such as databases, spreadsheets, utility programs, and graphics used to create and maintain databases, graphs, and spreadsheets; how to program and maintain code in an object oriented language such as Java, C++, .NET, JavaScript, PHP, or C#; database concepts and design requirements such as database structure for programming purposes, data relationships, and access techniques; phases of the entire system development life cycle; problem tracking and/or debugging software tools and techniques to assess problems and troubleshoot within an application; concepts of systems analysis and design as related to the development of operating and networking systems; and other necessary knowledge, skills, and abilities. The multiple-choice test will be proctored and administered on-line during a single session. Candidates invited to participate in the on-line multiple-choice test will be able to take the test from a remote location (i.e., their home) using a computer with a webcam and a reliable internet connection. Candidates will receive an e-mail from the City of Los Angeles outlining the dates and specific steps on how to take the multiple-choice test on-line. Candidates who do not complete and submit the remote proctored multiple-choice test on-line using a computer by the specified date and time will not be considered further in this examination. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Applications Programmer (IT Specialist). For candidates who apply between Friday, September 29, 2023 and Thursday, October 12, 2023, it is anticipated that the on-line multiple-choice test will be administered between Tuesday, November 28, 2023 and Monday, December 4, 2023. For candidates who apply between Friday, March 15, 2024 and Thursday, March 28, 2024 , it is anticipated that the on-line multiple-choice test will be administered between Tuesday, May 14, 2024 and Monday, May 20, 2024. FAQs for on-line testing are available at https://per.lacity.org/faqs/employment-testing-process.html . Due to COVID-19 and social distancing requirements, only candidates who demonstrate a hardship may be offered the option to take the multiple-choice test onsite at a City facility. NOTES : This examination is based on a validation study and as provided by Civil Service Commission Rule 4.20, the multiple-choice test will not be subject to candidate inspection.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.You may take the Applications Programmer (IT Specialist) multiple-choice test only once every 365 days under this bulletin. If you have taken the Applications Programmer (IT Specialist) multiple-choice test during an open filing period in the Personnel Department within the last 365 days, 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 eligible 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 ONLY ON AN 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. 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

Description **This recruitment is being conducted to establish an eligibility list for future vacancies .** What do you value in your next job? At the Orange County Sanitation District our Core Values form the framework of our organization and reinforce our professional work ethic. If the following values ring true with you, we'd love to invite you to explore our career opportunities further. Integrity, Inclusion, Honesty, and Respect We aspire to the highest degree of integrity, inclusion, honesty, and respect in our interaction with each other, our suppliers, our customers, and our community. We strive to demonstrate these values in our actions, commitments, and service. Leadership, Teamwork, and Problem Solving We lead by example, acknowledging the value of our resources and using them wisely to achieve our mission. We strive to reach OC San goals through cooperative efforts and collaboration with each other and our constituencies. We work to solve problems in a creative, cost-effective, and safe manner, and we acknowledge team and individual efforts. Customer Service, Transparency, and Accountability We are committed to acting in a timely, accurate, accessible, and transparent manner through excellent customer service. We are committed to act in the best interest of our internal and external stakeholders. Resiliency, Innovation, and Learning We continuously develop ourselves, enhancing our talents, skills, and abilities. We recognize that only through personal growth and development will we progress as an agency and as individuals. Safety We are committed to providing a safe work environment. We will demonstrate leadership, promote individual accountability, and participate actively in the advancement of our health and safety practices. OC San is currently looking to fill the role of an IT Analyst II (PLC/DCS Programmer) . The candidate should be experienced in programming, configuring, testing, troubleshooting, administering, and maintaining control systems for wastewater, water, and industrial systems. Under general supervision or direction, the IT Analyst II: Performs routine to moderately complex Programmable Logic Controller / Distributed Control System (PLC/DCS) and Human Machine Interfaces (HMI) programming to support projects as assigned. Performs routine PLC/DCS modification requests for Operations as assigned. Supports commissioning and field testing of control systems. Reviews routine to moderately complex design submittals and provides comments to improve conformity to standards and guidelines. Reviews routine to moderately complex construction submittals and identifies any deviations from contract documents. Participates in project meetings to keep informed of the project schedule and identify any risks that need to be addressed. Follows established guidelines and/or direction from assigned project manager. Works independently, and work is reviewed upon completion to ensure it is completed in according to the guidelines and standards. Stays abreast of new trends and innovations in the field of industrial control systems. Uses tools to remove, install and test equipment including networking equipment, power supplies, fiber optics and cabling. Works in construction sites and around wastewater treatment facilities. Other duties as assigned. Qualifications & Requirements Required: Bachelor's degree from a college or university accredited by the U.S. Department of Education, with major coursework in computer science, information systems, or a related field. One (1) year of work experience in information systems or network programming and analysis. A valid California Class C Driver's License. Any combination of education and experience that provides the required knowledge, skills, and abilities may be qualifying as determined by OC San. Desirables: Proficiency with Microsoft Office Excel, Word and Access. Working knowledge of Schneider Electric Modicon ProWorx NxT and/or Control Expert (formerly Unity) and understanding of Programmable Logic Controllers with experience writing PLC programs in ladder logic or IEC 61131-3 Function Block Diagram. Working knowledge of ABB System 800xA and understanding of Distributed Control Systems. Experience with configuration and development of HMI graphics using Wonderware, DCS or modern HMI platforms. Control systems experience with SCADA systems for wastewater, water, or industrial systems. Recruitment & Selection Process Vacancies: 0 (an eligible list may be established for future vacancies) Apply online at: www.ocsan.gov/jobs APPLICATION FILING DEADLINE: Monday, December 4, 2023, 5:00 P.M. PST. (or until a sufficient number of qualified applications have been received) Hiring Salary Range: $105,539.20 - $116,355.20 /Year (starting salary will be within this range based upon qualifications) Supplemental Information Physical Demands Mobility to work in a standard office setting and use standard office equipment, including a computer; to operate a motor vehicle and visit various OC San sites; this is primarily a sedentary office classification although standing in work areas and walking between work areas may be required; occasionally bend, stoop, kneel, reach, push, and pull drawers open and closed to retrieve and file information; ability to lift, carry, push, and pull materials and objects up to 35 pounds. Vision to read printed materials and a computer screen. Hearing and speech to communicate in person and over the telephone. Finger dexterity to access, enter, and retrieve data using a computer keyboard or calculator and to operate standard office equipment. Environmental Elements Office environment with moderate noise levels, controlled temperature conditions, and no direct exposure to hazardous physical substances. Employees may interact with upset staff and/or public and private representatives in interpreting and enforcing departmental policies and procedures. Other Requirements May be required to work extended hours, including nights, weekends, and holidays when necessary. Probationary Period: All OC San employees, except classifications considered "at-will", are subject to the probationary period provisions as specified in the applicable Memorandum of Understanding, policies, and/or resolutions. Employees who have not yet successfully completed their initial probationary period serve "at-will" and may be released from employment without cause or recourse to any appeal or grievance procedures. Pre-Employment: All employment offers are contingent upon successful completion of OC San's pre-employment process, which includes a background investigation, a physical examination, and a drug screen. Work Location Assignment: Employees will be assigned to a work location based on business needs which may be located at any/all of OC San locations; this work location may be changed at any time. Disaster Service Workers All Orange County Sanitation District employees are designated Disaster Service Workers through state law (California Government Code Section 3100-3109). Employment with the Orange County Sanitation District requires the affirmation of a loyalty oath to this effect. Employees are required to complete all related training as assigned, and to return to work as ordered in the event of an emergency. Other Information For the full range of duties, responsibilities, and essential job functions please review the Classification Specification for this position found on our website. Applicants must clearly demonstrate, through their application materials, that they meet the minimum requirements as outlined in the job announcement and class specification to receive further consideration. However, meeting the minimum requirements does not guarantee an interview. All properly completed applications will be reviewed, and the most appropriately qualified individuals will be invited to continue in the selection process. False statements may be cause for disqualification, removal from the eligible list, or discharge from employment. All statements made on applications are subject to investigation and verification. To ensure your application is accurate and complete, please review the Job Application Guide. Employment is contingent upon successful completion of OC San's pre-employment process, which includes a background investigation and a physical examination. For some positions, this may include a drug screen. False statements may be cause for disqualification, removal from the eligible list, or discharge from employment. All statements made on applications are subject to investigation and verification. Reference Checks will be conducted by OC San to verify employment related information for all potential employees once a contingent job offer is made during the background investigation process. This is done to ensure that individuals who join OC San are well qualified and have a strong potential to be successful in their employment. The extent of the inquiry will depend on the position being applied for, but will at least include: Verification/Reference from current and past employers Confirmation of necessary licenses, certificates, and degrees. Please have all necessary documentation ready. Additional inquiries may be necessary depending on the position for which you are applying. Human Resources will also schedule a post-offer physical examination once a job offer has been made. OC San only accepts applications submitted via our online application system. Applications submitted via mail, fax or email will not be accepted. The provisions of this announcement do not constitute an expressed or implied contract. Any provision contained in this announcement may be modified or revoked without notice. Ten working days paid vacation after one year of service; eleven paid holidays and one floating holiday; sick leave; group life insurance; group disability insurance; group health insurance, dependent coverage available, including medical, dental, and vision, employee contribution is required; a retirement plan (Orange County Employees Retirement System) and the option of participating in a deferred compensation plan as well as other optional benefits. A credit union is available. Benefits are subject to the Board of Directors' periodic determination (usually annually) and the meet and confer process, and are therefore subject to change. The District makes a generous contribution toward the cost of these benefits. 01 PLEASE READ. The information provided on the Supplemental Questions will be used in conjunction with your job application to determine whether you meet the qualification requirements. Failure to provide detailed and complete information may result in your application being rejected. Do not submit a resume in place of completing these Supplemental Questions. Education obtained outside the United States must be comparable to education earned at an accredited school in the United States. We reserve the right to request further information about your academic program, evidence of comparability, or an original transcript. Any information you submit may be verified. When applying for this position, I understand that I must thoroughly complete the Education and Work Experience sections of my application and the Supplemental Questions. This includes a detailed description of each position that I feel qualifies me for the job I am seeking. I have read the above statement and understand that failure to provide sufficient detailed information may result in my application being rejected. I also understand that I may not submit a resume in lieu of filling out the job application or answering the Supplemental Questions. However, I may attach a resume to the application to provide additional information. Yes, I understand. 02 Do you have a bachelor's degree from a college or university accredited by the U.S. Department of Education, with major coursework in computer science, information systems, or a related field? Yes No 03 If you answered no to the previous question, please describe how your combination of education and experience provide the knowledge and skills required for this position. 04 If you answered 'yes' to question #2, please indicate the major and emphasis of your bachelor's degree, as it appears on your diploma. If you answered 'no', type N /A. 05 Do you have one (1) year of work experience in information systems or network programming and analysis. Yes No 06 Do you have one (1) year of work experience in PLC/DCS and HMI control system programming, testing and commissioning? Yes No 07 Please indicate in which of the following areas you can demonstrate strong hands-on experience. Please do not include management or supervisory experience: (Check all that apply) Schneider Electric Modicon ProWorx NxT ladder logic programming software Other ladder logic PLC programming software Schneider Electric Control Expert (or Unity) programming software Other IEC 61131 PLC programming software ABB System 800xA DCS platform programming software Other DCS platform programming software CRISP/32 HMI graphical software Wonderware InTouch or System Platform HMI graphical software Other HMI graphical software, including DCS Schneider Electric Modbus, and Modbus TCP communication protocol Other industrial networking protocols and equipment Cisco networking - switches and routers Microsoft Visual Studio - Visual Basic or C# Microsoft SQL Database or similar Air blown fiber or fiber optic network installation and troubleshooting None of the Above 08 Which of the following best describes your level of proficiency in developing PLC and DCS control system programs? No Experience Beginner Intermediate Advanced 09 Which of the following best describes your level of proficiency with drawing, linking and configuring graphics in applications used to develop HMI graphical systems? No Experience Beginner Intermediate Advanced 10 Briefly describe your experience programming PLC and/or DCS systems. Include manufacturer, model number, programming language (ladder logic, function block, etc.), approximate number of I/O points, and your role on the project. If no experience, type "N/A". 11 Briefly describe your experience configuring HMI systems. Include the software package, approximate number of screens, and your role on the project. If no experience, type "N/A". 12 Are you in possession of or do you have the ability to obtain an appropriate, valid California Class C Driver's License by time of appointment? Yes No 13 All Orange County Sanitation District employees are designated Disaster Service Workers through state law (California Government Code Section 3100-3109). Employment with the Orange County Sanitation District requires the affirmation of a loyalty oath to this effect. Employees are required to complete all related training as assigned, and to return to work as ordered in the event of an emergency. Click on the radio button below to acknowledge you understand these requirements. Yes, I understand. Required Question Closing Date/Time: 12/4/2023 5:00 PM Pacific

DUTIES ANNUAL SALARY $80,701 to $117,992 The salary in the Department of Water and Power is $87,403 to $108,576 and $103,293 to $128,328. NOTES : Candidates from the eligible list are normally appointed to vacancies in the lower pay grade positions. 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 Systems Analyst analyzes procedures, methods and operations of computer-based information systems; designs, implements, and recommends information systems to improve the efficiency and economy of City operations; performs cost benefit and feasibility analyses related to the modification of existing computer-based information systems, the maintenance and support of information systems, or the implementation of new computer-based systems; accesses and analyzes information from automated files using high-level retrieval languages. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) 1. Graduation from an accredited four-year college or university with a major in Computer Science, Information Systems, or a major in a closely related field; or 2. Graduation from an accredited four-year college or university and two years of full-time paid experience in a class at the level of Management Assistant which provides experience in: the development, analysis, implementation or major modification of new or existing computer-based information systems or relational databases; or performing cost benefit, feasibility and requirements analysis for a large-scale computer-based information system; or performing system implementation and support activities including software and hardware acquisition, installation, modifications to system configuration, system and application upgrade installation; or 3. Two years of full-time paid experience as a Systems Aide with the City of Los Angeles; and Satisfactory completion of four courses, of at least three semester or four quarter units each, in Information Systems, Systems Analysis, or a closely related degree program, professional designation, or certificate program from an accredited college or university.At least three of the courses must be from the core courses required in the program, and one course may be from either the required core courses or the prescribed elective courses of the program. A course in systems analysis and design is especially desired, but not required. PROCESS NOTES 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).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. College students within three months of meeting the education requirements indicated under Requirement #1 may file for this examination. However, they cannot be appointed until they can provide proof that the full education requirements have been met.Applicants qualifying under Requirement #2 above must identify in the Supplemental Questions section of the application the specific projects that provide qualifying experience. The minor application, modification or use of existing systems is not considered to be qualifying experience.Four years of full-time paid experience in any of the areas noted in Requirement #2 above may be substituted for the required degree only. The two years' experience in the areas noted is still required to fully meet Requirement #2.Applicants qualifying under Requirement #3 above must list in the Supplemental Question section of the application the name of the school attended, course titles, number of units, completion dates, and grades. General education courses will not meet the education requirement outlined in Requirement #3 . A copy of the offering institution's catalog program description and course list must be attached to the on-line application and submitted to the Personnel Department at the time of filing. Failure to submit the requested documents may result in processing delays and/or disqualification.Applicants completing the exam process will be contacted by the Personnel Department to provide required proof of qualifying four-year degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree in the Attachments section of the on-line application at the time of filing. SELECTIVE CERTIFICATION In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. For such positions, only applicants possessing the specific professional certification(s) at the time of filing may be considered. Some positions will require a professional industry certification(s) in one or more of the following: Adobe Dreamweaver CS6 ACEAdobe Photoshop CS5 or CS6 ACEArcGIS Desktop Developer AssociateBMC Certified AdministratorCisco Certified Entry Networking Technician (CCENT)Cisco Certified Network Associate (CCNA)Citrix Certified Associate - Virtualization (CCA-V)CompTIA A+CompTIA Security+Delphi Developer CertificationEnterprise Administration AssociateEnterprise System Design AssociateEnterprise Geodata Management AssociateEnterprise Geodata Management ProfessionalHP Service ManagerIBM Certified Solutions ExpertIBM Certified OperatorIBM Certified Systems AdministratorJAVA SE Programmer CertificationLinux Foundation Certified System Administrator (LFCS)Linux Foundation Certified Engineer (LFCE)MCTS: Administering and Deploying System Center 2012 Configuration ManagerMicrosoft Certified Solutions Associate (MCSA)Microsoft Certified Solutions Developer (MCSD)Microsoft Certified Solutions Expert (MCSE)Microsoft Certified Systems Administrator (MCSA)Microsoft Certified Systems Engineer (MCSE)Microsoft Technology Associate (MTA)Microsoft Technology Associate: IT InfrastructureMicrosoft: Core Solutions of Microsoft SharePoint Server 2013Microsoft: Programming in HTML5 with JavaScript and CSS3Microsoft: Programming in C#Microsoft: Developing ASP.NET MVC Web ApplicationsMicrosoft: Windows Server 2008 Active Directory, ConfiguringMicrosoft: Windows Server 2008, Server AdministratorMicrosoft: Windows 7, ConfiguringMicrosoft: Windows 7, Enterprise Desktop Support TechnicianMicrosoft: Installing and Configuring Windows 10Microsoft: Installation, Storage, and Compute with Windows Server 2016Microsoft: Database FundamentalsCertified Novell Administrator (CNA)Oracle E-Business Suite R12: E-Business EssentialsOracle Database SQL Certified AssociateRed Hat Certified System Administrator (RHCSA)Unix System AdministrationVMware Certified Associate 6 - Data Center VirtualizationVMware Certified Professional 6.5 - Data Center Virtualization Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s). Applicants who fail to submit the certificate(s) at the time of filing by not attaching it to the on-line application will not be considered for this part of selective certification. 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. APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed below: Thursday, October 26, 2023 to Thursday, November 9, 2023 Friday, February 9, 2024 to Thursday, February 22, 2024 Friday, May 31, 2024 to Thursday, June 13, 2024 Additional filing periods may be added based on the City’s hiring needs. 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 weighted multiple-choice test in the following order: 1) Los Angeles City Promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs 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 Weight: Multiple-Choice Test: 100% The examination will consist entirely of a weighted multiple-choice test administered and proctored on-line. In the on-line multiple-choice test, the following competencies may be evaluated: Analytical Ability; Interpersonal Skills; Teamwork; Written Communication; Technology Application, including: office productivity tools and/or software; local area network (LAN) configurations and communication protocols; computer hardware and their use, networking devices, and software tools; various operating systems including their use, interoperability, capabilities, and limitations; basic principles and concepts of database design; systems development life cycle (SDLC) methodology including the associated steps and phases; cloud-based computing services and their use; disaster recovery systems, procedures, and/or best practices; Information Technology Service Management (ITSM) frameworks and methodologies; 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 Systems Analyst. The multiple-choice test will be proctored and administered on-line during a single session. Candidates invited to participate in the on-line multiple-choice test will be able to take the test from a remote location (i.e., their home) using a computer with a webcam and a reliable internet connection. Candidates will receive an e-mail from the City of Los Angeles outlining the dates and specific steps on how to take the multiple-choice test on-line. Candidates who do not complete and submit the multiple-choice test on-line using a computer by the specified date and time will not be considered further in this examination. Additional test dates may be added as needed. For candidates who apply between October 26, 2023 and November 9, 2023 , it is anticipated that the on-line multiple-choice test will be administered between WEDNESDAY, JANUARY 3, 2024 AND TUESDAY, JANUARY 9, 2024. For candidates who apply between February 9, 2024 and February 22, 2024 , it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, APRIL 9, 2024 AND MONDAY, APRIL 15, 2024. For candidates who apply between May 31, 2024 and June 13, 2024 , it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, JULY 30, 2024 AND MONDAY, AUGUST 5, 2024. FAQs for on-line testing are available at https://per.lacity.org/faqs/employment-testing-process.html . Due to COVID-19 and social distancing requirements, only candidates who demonstrate a hardship may be offered the option to take the multiple-choice test onsite at a City facility. NOTES : This examination is based on a validation study and as provided by Civil Service Commission Rule 4.20, the multiple-choice test will not be subject to candidate inspection.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.A final average score of 70% or higher is required to be placed on the eligible list.You may take the Systems Analyst multiple-choice test only once every 365 days.Your name may be removed from the open competitive list after six (6) months.Your rank on the employment list may change as scores of candidates from other administrations of the examination are merged onto one 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://personnel.lacity.gov/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:

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