Sonoma County, CA
Santa Rosa, California, United States
Position Information THIS RECRUITMENT IS PROMOTIONAL ONLY. YOU MUST PRESENTLY BE A FULL- OR PART-TIME REGULAR OR PROBATIONARY COUNTY OF SONOMA, COMMUNITY DEVELOPMENT COMMISSION, SONOMA COUNTY FAIRGROUNDS, OR SONOMA COUNTY WATER AGENCY EMPLOYEE IN ORDER TO APPLY FOR THIS POSITION. The Sonoma County Water Agency (Sonoma Water) has requested a department promotional certification to fill Water Agency Senior Programs Specialist position. Only qualified permanent and/or probationary Department employees on the eligible list may be eligible for referral to the department for the advertised position. This employment list may also be used to fill future full-time, part-time, or extra-help (temporary) positions as they occur during the active status of the list. The Sonoma Water Senior Programs Specialist is responsible for administering high level education programs which includes classroom and field programs along with training new educators on a range of water related programs . This position collaborates with external partners and represents Sonoma Water by leading field trip programs and organizing and facilitating meetings with internal and external stakeholders. Additional responsibilities include: Leading complex work groups and water related programs Receiving feedback from relevant staff and creating program and project development as part of the collaborative program structure Coordinating and directing community education/engagement programs with other staff and departments Promoting awareness of Sonoma Water projects and programs In addition to bringing experience implementing and/or educating about water-related programs, the ideal candidate will thrive in a collaborative environment and possess: A passion for the fields of environmental education, climate change, public service, and/or education The ability to facilitate group meetings and experience presenting to a diverse audience An understanding of existing Sonoma Water education programs, contracts, and budgeting processes Working knowledge of web design and online social networks Adobe Creative Suite experience designing brochures, flyers, and other public documents Proficiency with Microsoft Office Suite programs APPLICATION SUBMISSIONS REQUIRE THE SUPPLEMENTAL QUESTIONNAIRE BE COMPLETED. Minimum Qualifications Education & Experience: Any combination of education, training, and experience which would provide the required knowledge and abilities listed. Normally, this would include a four-year degree in water related science, environmental studies, education, political science, communications, public relations, or a closely related field; and three years of experience, which includes at least one year at the level of Water Agency Program Specialist II, or equivalent, that has included experience in the implementation of water-related programs in one or more of the following areas: community relations, public outreach, media, water use efficiency technology, teaching methods consistent with state-wide educational standards, and/or legislative processes at the federal or state level. Desired Certifications: Possession of a Grade II Water Use Efficiency Practitioner certificate from the CA/NA Section of the American Water Works Association for persons in the Water Use Efficiency specialization. Possession of a California teaching credential for persons in the Water Education specialization. License: Possession of a valid driver's license at the appropriate level including special endorsements, as required by the State of California, may be required depending upon assignment to perform the essential job functions of the position. Knowledge, Skills, and Abilities Thorough knowledge of: Operation of water supply facilities, water treatment facilities and water distribution systems; methods of water treatment and recycling; environmental regulations and environmental enhancement and restoration methods related to operation and construction of water supply, flood control, renewable energy, recycled water, and wastewater treatment facilities; fundamentals of communication, public speaking; data analysis and statistical forecasting methods; best practices for community outreach; English grammar, composition, vocabulary, spelling, and punctuation; standards and practices for workplace safety; and office procedures, methods, and equipment including computers and applicable software applications such as word processing, spreadsheets, search tools, social media services and database applications. Ability to: plan, develop, organize, and implement a wide variety of water-related programs; negotiate agreements with various agencies and special interests to facilitate program activities; speak effectively and persuasively before diverse groups; establish effective working relationships with other staff and with persons possessing a wide variety of divergent views; plan, organize, train, lead, and direct the activities of Water Agency staff and employees of participating municipalities, specials districts, the public, and outside agencies; create, innovate, develop, implement, and manage a variety of programs and projects related to water use efficiency, water education, community affairs, or government affairs; write and edit written materials for publication; compile concise reports, letters, newsletters and other written materials; coordinate educational and informational seminars and workshops; prepare and disseminate information to media and others; prepare a wide range of clear, concise, and informative reports, correspondence, and brochures; operate office equipment including computers and supporting word processing, spreadsheet, and database applications; use the internet and social media to enhance public outreach. Specialized assignments require the following: Water Use Efficiency Working knowledge of: Principles, practices and methods of water use efficiency and natural resource conservation; methods of conservation program implementation and monitoring; plumbing efficiency; building code requirements; landscaping and turf water efficiency; methods for urban and non-urban water reuse; landscape design and installation practices; regulatory framework and reporting standards for water efficiency in California including State Water Board requirements and urban water management plan specifications. Water Education Working knowledge of: Strategies and methods for effective educational programs; current state and federal standards for science education; strategies for effective behavior management; methods for outdoor education and natural interpretation, strategies for curriculum development and implementation; methods to analyze educational effectiveness. Community Affairs Working knowledge of: Principles and techniques for establishing and maintaining effective public relations; media operations and effective media relations; techniques for effective use of social media; principles of graphic design and production; techniques and methods of research, report writing and preparation of informational materials; strategies for conflict resolution and mediation; Government Affairs Working knowledge of: Basic principles of the state Water and Government Codes and related laws; state and federal legislative procedures; regulatory requirements governing legislative advocacy; communication methods for legislative advocacy; strategies for developing multi-agency coalitions. Selection Procedure & Some Helpful Tips When Applying Your application information and your responses to the supplemental questions are evaluated and taken into consideration throughout the entire selection process. You should list all employers and positions held within the last ten years in the work history section of your application. Be as thorough as possible when responding to the supplemental questions. You may include history beyond ten years if related to the position for which you are applying. If you held multiple positions with one employer, list out each position separately. Failure to follow these instructions may impact your competitiveness in this process or may result in disqualification. Please visit Getting a Job with the County of Sonoma to review more detailed information about the hiring process, including the application process, examination steps, and department selection process. APPLICATION SUBMISSIONS REQUIRE THE SUPPLEMENTAL QUESTIONNAIRE BE COMPLETED. Responses to supplemental questions may be scored using position-specific criteria. Please provide specific and detailed responses of a reasonable length to allow for a thorough assessment of your qualifications. Responses that state, "See Resume" or "See Application" may be considered insufficient and therefore may not be scored. The selection procedure will consist of the following examination: An Application & Supplemental Questionnaire Appraisal Examination (weight 100%) may be conducted to evaluate each applicant's application and supplemental questionnaire for satisfaction of minimum qualifications (pass/not pass); and for educational coursework, training, experience, knowledge, and abilities which relate to this position. Each applicant will be evaluated based on the following criteria: Relevance of work history, related experience, and achieved level of education and/or training as described in the application and responses to the supplemental questions. Candidates demonstrating possession of the minimum qualifications will be placed on an employment list in order of most qualified to least qualified based on the achieved score received in the Application & Supplemental Questionnaire Appraisal Examination. Scores may be adjusted based on such factors as the number of candidates, anticipated vacancies, past practice, and natural breaks in the scores achieved by this group of candidates. ADDITIONAL INFORMATION A background investigation may be required prior to employment. Candidates referred to departments for a selection interview are typically required to sign authorization and release forms enabling such an investigation. Failure to sign prescribed forms will result in the candidate not being considered further for that vacancy. Reference information will not be made available to applicants. Additional requirements, such as successful completion of a physical exam, drug screen, etc., may apply, depending on the duties and responsibilities of the position. If you receive a conditional job offer for the position, the requirements upon which the offer is contingent will be outlined in the conditional job letter. You may also review the Job Classification Screening Schedule to determine the requirements for this position. HOW TO APPLY Applications are accepted online at www.yourpath2sonomacounty.org . Paper applications may be submitted by person, fax (707-565-3770), email, or through the mail. All applications and appropriate supplemental information as outlined in the job bulletin must be RECEIVED by the time and date specified on the first page of this job announcement. Applications received after the recruitment closes will not be accepted. The County of Sonoma values diversity and is dedicated to creating a workplace environment that provides individuals with a sense of belonging. We are committed to having a diverse workforce that is representative of the communities we serve. The County is proud to be an Equal Opportunity Employer where all aspects of employment are based on merit, competence, performance, and business need. HR Analyst: JT HR Technician: KK IMPORTANT NOTE: Benefits described herein do not apply to Extra Help positions. COUNTY OF SONOMA BENEFITS: GENERAL* These are some of the excellent benefits the County offers: Paid Time Off : Competitive vacation and sick leave accruals; 12 paid holidays, and an additional 8 floating holiday hours per year; and may be eligible for up to 8 weeks (320 hours) of Paid Parental Leave after 12 months of County employment. Health Plan : Choice of five health plans (a PPO, EPO, HMO, and two deductible HMOs) with a County contribution toward the premium (the contribution amount varies by bargaining unit. For specific details, please refer to the applicable MOU). A County contribution to a Health Reimbursement Arrangement is available for some bargaining units. Retirement : Fully integrated with Social Security.For more information regarding eligibility, retirement contributions, and reciprocity with prior public service, please visit https://scretire.org/active-/-deferred/when-you-are-hired . IRS 457 Plan : Pre-tax employee contribution up to the IRS annual maximum. Retiree Medical : County contribution to a Health Reimbursement Arrangement to help fund post-retirement employee health insurance/benefits. Student Loan Debt Relief : County employees may be eligible for Public Service Loan Forgiveness through the U.S. Department of Education. Plus excellent dental, vision, disability, life insurance, professional development, and more. For answers to specific questions regarding the employment process and more details about benefits or retirement, please contact Human Resources at (707) 565-2331.Additional details about benefit and compensation packages can be found in the MOUs located at https://sonomacounty.ca.gov/administrative-support-and-fiscal-services/human-resources/divisions-and-units/employee-relations/labor-agreements-and-salary-resolution . For specific information about health and welfare benefits including plan options, coverage, and premium amounts go to https://sonomacounty.ca.gov/administrative-support-and-fiscal-services/human-resources or, contact the Human Resources' Risk Management-Benefits Office at benefits@sonoma-county.org or (707) 565-2900. *IMPORTANT NOTES: Benefits described herein do not represent a contract and may be changed without notice. Closing Date/Time: 5/1/2024 11:59 PM Pacific
Position Information THIS RECRUITMENT IS PROMOTIONAL ONLY. YOU MUST PRESENTLY BE A FULL- OR PART-TIME REGULAR OR PROBATIONARY COUNTY OF SONOMA, COMMUNITY DEVELOPMENT COMMISSION, SONOMA COUNTY FAIRGROUNDS, OR SONOMA COUNTY WATER AGENCY EMPLOYEE IN ORDER TO APPLY FOR THIS POSITION. The Sonoma County Water Agency (Sonoma Water) has requested a department promotional certification to fill Water Agency Senior Programs Specialist position. Only qualified permanent and/or probationary Department employees on the eligible list may be eligible for referral to the department for the advertised position. This employment list may also be used to fill future full-time, part-time, or extra-help (temporary) positions as they occur during the active status of the list. The Sonoma Water Senior Programs Specialist is responsible for administering high level education programs which includes classroom and field programs along with training new educators on a range of water related programs . This position collaborates with external partners and represents Sonoma Water by leading field trip programs and organizing and facilitating meetings with internal and external stakeholders. Additional responsibilities include: Leading complex work groups and water related programs Receiving feedback from relevant staff and creating program and project development as part of the collaborative program structure Coordinating and directing community education/engagement programs with other staff and departments Promoting awareness of Sonoma Water projects and programs In addition to bringing experience implementing and/or educating about water-related programs, the ideal candidate will thrive in a collaborative environment and possess: A passion for the fields of environmental education, climate change, public service, and/or education The ability to facilitate group meetings and experience presenting to a diverse audience An understanding of existing Sonoma Water education programs, contracts, and budgeting processes Working knowledge of web design and online social networks Adobe Creative Suite experience designing brochures, flyers, and other public documents Proficiency with Microsoft Office Suite programs APPLICATION SUBMISSIONS REQUIRE THE SUPPLEMENTAL QUESTIONNAIRE BE COMPLETED. Minimum Qualifications Education & Experience: Any combination of education, training, and experience which would provide the required knowledge and abilities listed. Normally, this would include a four-year degree in water related science, environmental studies, education, political science, communications, public relations, or a closely related field; and three years of experience, which includes at least one year at the level of Water Agency Program Specialist II, or equivalent, that has included experience in the implementation of water-related programs in one or more of the following areas: community relations, public outreach, media, water use efficiency technology, teaching methods consistent with state-wide educational standards, and/or legislative processes at the federal or state level. Desired Certifications: Possession of a Grade II Water Use Efficiency Practitioner certificate from the CA/NA Section of the American Water Works Association for persons in the Water Use Efficiency specialization. Possession of a California teaching credential for persons in the Water Education specialization. License: Possession of a valid driver's license at the appropriate level including special endorsements, as required by the State of California, may be required depending upon assignment to perform the essential job functions of the position. Knowledge, Skills, and Abilities Thorough knowledge of: Operation of water supply facilities, water treatment facilities and water distribution systems; methods of water treatment and recycling; environmental regulations and environmental enhancement and restoration methods related to operation and construction of water supply, flood control, renewable energy, recycled water, and wastewater treatment facilities; fundamentals of communication, public speaking; data analysis and statistical forecasting methods; best practices for community outreach; English grammar, composition, vocabulary, spelling, and punctuation; standards and practices for workplace safety; and office procedures, methods, and equipment including computers and applicable software applications such as word processing, spreadsheets, search tools, social media services and database applications. Ability to: plan, develop, organize, and implement a wide variety of water-related programs; negotiate agreements with various agencies and special interests to facilitate program activities; speak effectively and persuasively before diverse groups; establish effective working relationships with other staff and with persons possessing a wide variety of divergent views; plan, organize, train, lead, and direct the activities of Water Agency staff and employees of participating municipalities, specials districts, the public, and outside agencies; create, innovate, develop, implement, and manage a variety of programs and projects related to water use efficiency, water education, community affairs, or government affairs; write and edit written materials for publication; compile concise reports, letters, newsletters and other written materials; coordinate educational and informational seminars and workshops; prepare and disseminate information to media and others; prepare a wide range of clear, concise, and informative reports, correspondence, and brochures; operate office equipment including computers and supporting word processing, spreadsheet, and database applications; use the internet and social media to enhance public outreach. Specialized assignments require the following: Water Use Efficiency Working knowledge of: Principles, practices and methods of water use efficiency and natural resource conservation; methods of conservation program implementation and monitoring; plumbing efficiency; building code requirements; landscaping and turf water efficiency; methods for urban and non-urban water reuse; landscape design and installation practices; regulatory framework and reporting standards for water efficiency in California including State Water Board requirements and urban water management plan specifications. Water Education Working knowledge of: Strategies and methods for effective educational programs; current state and federal standards for science education; strategies for effective behavior management; methods for outdoor education and natural interpretation, strategies for curriculum development and implementation; methods to analyze educational effectiveness. Community Affairs Working knowledge of: Principles and techniques for establishing and maintaining effective public relations; media operations and effective media relations; techniques for effective use of social media; principles of graphic design and production; techniques and methods of research, report writing and preparation of informational materials; strategies for conflict resolution and mediation; Government Affairs Working knowledge of: Basic principles of the state Water and Government Codes and related laws; state and federal legislative procedures; regulatory requirements governing legislative advocacy; communication methods for legislative advocacy; strategies for developing multi-agency coalitions. Selection Procedure & Some Helpful Tips When Applying Your application information and your responses to the supplemental questions are evaluated and taken into consideration throughout the entire selection process. You should list all employers and positions held within the last ten years in the work history section of your application. Be as thorough as possible when responding to the supplemental questions. You may include history beyond ten years if related to the position for which you are applying. If you held multiple positions with one employer, list out each position separately. Failure to follow these instructions may impact your competitiveness in this process or may result in disqualification. Please visit Getting a Job with the County of Sonoma to review more detailed information about the hiring process, including the application process, examination steps, and department selection process. APPLICATION SUBMISSIONS REQUIRE THE SUPPLEMENTAL QUESTIONNAIRE BE COMPLETED. Responses to supplemental questions may be scored using position-specific criteria. Please provide specific and detailed responses of a reasonable length to allow for a thorough assessment of your qualifications. Responses that state, "See Resume" or "See Application" may be considered insufficient and therefore may not be scored. The selection procedure will consist of the following examination: An Application & Supplemental Questionnaire Appraisal Examination (weight 100%) may be conducted to evaluate each applicant's application and supplemental questionnaire for satisfaction of minimum qualifications (pass/not pass); and for educational coursework, training, experience, knowledge, and abilities which relate to this position. Each applicant will be evaluated based on the following criteria: Relevance of work history, related experience, and achieved level of education and/or training as described in the application and responses to the supplemental questions. Candidates demonstrating possession of the minimum qualifications will be placed on an employment list in order of most qualified to least qualified based on the achieved score received in the Application & Supplemental Questionnaire Appraisal Examination. Scores may be adjusted based on such factors as the number of candidates, anticipated vacancies, past practice, and natural breaks in the scores achieved by this group of candidates. ADDITIONAL INFORMATION A background investigation may be required prior to employment. Candidates referred to departments for a selection interview are typically required to sign authorization and release forms enabling such an investigation. Failure to sign prescribed forms will result in the candidate not being considered further for that vacancy. Reference information will not be made available to applicants. Additional requirements, such as successful completion of a physical exam, drug screen, etc., may apply, depending on the duties and responsibilities of the position. If you receive a conditional job offer for the position, the requirements upon which the offer is contingent will be outlined in the conditional job letter. You may also review the Job Classification Screening Schedule to determine the requirements for this position. HOW TO APPLY Applications are accepted online at www.yourpath2sonomacounty.org . Paper applications may be submitted by person, fax (707-565-3770), email, or through the mail. All applications and appropriate supplemental information as outlined in the job bulletin must be RECEIVED by the time and date specified on the first page of this job announcement. Applications received after the recruitment closes will not be accepted. The County of Sonoma values diversity and is dedicated to creating a workplace environment that provides individuals with a sense of belonging. We are committed to having a diverse workforce that is representative of the communities we serve. The County is proud to be an Equal Opportunity Employer where all aspects of employment are based on merit, competence, performance, and business need. HR Analyst: JT HR Technician: KK IMPORTANT NOTE: Benefits described herein do not apply to Extra Help positions. COUNTY OF SONOMA BENEFITS: GENERAL* These are some of the excellent benefits the County offers: Paid Time Off : Competitive vacation and sick leave accruals; 12 paid holidays, and an additional 8 floating holiday hours per year; and may be eligible for up to 8 weeks (320 hours) of Paid Parental Leave after 12 months of County employment. Health Plan : Choice of five health plans (a PPO, EPO, HMO, and two deductible HMOs) with a County contribution toward the premium (the contribution amount varies by bargaining unit. For specific details, please refer to the applicable MOU). A County contribution to a Health Reimbursement Arrangement is available for some bargaining units. Retirement : Fully integrated with Social Security.For more information regarding eligibility, retirement contributions, and reciprocity with prior public service, please visit https://scretire.org/active-/-deferred/when-you-are-hired . IRS 457 Plan : Pre-tax employee contribution up to the IRS annual maximum. Retiree Medical : County contribution to a Health Reimbursement Arrangement to help fund post-retirement employee health insurance/benefits. Student Loan Debt Relief : County employees may be eligible for Public Service Loan Forgiveness through the U.S. Department of Education. Plus excellent dental, vision, disability, life insurance, professional development, and more. For answers to specific questions regarding the employment process and more details about benefits or retirement, please contact Human Resources at (707) 565-2331.Additional details about benefit and compensation packages can be found in the MOUs located at https://sonomacounty.ca.gov/administrative-support-and-fiscal-services/human-resources/divisions-and-units/employee-relations/labor-agreements-and-salary-resolution . For specific information about health and welfare benefits including plan options, coverage, and premium amounts go to https://sonomacounty.ca.gov/administrative-support-and-fiscal-services/human-resources or, contact the Human Resources' Risk Management-Benefits Office at benefits@sonoma-county.org or (707) 565-2900. *IMPORTANT NOTES: Benefits described herein do not represent a contract and may be changed without notice. Closing Date/Time: 5/1/2024 11:59 PM Pacific
City of Santa Rosa
Santa Rosa, CA, USA
Examples of Duties and Responsibilities
PLEASE NOTE : The duties and responsibilities listed below are specific to Civil Engineering Technician III and these duties may/or may not be performed by Civil Engineering Technicians I & II. For specific duties related to Civil Engineering Technician I & II, please visit the links referenced above to review the detailed job descriptions for each level. Examples of Essential Duties (all positions): The following duties are considered essential for this job classification:
Research, file, retrieve, review and/or prepare a variety of engineering maps, documents, records, reports, and correspondence.
Operate computer-aided design, modeling and/or other application programs.
Respond to complaints and inquiries from other departments, outside agencies, and the public concerning engineering activities.
Locate utilities, easements, property lines, and/or other information on plans.
Perform and check mathematical, computer, and/or statistical calculations used in engineering tasks.
Perform field investigations and/or inspections of existing conditions and new construction.
Collect, compile, and/or analyze data and/or field samples.
Notify contractors of discrepancies between work performed and the approved plans, specifications, and standards.
Review drawings and improvement plans for conformance with established engineering standards.
Provide technical direction to less experienced staff.
Prepare program and project schedules.
In addition to the duties listed above, the following duties are considered essential for the following divisions: Engineering Development /Water Engineering Services: Plan Check:
Process legal documents, permit applications and issue permits.
Coordinate public works and utility activities with other City departments, divisions and sections and with outside agencies.
Research publications and industry information sources.
Develop and revise design standards, Standard Plans, specifications, and Engineers Approved lists.
Attend public hearings.
Review various development submittals proposing modifications.
Place conditions on projects to ensure all engineering design criteria, City Standards and Policies are met.
Inspection:
Perform inspection for current development infrastructure, water, sewer, storm water, grading and erosion, and sediment control.
Ensure quality control of projects as well as public safety aspects while the projects are under construction.
Complete daily inspection and field activity reports.
Coordinate engineering field activities with other City Departments and Development Services, contractors and consultants on project scheduling and technical requirements.
Process permit applications and issue permits.
Capital Projects Engineering Project Development:
Assist in the relative tasks from project planning through construction during implementation of engineering contracts.
Assist in preparing project initiation documents, including but not limited to the schedule, cost estimate, project maps, PowerPoint presentations, and other supporting documents.
Assist in drafting and releasing Requests for Proposals, reviewing consultant proposals, and giving feedback for contract negotiations.
Review improvement plans and project specifications for conformance with established engineering standards and city codes.
Review engineering estimate for conformance with project specifications, including quantity checking.
Research necessary environmental permits, and process permit applications and other associated documents.
Locate utilities, easements, property lines, and/or other information within archived records.
Coordinate public works and utility activities with other City departments, divisions, and outside agencies.
Submit permit applications and supporting documentation to various inside and outside organizations.
Perform soil contamination research for given project areas and draft supporting documentation.
Support public participation efforts by drafting and sending letter to community members.
Provide updates to the public facing CIP project website.
Coordinate plan review distribution to appropriate staff and departments and compile comments into one document, and document comments received in the CIP project directory.
Develop and maintain a thorough knowledge of City’s Design & Construction Standards, including sections association with roadway, traffic, sewer, water & storm drain projects.
Develop and maintain a thorough knowledge of the principles, procedures and standards for Water Distribution and Water Collection Systems and related resource material.
Construction & Inspection:
Perform site constructability review.
Perform inspection for roadway, water, sewer, storm water, grading and erosion control, and other public infrastructure projects.
Ensure quality control of projects as well as public safety aspects while under construction.
Complete daily inspection and field activity reports.
Document photos of daily construction activities.
Perform stormwater management inspections, as needed, and inform engineer of any issues.
Act as liaison between City staff and professional consultant construction manager and inspector; provide coordination support and overall assistance as needed.
Understand and maintain appropriate communication channels established by the project engineer.
Participate in construction meetings and provide input/recommendations as necessary to assist with or resolve construction related matters or conflicts.
Perform meter and tie-in inspections according to established procedures by insuring installations meet City Design & Construction Standards or approved plans and assuring adequate notification of service interruptions or items needing correction are given to customers.
Function as a backup resource for construction inspection duties when all other field inspection staff are unavailable, including staff from Engineering Development Services.
Project Closeout:
Complete and archive all applicable design and construction documents, and final record drawings consistent with Department archiving procedures.
Survey Section:
Act as the Survey Party Chief and/or a chain, rod, or instrument-person.
Provide field and record information to be used in production of engineering drawings.
Perform topographic, boundary, control and construction surveys.
Perform construction staking.
Perform duties typically associated with land surveying activities.
Asset Management: Planning & Assets:
Perform analysis of infrastructure asset data using CMMS software, ARCGIS and MS Access.
Review data sources for asset condition assessment including collection system CCTVs, base maps, construction drawings, and collection system flow meter graphs.
Map city assets using AutoCAD, and coordinate mapping with asset management software.
Coordinate with Capital Projects Engineering, Water Engineering Services, and Local Operations on the creation of assets and management of the City’s engineering document database.
Assist in Capital Projects Planning, project scoping, and project prioritization.
In addition to the duties listed above, Capital Project Engineering duties may also be required on small projects.
Storm Water & Creeks:
Perform field investigations/tests on storm water.
Assist in the preparation and administration of engineering contracts and professional service agreements.
Work with Environmental Specialist staff to prepare information and exhibits as needed for storm water and creek restoration projects.
Materials Engineering:
Demonstrate and perform all testing procedures.
Perform testing and lab analysis of R-value, TSR, unconfined compressive strength of treated soils, S-value and others as required.
Review and evaluate HMA, PCC and aggregate quarry operations including their QC procedures.
Perform plant and jobsite HMA and PCC inspections.
Respond to contractor/customer inquiries with regards to materials and placement thereof.
Utilize PMP software and train technicians in PMP inspections.
Traffic Engineering:
Develop and maintain traffic signal timing for isolated intersections and coordinated systems independently.
Train others to process permit applications and issue transportation permits.
Determine and collect fees.
Process and issue transportation permits for oversize & overweight vehicles.
Assist in drafting of striping plans for construction and material quantities for a cost estimate and the preparation of engineering contracts.
Perform engineering and traffic surveys for establishing speed limits.
Assist in the preparation of engineering contracts, process customer service requests and provide appropriate solutions on an independent basis.
Apply principles of the California Manual of Uniform Traffic Control Devices to daily work.
Additional Duties : In addition to the duties listed in the Essential Duties Section, each employee in this classification may perform the following duties in the department and section assignments specified. Any single position may not be assigned all duties listed below, nor do the examples cover all duties which may be assigned.
Develop and revise design standards, Standard Plans, specifications, and Engineers Approved lists.
Process permit applications and issue permits.
Determine and collect fees.
Assist in the preparation and administration of engineering contracts.
Perform related duties as assigned.
Examples of Duties and Responsibilities
PLEASE NOTE : The duties and responsibilities listed below are specific to Civil Engineering Technician III and these duties may/or may not be performed by Civil Engineering Technicians I & II. For specific duties related to Civil Engineering Technician I & II, please visit the links referenced above to review the detailed job descriptions for each level. Examples of Essential Duties (all positions): The following duties are considered essential for this job classification:
Research, file, retrieve, review and/or prepare a variety of engineering maps, documents, records, reports, and correspondence.
Operate computer-aided design, modeling and/or other application programs.
Respond to complaints and inquiries from other departments, outside agencies, and the public concerning engineering activities.
Locate utilities, easements, property lines, and/or other information on plans.
Perform and check mathematical, computer, and/or statistical calculations used in engineering tasks.
Perform field investigations and/or inspections of existing conditions and new construction.
Collect, compile, and/or analyze data and/or field samples.
Notify contractors of discrepancies between work performed and the approved plans, specifications, and standards.
Review drawings and improvement plans for conformance with established engineering standards.
Provide technical direction to less experienced staff.
Prepare program and project schedules.
In addition to the duties listed above, the following duties are considered essential for the following divisions: Engineering Development /Water Engineering Services: Plan Check:
Process legal documents, permit applications and issue permits.
Coordinate public works and utility activities with other City departments, divisions and sections and with outside agencies.
Research publications and industry information sources.
Develop and revise design standards, Standard Plans, specifications, and Engineers Approved lists.
Attend public hearings.
Review various development submittals proposing modifications.
Place conditions on projects to ensure all engineering design criteria, City Standards and Policies are met.
Inspection:
Perform inspection for current development infrastructure, water, sewer, storm water, grading and erosion, and sediment control.
Ensure quality control of projects as well as public safety aspects while the projects are under construction.
Complete daily inspection and field activity reports.
Coordinate engineering field activities with other City Departments and Development Services, contractors and consultants on project scheduling and technical requirements.
Process permit applications and issue permits.
Capital Projects Engineering Project Development:
Assist in the relative tasks from project planning through construction during implementation of engineering contracts.
Assist in preparing project initiation documents, including but not limited to the schedule, cost estimate, project maps, PowerPoint presentations, and other supporting documents.
Assist in drafting and releasing Requests for Proposals, reviewing consultant proposals, and giving feedback for contract negotiations.
Review improvement plans and project specifications for conformance with established engineering standards and city codes.
Review engineering estimate for conformance with project specifications, including quantity checking.
Research necessary environmental permits, and process permit applications and other associated documents.
Locate utilities, easements, property lines, and/or other information within archived records.
Coordinate public works and utility activities with other City departments, divisions, and outside agencies.
Submit permit applications and supporting documentation to various inside and outside organizations.
Perform soil contamination research for given project areas and draft supporting documentation.
Support public participation efforts by drafting and sending letter to community members.
Provide updates to the public facing CIP project website.
Coordinate plan review distribution to appropriate staff and departments and compile comments into one document, and document comments received in the CIP project directory.
Develop and maintain a thorough knowledge of City’s Design & Construction Standards, including sections association with roadway, traffic, sewer, water & storm drain projects.
Develop and maintain a thorough knowledge of the principles, procedures and standards for Water Distribution and Water Collection Systems and related resource material.
Construction & Inspection:
Perform site constructability review.
Perform inspection for roadway, water, sewer, storm water, grading and erosion control, and other public infrastructure projects.
Ensure quality control of projects as well as public safety aspects while under construction.
Complete daily inspection and field activity reports.
Document photos of daily construction activities.
Perform stormwater management inspections, as needed, and inform engineer of any issues.
Act as liaison between City staff and professional consultant construction manager and inspector; provide coordination support and overall assistance as needed.
Understand and maintain appropriate communication channels established by the project engineer.
Participate in construction meetings and provide input/recommendations as necessary to assist with or resolve construction related matters or conflicts.
Perform meter and tie-in inspections according to established procedures by insuring installations meet City Design & Construction Standards or approved plans and assuring adequate notification of service interruptions or items needing correction are given to customers.
Function as a backup resource for construction inspection duties when all other field inspection staff are unavailable, including staff from Engineering Development Services.
Project Closeout:
Complete and archive all applicable design and construction documents, and final record drawings consistent with Department archiving procedures.
Survey Section:
Act as the Survey Party Chief and/or a chain, rod, or instrument-person.
Provide field and record information to be used in production of engineering drawings.
Perform topographic, boundary, control and construction surveys.
Perform construction staking.
Perform duties typically associated with land surveying activities.
Asset Management: Planning & Assets:
Perform analysis of infrastructure asset data using CMMS software, ARCGIS and MS Access.
Review data sources for asset condition assessment including collection system CCTVs, base maps, construction drawings, and collection system flow meter graphs.
Map city assets using AutoCAD, and coordinate mapping with asset management software.
Coordinate with Capital Projects Engineering, Water Engineering Services, and Local Operations on the creation of assets and management of the City’s engineering document database.
Assist in Capital Projects Planning, project scoping, and project prioritization.
In addition to the duties listed above, Capital Project Engineering duties may also be required on small projects.
Storm Water & Creeks:
Perform field investigations/tests on storm water.
Assist in the preparation and administration of engineering contracts and professional service agreements.
Work with Environmental Specialist staff to prepare information and exhibits as needed for storm water and creek restoration projects.
Materials Engineering:
Demonstrate and perform all testing procedures.
Perform testing and lab analysis of R-value, TSR, unconfined compressive strength of treated soils, S-value and others as required.
Review and evaluate HMA, PCC and aggregate quarry operations including their QC procedures.
Perform plant and jobsite HMA and PCC inspections.
Respond to contractor/customer inquiries with regards to materials and placement thereof.
Utilize PMP software and train technicians in PMP inspections.
Traffic Engineering:
Develop and maintain traffic signal timing for isolated intersections and coordinated systems independently.
Train others to process permit applications and issue transportation permits.
Determine and collect fees.
Process and issue transportation permits for oversize & overweight vehicles.
Assist in drafting of striping plans for construction and material quantities for a cost estimate and the preparation of engineering contracts.
Perform engineering and traffic surveys for establishing speed limits.
Assist in the preparation of engineering contracts, process customer service requests and provide appropriate solutions on an independent basis.
Apply principles of the California Manual of Uniform Traffic Control Devices to daily work.
Additional Duties : In addition to the duties listed in the Essential Duties Section, each employee in this classification may perform the following duties in the department and section assignments specified. Any single position may not be assigned all duties listed below, nor do the examples cover all duties which may be assigned.
Develop and revise design standards, Standard Plans, specifications, and Engineers Approved lists.
Process permit applications and issue permits.
Determine and collect fees.
Assist in the preparation and administration of engineering contracts.
Perform related duties as assigned.
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