CITY OF FRESNO, CA
Fresno, California, United States
Position Description RECRUITMENT IS OPEN UNTIL FILLED OR UNTIL A SUFFICIENT NUMBER OF APPLICATIONS HAVE BEEN RECEIVED. RECRUITMENT MAY CLOSE AT ANY TIME. Water Distribution/Production Specialist is the advanced level class which participates in the maintenance, construction and distribution of potable water for the production of ground water for the City's water systems. Incumbents may be required to work evenings, weekends and holidays. Depending upon assignment, incumbents may be assigned work in distribution or groundwater production. Two vacancies currently exist in the Department of Public Utilities - Water Division. Immediate and future vacancies will be filled from this eligible list for a period of six (6) months from the date the eligible list is created, with the option of extending that period at the City's discretion. If the examination process is suspended for this recruitment, the eligible list may be limited to three (3) months. Pay,Benefits, & Work Schedule BENEFITS: UNIT 1 Classification - International Union of Operating Engineers, Stationary Engineers- IUOE (Local 39) HEALTH INSURANCE: The City contributes toward monthly premiums for PPO medical, dental and vision for employee and dependents. FLEXIBLE SPENDING ACCOUNT: IRS 125 Plan for health and dependent care expenses. DEFERRED COMPENSATION: Voluntary 457 plan with Fidelity Investments to increase your retirement savings. VACATION LEAVE: Accrue 8-15 hours per month. SICK LEAVE: Eight (8) hours per month, available after 90 days. SUPPLEMENTAL SICK- 40 hours per fiscal year. 80 hours lifetime maximum HOLIDAYS: Ten (10) City-observed annual holidays plus birthday and two (2) personal days. SHORT TERM DISABILITY: Provided through California SDI program. BILINGUAL PREMIUM: PAY: $100 per month HEALTH REIMBURSEMENT ARRANGEMENT: Eligible retirees can use remaining Sick Leave balance at 80% of hourly rate and other leave balances, if applicable, to reimburse medical insurance and qualified medical expenses, tax free. RETIREMENT: City of Fresno Retirement Systems, one of the best funded public systems in the state. Reciprocity with other public California systems. Vested in Retirement benefits after 5 years of service. City employees do not participate in Social Security. DROP (Deferred Retirement Option Program): an optional, voluntary program that allows an employee to deposit retirement benefits in a special savings account within the Retirement System while continuing to work for the City of Fresno for up to 10 years. Participation minimum is age 50 and vested. Benefits includes ownership of accumulated funds, compound interest earnings, and alternative distribution options. Additional information regarding the City of Fresno benefits is available at https://www.fresno.gov/personnel/human-resources-support/#tab-1 The Requirements Applicants must meet the minimum qualifications on or before the posted filing deadline in order to qualify for the examination and do not assure placement on the eligible list. High School Diploma or GED completion or satisfactory completion of the educational requirements necessary to obtain a valid Water Distribution Operator Certificate, Grade D2, issued by the California State Resources Control Board AND two (2) years of full-time work experience in the testing, cleaning, maintenance, inspection, repair, installation, replacement, construction, distribution and operation of water systems AND possession and continued maintenance of a valid Water Distribution Operator Certificate, Grade D2, issued by the California State Water Resources Control Board. Failure to maintain the valid certification shall be cause for termination from this class. Applicants must attach a copy of their valid D2 certification under Cover Letters and Attachments. Applicants lacking the documentation may be rejected. Possession and continued maintenance of a valid Class "C" California Driver's License. Candidates considered for hire must provide proof of a valid driver's license and current copy of their driving record. Depending on assignment area: 1) may be required to obtain and maintain a valid Commercial Class "A" or "B" California Driver's License with appropriate endorsements for entire term of employment, 2) may be required to obtain and maintain a valid Backflow Certificate by the California State Water Resources Control Board. The selected eligible candidates certified will be required to successfully pass a Department interview and a Department of Justice fingerprint scan prior to employment with the City of Fresno. Please note: Some positions have been designated as being 'safety sensitive' and require all eligibles offered employment to successfully pass a drug test prior to employment. Federal law requires that applicants for positions involving the operation of certain transit vehicles, revenue service vehicles, the transportation of hazardous materials, or heavy equipment over 26,001 pounds requiring a commercial driver's license, must undergo pre-employment drug testing as a condition of employment. This classification is subject to random drug and alcohol testing throughout entire term of employment in this class. How To Apply APPLICANTS MUST COMPLETE AN ON-LINE APPLICATION. PLEASE VISIT www.fresno.gov/jobs. TO APPLY. For information on how to complete an on-line application, please view "Instruction Guide" on the City's website, Personnel Services Career Opportunities page, or call (559) 621-6950 for assistance. Resumes will not be accepted in lieu of a completed employment application. ALL CORRESPONDENCE regarding this recruitment and exam process will be sent via e-mail. All applicants will acknowledge such understanding when they complete their on-line application. Verify we have your correct e-mail address before you submit your application. It is an applicant's responsibility to check their email frequently to ensure they receive all pertinent communication from the Personnel Services Department on a timely basis. Applicants will receive an automatically generated confirmation e-mail upon a successful application submittal. The e-mail is the only proof of submittal. It is an applicant's responsibility to check their email account and to ensure it is set up to accept emails from the City of Fresno. Dependent upon your settings, notices from the City of Fresno may be directed to the "junk mail" or "spam" folders. It is the applicant's responsibility to check these folders. Applications must be submitted by midnight on the filing deadline or they will not be accepted for any reason. FOR THIS RECRUITMENT, IT IS RECOMMENDED THAT PERMANENT FRESNO CITY EMPLOYEES APPLY THROUGH PEOPLESOFT SELF SERVICE. Selection Process The examination process may consist of the following: WRITTEN EXAMINATION - 100%: A job-related written examination will be administered which may test a candidate's knowledge of the materials, methods, practices equipment and tools used in the installation and maintenance of valves, hydrants, water lines, meters, regulators, pumps, surface water and ground water treatment equipment, distribution and water services, basic mathematical principles, ability to communicate effectively in oral and written form, ability to establish and maintain effective working relationships with those contacted in the performance of assigned duties. The written examination has been tentatively scheduled for TO BE DETERMINED. Candidates must achieve a passing score on the Written Examination to qualify for placement on the eligible list. Veteran Preference Regulations Candidates applying for veteran's preference are required to submit a copy of their DD214 with their application during the specified filing period. Evidence must be presented to indicate that the candidate was discharged honorably from the military service. Veterans, including City employees, must resubmit proof of honorable service for every examination for which veteran's preference credit is requested. Qualified veterans who pass the examination will have five (5) points added to their final score. Equal Opportunity Employer The City of Fresno is an Equal Opportunity Employer. Should you need a special accommodation due to a qualifying disability, please contact the Personnel Service Department at (559) 621-6950 in advance of the examination. Closing Date/Time: 03/29/2024
Position Description RECRUITMENT IS OPEN UNTIL FILLED OR UNTIL A SUFFICIENT NUMBER OF APPLICATIONS HAVE BEEN RECEIVED. RECRUITMENT MAY CLOSE AT ANY TIME. Water Distribution/Production Specialist is the advanced level class which participates in the maintenance, construction and distribution of potable water for the production of ground water for the City's water systems. Incumbents may be required to work evenings, weekends and holidays. Depending upon assignment, incumbents may be assigned work in distribution or groundwater production. Two vacancies currently exist in the Department of Public Utilities - Water Division. Immediate and future vacancies will be filled from this eligible list for a period of six (6) months from the date the eligible list is created, with the option of extending that period at the City's discretion. If the examination process is suspended for this recruitment, the eligible list may be limited to three (3) months. Pay,Benefits, & Work Schedule BENEFITS: UNIT 1 Classification - International Union of Operating Engineers, Stationary Engineers- IUOE (Local 39) HEALTH INSURANCE: The City contributes toward monthly premiums for PPO medical, dental and vision for employee and dependents. FLEXIBLE SPENDING ACCOUNT: IRS 125 Plan for health and dependent care expenses. DEFERRED COMPENSATION: Voluntary 457 plan with Fidelity Investments to increase your retirement savings. VACATION LEAVE: Accrue 8-15 hours per month. SICK LEAVE: Eight (8) hours per month, available after 90 days. SUPPLEMENTAL SICK- 40 hours per fiscal year. 80 hours lifetime maximum HOLIDAYS: Ten (10) City-observed annual holidays plus birthday and two (2) personal days. SHORT TERM DISABILITY: Provided through California SDI program. BILINGUAL PREMIUM: PAY: $100 per month HEALTH REIMBURSEMENT ARRANGEMENT: Eligible retirees can use remaining Sick Leave balance at 80% of hourly rate and other leave balances, if applicable, to reimburse medical insurance and qualified medical expenses, tax free. RETIREMENT: City of Fresno Retirement Systems, one of the best funded public systems in the state. Reciprocity with other public California systems. Vested in Retirement benefits after 5 years of service. City employees do not participate in Social Security. DROP (Deferred Retirement Option Program): an optional, voluntary program that allows an employee to deposit retirement benefits in a special savings account within the Retirement System while continuing to work for the City of Fresno for up to 10 years. Participation minimum is age 50 and vested. Benefits includes ownership of accumulated funds, compound interest earnings, and alternative distribution options. Additional information regarding the City of Fresno benefits is available at https://www.fresno.gov/personnel/human-resources-support/#tab-1 The Requirements Applicants must meet the minimum qualifications on or before the posted filing deadline in order to qualify for the examination and do not assure placement on the eligible list. High School Diploma or GED completion or satisfactory completion of the educational requirements necessary to obtain a valid Water Distribution Operator Certificate, Grade D2, issued by the California State Resources Control Board AND two (2) years of full-time work experience in the testing, cleaning, maintenance, inspection, repair, installation, replacement, construction, distribution and operation of water systems AND possession and continued maintenance of a valid Water Distribution Operator Certificate, Grade D2, issued by the California State Water Resources Control Board. Failure to maintain the valid certification shall be cause for termination from this class. Applicants must attach a copy of their valid D2 certification under Cover Letters and Attachments. Applicants lacking the documentation may be rejected. Possession and continued maintenance of a valid Class "C" California Driver's License. Candidates considered for hire must provide proof of a valid driver's license and current copy of their driving record. Depending on assignment area: 1) may be required to obtain and maintain a valid Commercial Class "A" or "B" California Driver's License with appropriate endorsements for entire term of employment, 2) may be required to obtain and maintain a valid Backflow Certificate by the California State Water Resources Control Board. The selected eligible candidates certified will be required to successfully pass a Department interview and a Department of Justice fingerprint scan prior to employment with the City of Fresno. Please note: Some positions have been designated as being 'safety sensitive' and require all eligibles offered employment to successfully pass a drug test prior to employment. Federal law requires that applicants for positions involving the operation of certain transit vehicles, revenue service vehicles, the transportation of hazardous materials, or heavy equipment over 26,001 pounds requiring a commercial driver's license, must undergo pre-employment drug testing as a condition of employment. This classification is subject to random drug and alcohol testing throughout entire term of employment in this class. How To Apply APPLICANTS MUST COMPLETE AN ON-LINE APPLICATION. PLEASE VISIT www.fresno.gov/jobs. TO APPLY. For information on how to complete an on-line application, please view "Instruction Guide" on the City's website, Personnel Services Career Opportunities page, or call (559) 621-6950 for assistance. Resumes will not be accepted in lieu of a completed employment application. ALL CORRESPONDENCE regarding this recruitment and exam process will be sent via e-mail. All applicants will acknowledge such understanding when they complete their on-line application. Verify we have your correct e-mail address before you submit your application. It is an applicant's responsibility to check their email frequently to ensure they receive all pertinent communication from the Personnel Services Department on a timely basis. Applicants will receive an automatically generated confirmation e-mail upon a successful application submittal. The e-mail is the only proof of submittal. It is an applicant's responsibility to check their email account and to ensure it is set up to accept emails from the City of Fresno. Dependent upon your settings, notices from the City of Fresno may be directed to the "junk mail" or "spam" folders. It is the applicant's responsibility to check these folders. Applications must be submitted by midnight on the filing deadline or they will not be accepted for any reason. FOR THIS RECRUITMENT, IT IS RECOMMENDED THAT PERMANENT FRESNO CITY EMPLOYEES APPLY THROUGH PEOPLESOFT SELF SERVICE. Selection Process The examination process may consist of the following: WRITTEN EXAMINATION - 100%: A job-related written examination will be administered which may test a candidate's knowledge of the materials, methods, practices equipment and tools used in the installation and maintenance of valves, hydrants, water lines, meters, regulators, pumps, surface water and ground water treatment equipment, distribution and water services, basic mathematical principles, ability to communicate effectively in oral and written form, ability to establish and maintain effective working relationships with those contacted in the performance of assigned duties. The written examination has been tentatively scheduled for TO BE DETERMINED. Candidates must achieve a passing score on the Written Examination to qualify for placement on the eligible list. Veteran Preference Regulations Candidates applying for veteran's preference are required to submit a copy of their DD214 with their application during the specified filing period. Evidence must be presented to indicate that the candidate was discharged honorably from the military service. Veterans, including City employees, must resubmit proof of honorable service for every examination for which veteran's preference credit is requested. Qualified veterans who pass the examination will have five (5) points added to their final score. Equal Opportunity Employer The City of Fresno is an Equal Opportunity Employer. Should you need a special accommodation due to a qualifying disability, please contact the Personnel Service Department at (559) 621-6950 in advance of the examination. Closing Date/Time: 03/29/2024
CITY OF VENTURA, CA
501 Poli Street, Ventura, California 93001, USA
THE POSITION The City of Ventura Water Department is looking for a Water Quality Specialist to interpret data and ensure compliance of drinking water quality to Federal and State regulations and standards. We are seeking an action-oriented individual who can work independently in gathering and reporting data in a complex water system environment. WHAT YOU'LL DO Reporting to the Water Treatment and Production Manager, the Water Quality Specialist is an expert in water regulatory codes and laws that govern potable water. This Specialist performs high level analytical and technical tasks, setting sampling schedules and interpreting data that guides treatment processes and evaluates water source quality. The City of Ventura currently relies on 100% local water sources - the Ventura River, Lake Casitas, and local groundwater wells, as well as, providing reclaimed water from the Ventura Water Reclamation Facility to two municipal golf courses, the Ventura Marina area, and private customers for landscape irrigation. The Water Quality Specialist evaluates these water sources quality and advises how to best optimize supply. The Specialist administers a cross-connection control and backflow prevention program, which protects the potable water supply from potential sources of contamination via the elimination of existing and potential cross connections. This position also compiles and submits annual consumer confidence and water reports for submission to the State of California. WHO YOU ARE If you the desire to join a dedicated team committed to the production of high-quality water in an environment that changes from day to day, this position may be for you! If through education, training and/or experience you can: demonstrate expertise of State Water Resources Control Board Drinking Water rules and regulations collaborate with other department team members in conducting studies and recommending resolutions be flexible, shifting priorities from day to day or hour to hour as necessary demonstrate sound judgement when responding to review of projects and special studies related to water make recommendations to deliver or improve current methods of treatment technologies ....then you are an ideal candidate for this position. Currently, there is one full-time position available that the City is looking to fill immediately. This recruitment may also be used to fill future vacancies. MORE INFORMATION For additional information on the duties and responsibilities of the position, refer to the job descriptions located on the City's Career Page at www.cityofventura.ca.gov/jobs or by clicking here Water Quality Specialist . THE SCHEDULE This recruitment will follow the below timeline. Wednesday, March 20, 2024, at 5:30pm - Application Deadline. Applications must be submitted by this date to be considered for the position. March 25, 2024 - Candidates will be notified by email of their status by this date. Week of April 1, 2024 - Oral Panel Interview are tentatively scheduled for this date. Qualifying candidates will be notified by email if they are invited to the panel interview process. Week of April 8, 2024 - Department Selection Interviews are tentatively scheduled for this date. Qualifying candidates will be notified by email if they are invited to the panel interview process. April 22, 2024 - Candidates will be notified of the outcome of the interview by this date. The timeline dates are subject to change. Candidates will be notified as necessary. SALARY AND BENEFITS The City offers a total compensation package that includes both a generous salary and other benefits! SALARY : $40.79 - $49.58 Hourly DOQ BENEFITS: Refer to the benefits tab on the job posting for specific information on City benefits. HOW TO APPLY To be considered for this exciting opportunity, please complete an online City Job Application and supplemental questionnaire by the filing deadline, Wednesday, March 20, 2024, at 5:30pm . If you have questions about the recruitment process, please contact Human Resources at recruitment@cityofventura.ca.gov . POSITION QUALIFICATIONS WHAT DOES IT TAKE TO QUALIFY A combination of education, experience, and training equivalent to a bachelor's degree in Chemistry, Biology, Environmental Science or a closely related field and three years of experience in water quality testing and sampling, water distribution, production or treatment is required. Experience in title 22 water regulations, sampling methods, dealing with Certified Laboratories, generating Customer Confidence Reports, and/or familiarity with upcoming regulations such as UCMR, Mn, and forever chemicals, a plus License: Possession of a valid class C driver license or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions. Certificates: State Water Resources Control Board: A Certificate from the State Water Resources Control Board Water Treatment Operator and/or Distribution Operator Grade II or higher is desirable. Ability to enroll in American National Standards Institute accreditation as a Cross Connection Specialist within 6 months of hire is required. APPLICATION AND INTERVIEW PROCESS YOUR APPLICATION Submit an online City job application and supplemental questionnaire by the filing deadline or first review date at www.cityofventura.ca.gov/jobs . It is important that your City job application show all the relevant education, training, and experience you possess. Resumes, CVs and cover letters may be attached to your application but will not be accepted in lieu of a completed job application or supplemental questionnaire. Submitting an incomplete application or supplemental questionnaire, may disqualify you from further consideration in the recruitment process. DEADLINE TO APPLY : Applications and supplemental questions will be accepted until Wednesday, March 20, 2024, at 5:30pm . APPLICATION REVIEW: All applications and supplemental questionnaires submitted will be screened in relation to the criteria outlined in this job announcement. Candidates will be reviewed and only those candidates determined to be most qualified on the basis of experience, training and education, as submitted, will be invited to participate further in the selection process. Candidates will be notified about their status after the filing deadline. INTERVIEW DATES AND INFORMATION : A select number of candidates will be invited to a qualifying panel interview process that is tentatively scheduled for Week of April 1, 2024 . Select candidates will be notified of specifics after the filing deadline. Please note, given the current COVID-19 situation, initial panel interviews may be conducted via video teleconference. Selected applicants will be notified of specifics at the appropriate time. The department selection interviews are tentatively scheduled for Week of April 8, 2024 . Candidates selected to move forward will be notified. The Eligibility List established for this classification may be used to fill other regular and temporary vacancies at the discretion of the City. --------------------------------------------------------------------------------------------------------------------------- In compliance with the Americans with Disabilities Act (ADA), if you need an accommodation in a selection process, please notify the Human Resources Department in writing by the final filing date of the position you are interested in. The Human Resources address is: 501 Poli Street, Room 210, Ventura, CA 93001, (805) 654-7853, e-mail: recruitment@cityofventura.ca.gov. THE ORGANIZATION The City of Ventura operates under the Council/ Manager form of government under a charter adopted by voters in 1934, with an elected seven-member City Council. This full-service municipality is supported by 11 major City departments: City Manager, City Attorney, Finance, Information Technology, Human Resources, Community Development, Parks & Recreation, Fire, Police, Public Works, and Ventura Water. The City's Adopted FY 2023/2024 Operating and Capital budget totals approximately $428.8 million. The City Council and the City Manager are dedicated to the highest standards of integrity, public service, and innovative approaches to governing. To learn more about the City of Ventura, please visit www.cityofventura.ca.gov and view the FY2023-24 Adopted Budget. CITY OF VENTURA The City of Ventura is located just north of Los Angeles County and south of Santa Barbara County and is frequently considered one of America's most desirable places to live. The City is a full-service municipality that was founded in 1782, incorporated in 1866, and serves nearly 110,000 residents within its 32 square miles. With nearly 700 employees, the City is dedicated to delivering key services to our businesses, residents, and visitors to ensure Ventura remains a fiscally stable, economically vibrant, safe, clean, and desirable community. Locals and visitors enjoy Ventura's impressive park system that includes 32 parks and historic sites, and more than 800 acres of open green space. The City offers a remarkable year-round climate, friendly people, and a spectacular coastline. Ventura is an exciting location for a variety of outdoor activities such as biking, hiking, kayaking, paddle-boarding, sailing, surfing, whale watching and windsurfing. Other activities include the Channel Islands National Park, championship golf, world-class shopping, wine tours, and more. Learn more about the City of Ventura at www.CityofVentura.ca.gov DIVERSITY, EQUITY AND INCLUSION The City of Ventura values human rights, goodwill, respect, inclusivity, equality, and recognizes that the City derives its strength from a rich diversity of thoughts, ideas, and contributions. As leaders in public service, we aspire to be an employer of choice by promoting an organizational culture that reflects these core values. We seek to attract, develop, and retain a talented and dedicated workforce where people of diverse races, genders, religions, cultures, political affiliations, and lifestyles thrive. Our goal is to create a welcoming and inclusive environment that empowers our employees to provide the highest level of service to our community of residents and businesses; they're counting on us. The City is an equal opportunity employer and strives to attract qualified applicants from all walks of life without regard to race, color, ethnicity, religion, national origin, age, sex, sexual orientation, gender identity, gender expression, marital status, ancestry, physical disability, mental disability, medical condition, genetic information, military and veteran status, or any other status protected under federal, state and/or local law. We aim to create an environment that celebrates and embraces the diversity of our workforce. We welcome you to join our team! Closing Date/Time: 3/20/2024 5:30 PM Pacific
THE POSITION The City of Ventura Water Department is looking for a Water Quality Specialist to interpret data and ensure compliance of drinking water quality to Federal and State regulations and standards. We are seeking an action-oriented individual who can work independently in gathering and reporting data in a complex water system environment. WHAT YOU'LL DO Reporting to the Water Treatment and Production Manager, the Water Quality Specialist is an expert in water regulatory codes and laws that govern potable water. This Specialist performs high level analytical and technical tasks, setting sampling schedules and interpreting data that guides treatment processes and evaluates water source quality. The City of Ventura currently relies on 100% local water sources - the Ventura River, Lake Casitas, and local groundwater wells, as well as, providing reclaimed water from the Ventura Water Reclamation Facility to two municipal golf courses, the Ventura Marina area, and private customers for landscape irrigation. The Water Quality Specialist evaluates these water sources quality and advises how to best optimize supply. The Specialist administers a cross-connection control and backflow prevention program, which protects the potable water supply from potential sources of contamination via the elimination of existing and potential cross connections. This position also compiles and submits annual consumer confidence and water reports for submission to the State of California. WHO YOU ARE If you the desire to join a dedicated team committed to the production of high-quality water in an environment that changes from day to day, this position may be for you! If through education, training and/or experience you can: demonstrate expertise of State Water Resources Control Board Drinking Water rules and regulations collaborate with other department team members in conducting studies and recommending resolutions be flexible, shifting priorities from day to day or hour to hour as necessary demonstrate sound judgement when responding to review of projects and special studies related to water make recommendations to deliver or improve current methods of treatment technologies ....then you are an ideal candidate for this position. Currently, there is one full-time position available that the City is looking to fill immediately. This recruitment may also be used to fill future vacancies. MORE INFORMATION For additional information on the duties and responsibilities of the position, refer to the job descriptions located on the City's Career Page at www.cityofventura.ca.gov/jobs or by clicking here Water Quality Specialist . THE SCHEDULE This recruitment will follow the below timeline. Wednesday, March 20, 2024, at 5:30pm - Application Deadline. Applications must be submitted by this date to be considered for the position. March 25, 2024 - Candidates will be notified by email of their status by this date. Week of April 1, 2024 - Oral Panel Interview are tentatively scheduled for this date. Qualifying candidates will be notified by email if they are invited to the panel interview process. Week of April 8, 2024 - Department Selection Interviews are tentatively scheduled for this date. Qualifying candidates will be notified by email if they are invited to the panel interview process. April 22, 2024 - Candidates will be notified of the outcome of the interview by this date. The timeline dates are subject to change. Candidates will be notified as necessary. SALARY AND BENEFITS The City offers a total compensation package that includes both a generous salary and other benefits! SALARY : $40.79 - $49.58 Hourly DOQ BENEFITS: Refer to the benefits tab on the job posting for specific information on City benefits. HOW TO APPLY To be considered for this exciting opportunity, please complete an online City Job Application and supplemental questionnaire by the filing deadline, Wednesday, March 20, 2024, at 5:30pm . If you have questions about the recruitment process, please contact Human Resources at recruitment@cityofventura.ca.gov . POSITION QUALIFICATIONS WHAT DOES IT TAKE TO QUALIFY A combination of education, experience, and training equivalent to a bachelor's degree in Chemistry, Biology, Environmental Science or a closely related field and three years of experience in water quality testing and sampling, water distribution, production or treatment is required. Experience in title 22 water regulations, sampling methods, dealing with Certified Laboratories, generating Customer Confidence Reports, and/or familiarity with upcoming regulations such as UCMR, Mn, and forever chemicals, a plus License: Possession of a valid class C driver license or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions. Certificates: State Water Resources Control Board: A Certificate from the State Water Resources Control Board Water Treatment Operator and/or Distribution Operator Grade II or higher is desirable. Ability to enroll in American National Standards Institute accreditation as a Cross Connection Specialist within 6 months of hire is required. APPLICATION AND INTERVIEW PROCESS YOUR APPLICATION Submit an online City job application and supplemental questionnaire by the filing deadline or first review date at www.cityofventura.ca.gov/jobs . It is important that your City job application show all the relevant education, training, and experience you possess. Resumes, CVs and cover letters may be attached to your application but will not be accepted in lieu of a completed job application or supplemental questionnaire. Submitting an incomplete application or supplemental questionnaire, may disqualify you from further consideration in the recruitment process. DEADLINE TO APPLY : Applications and supplemental questions will be accepted until Wednesday, March 20, 2024, at 5:30pm . APPLICATION REVIEW: All applications and supplemental questionnaires submitted will be screened in relation to the criteria outlined in this job announcement. Candidates will be reviewed and only those candidates determined to be most qualified on the basis of experience, training and education, as submitted, will be invited to participate further in the selection process. Candidates will be notified about their status after the filing deadline. INTERVIEW DATES AND INFORMATION : A select number of candidates will be invited to a qualifying panel interview process that is tentatively scheduled for Week of April 1, 2024 . Select candidates will be notified of specifics after the filing deadline. Please note, given the current COVID-19 situation, initial panel interviews may be conducted via video teleconference. Selected applicants will be notified of specifics at the appropriate time. The department selection interviews are tentatively scheduled for Week of April 8, 2024 . Candidates selected to move forward will be notified. The Eligibility List established for this classification may be used to fill other regular and temporary vacancies at the discretion of the City. --------------------------------------------------------------------------------------------------------------------------- In compliance with the Americans with Disabilities Act (ADA), if you need an accommodation in a selection process, please notify the Human Resources Department in writing by the final filing date of the position you are interested in. The Human Resources address is: 501 Poli Street, Room 210, Ventura, CA 93001, (805) 654-7853, e-mail: recruitment@cityofventura.ca.gov. THE ORGANIZATION The City of Ventura operates under the Council/ Manager form of government under a charter adopted by voters in 1934, with an elected seven-member City Council. This full-service municipality is supported by 11 major City departments: City Manager, City Attorney, Finance, Information Technology, Human Resources, Community Development, Parks & Recreation, Fire, Police, Public Works, and Ventura Water. The City's Adopted FY 2023/2024 Operating and Capital budget totals approximately $428.8 million. The City Council and the City Manager are dedicated to the highest standards of integrity, public service, and innovative approaches to governing. To learn more about the City of Ventura, please visit www.cityofventura.ca.gov and view the FY2023-24 Adopted Budget. CITY OF VENTURA The City of Ventura is located just north of Los Angeles County and south of Santa Barbara County and is frequently considered one of America's most desirable places to live. The City is a full-service municipality that was founded in 1782, incorporated in 1866, and serves nearly 110,000 residents within its 32 square miles. With nearly 700 employees, the City is dedicated to delivering key services to our businesses, residents, and visitors to ensure Ventura remains a fiscally stable, economically vibrant, safe, clean, and desirable community. Locals and visitors enjoy Ventura's impressive park system that includes 32 parks and historic sites, and more than 800 acres of open green space. The City offers a remarkable year-round climate, friendly people, and a spectacular coastline. Ventura is an exciting location for a variety of outdoor activities such as biking, hiking, kayaking, paddle-boarding, sailing, surfing, whale watching and windsurfing. Other activities include the Channel Islands National Park, championship golf, world-class shopping, wine tours, and more. Learn more about the City of Ventura at www.CityofVentura.ca.gov DIVERSITY, EQUITY AND INCLUSION The City of Ventura values human rights, goodwill, respect, inclusivity, equality, and recognizes that the City derives its strength from a rich diversity of thoughts, ideas, and contributions. As leaders in public service, we aspire to be an employer of choice by promoting an organizational culture that reflects these core values. We seek to attract, develop, and retain a talented and dedicated workforce where people of diverse races, genders, religions, cultures, political affiliations, and lifestyles thrive. Our goal is to create a welcoming and inclusive environment that empowers our employees to provide the highest level of service to our community of residents and businesses; they're counting on us. The City is an equal opportunity employer and strives to attract qualified applicants from all walks of life without regard to race, color, ethnicity, religion, national origin, age, sex, sexual orientation, gender identity, gender expression, marital status, ancestry, physical disability, mental disability, medical condition, genetic information, military and veteran status, or any other status protected under federal, state and/or local law. We aim to create an environment that celebrates and embraces the diversity of our workforce. We welcome you to join our team! Closing Date/Time: 3/20/2024 5:30 PM Pacific
City of Los Angeles
City Of Los Angeles, California, United States
DUTIES ANNUAL SALARY: $112,564 to $164,576 The salary in the Department of Water and Power is $138,058 to $171,529. NOTES : Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City’s on-premises and cloud-based databases; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; utilizes database tools to perform various types of database backups and recoveries; ensures database security and compliance with SB1386 or data privacy acts; researches current database issues and technologies; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor’s degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field; AND ONE OF THE FOLLOWING : Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing. A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience: Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google Certified Professional Data Engineer PROCESS NOTES: Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met. Some positions may require a valid California driver’s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI). Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf . Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section. Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing. Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to: Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA) SELECTIVE CERTIFICATION: In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. Applications will only be accepted on-line on the dates listed below: Friday, October 6, 2023 to Thursday, October 19, 2023 Friday, May 3, 2024 to Thursday, May 16, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the selection process in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, NOVEMBER 27, 2023 and MONDAY, DECEMBER 4, 2023 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, JUNE 24, 2024 and MONDAY, JULY 1, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that interviews will begin during the period of DECEMBER 26, 2023 to JANUARY 5, 2024 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that interviews will begin during the period of July 22, 2024 to August 2, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous
DUTIES ANNUAL SALARY: $112,564 to $164,576 The salary in the Department of Water and Power is $138,058 to $171,529. NOTES : Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City’s on-premises and cloud-based databases; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; utilizes database tools to perform various types of database backups and recoveries; ensures database security and compliance with SB1386 or data privacy acts; researches current database issues and technologies; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor’s degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field; AND ONE OF THE FOLLOWING : Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing. A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience: Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google Certified Professional Data Engineer PROCESS NOTES: Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met. Some positions may require a valid California driver’s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI). Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf . Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section. Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing. Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to: Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA) SELECTIVE CERTIFICATION: In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. Applications will only be accepted on-line on the dates listed below: Friday, October 6, 2023 to Thursday, October 19, 2023 Friday, May 3, 2024 to Thursday, May 16, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the selection process in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, NOVEMBER 27, 2023 and MONDAY, DECEMBER 4, 2023 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, JUNE 24, 2024 and MONDAY, JULY 1, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that interviews will begin during the period of DECEMBER 26, 2023 to JANUARY 5, 2024 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that interviews will begin during the period of July 22, 2024 to August 2, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous