Solano County, CA
Fairfield, California, United States
Manages and oversees a major information technology system, group, or program including staff and contract resources; plans, designs, and coordinates the maintenance of the most difficult and complex infrastructure system or computerized data processing and applications systems for large, multi departmental or county wide functions; acts as a project/team leader and technical expert in assigned area(s) of responsibility, and oversees major information technology initiatives. Positions in this class head a major information technology section, program or initiative and may supervise lower level information technology professionals. Positions in this classification have the highest subject matter expertise for the assigned area and are proficient in project management, system development and design, GIS, infrastructure design and planning, and emerging technology development and implementation. This class is distinguished from the: Information Technology Analyst IV by responsibility for a major section, program or initiative with a high level of independence and responsibility for significant resources. Click here for the recruitment brochure with more information. The Ideal Candidate Cisco Technology Expertise: Proven expertise in configuring, managing, and troubleshooting a wide range of Cisco networking equipment, including routers, switches, firewalls, and wireless solutions. Advanced proficiency in working with the latest Cisco technologies, such as Cisco ACI, DNA Center, SD-WAN, and intent-based networking solutions. Routing experience in BGP, OSPF, EIGRP, HSRP, QOS, STP/RSTP/MSTP In-depth understanding of core Routing and Switching TCP IPv4 & IPv6 protocols, DNS, DHCP, SNMP, VLAN, VPN, MPLS, etc. Configure and maintain Cisco Firepower rule sets for security management. Network Design and Optimization: Demonstrated ability to design and implement network architectures that align with County objectives, emphasizing efficiency, reliability, and security. Proven experience in optimizing network performance, minimizing downtime, and ensuring seamless connectivity. Have experience designing, implementing, troubleshooting, and managing various networks, topologies, firewalls, Virtual Local Area Networks (VLANs), Cisco hardware and security mechanisms. Security and Compliance: In-depth knowledge of Cisco security solutions and protocols, including experience in implementing and maintaining robust security measures to safeguard against cyber threats. Familiarity with industry standards and compliance requirements, ensuring network security and data integrity. Be able to maintain the security and accessibility of the network. Troubleshooting and Incident Response: Strong analytical and problem-solving skills with a track record of effectively diagnosing and resolving complex network, communication, and hardware issues. Experience in developing and implementing incident response plans to minimize the impact of network disruptions. Have strong multitasking skills to analyze, plan, coordinate, implement, support, and administer the county-wide network that includes Transmission Control Protocol/Internet Protocol (TCP/IP), local area networks, wide area networks, wireless networks (Wi-Fi), and Virtual Private Networks (VPN). Understanding of the OSI model. Familiarity with ITIL v3 standards, procedures, policies. Team Collaboration and Leadership: Strong leadership skills with an ability to collaborate with cross-functional teams, providing technical leadership and mentorship. Self-motivated with the ability to work autonomously and make decisions based on technical confidence within mobility and core technology. Effective communication abilities, ensuring clear and concise documentation of network configurations and changes. Capability to understand County department requirements and provide tailored network solutions. Project management skills, enabling the successful completion of multiple projects within specified deadlines. Proficiency in managing external vendor services and implementation initiatives. Demonstrated expertise in developing and maintaining network documentation, along with establishing appropriate procedures. Positive demeanor for effective communication and interaction with others. Ability to analyze and facilitate the acquisition, installation, and application of vendor-supplied software and hardware products. Strong attention to detail in all aspects of work. Essential Duties This class specification represents the core area of responsibilities; specific position assignments will vary depending on the needs of the department. Coordinate the organization, staffing and operational activities for assigned information technology programs, initiatives, and projects; participate in the development and implementation of goals, objectives, policies and priorities related to information technology; recommend and implement resulting policies and procedures; identify opportunities for improving service delivery methods and procedures; identify resource needs; review with appropriate management staff; implement improvements. Oversees, coordinates, and participates in organizational, operational, and procedural analyses to determine information input, work processes, and desired output for potential and/or up dated computerization for a large number of users in support of a multi departmental or county wide applications; reviews and analyzes a variety of forms, documents, reports, data output, and record-keeping requirements. Consults with customer/user departments and advises on the feasibility of converting systems to computerized applications; analyzes departmental and County wide operations, functions, services, interdepartmental relationships, and the information sharing needs in the development of new and/or up dated systems and procedures; recommends improvements in operations and administration of existing systems. Direct, coordinate and review the work plan for assigned Information Services activities; assign work activities and projects; monitor work flow; review and evaluate work products, methods and procedures; meet with staff to identify and resolve problems. Oversee and coordinate the implementation of information technology projects; develop priorities for assigned projects; manage projects to ensure completion in a timely manner; recommend problem resolution or alternatives to keep projects on schedule. Participate in the development, preparation, and maintenance of the information technology strategic plans; recommend County-wide information technology standards; evaluate and develop proposed standards for hardware, software and networks. Select, train, motivate and evaluate Information Services personnel; provide or coordinate staff training; work with employees to correct deficiencies; implement discipline and termination procedures. Participate in the development and administration of assigned program budget; forecast funds needed for staffing, training, equipment, materials and supplies; monitor and approve expenditures; recommend adjustments as necessary. Provide staff assistance to higher level management staff; participate on a variety of committees; prepare and present staff reports and other correspondence as appropriate and necessary. Maintains professional knowledge in applicable areas and keeps abreast of changes in job-related rules, statutes, laws and new business trends; makes recommendations for the implementation of changes; reads and interprets professional literature; attends training programs, workshops and seminars as appropriate. Position Requirements Education: Bachelor’s degree from an accredited college or university, preferably in Information Technology or related field. Experience: Six (6) years of information technology systems and/or application development and support experience including two (2) years of project lead or supervisory responsibility. Note: Additional experience may substitute on a year for year basis for the educational requirement. LICENSING, CERTIFICATION AND REGISTRATION REQUIREMENTS: Applicants may be required to possess a valid California Driver’s License, Class C. Some positions in this class will require technical certifications demonstrating expertise in specific bodies of knowledge. Note: All licenses, certificates and registrations requisite to the position must be kept current while employed in this class. This may include the completion of continuing education units to maintain the required registration in good standing. Supplemental Information Selection Process The position is open until filled and can close at any time. Based on the information provided in the application documents, the qualified applicants may be invited for further examination and will either be pre-scheduled by the Department of Human Resources or be invited to self-schedule. All applicants meeting the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination . Depending upon the number of applications received, the selection process may consist of an initial application screening, a mandatory information meeting, a supplemental questionnaire assessment, a written and/or practical exam, an oral board exam, or any combination listed. Responses to supplemental questions may be used as screening and testing mechanisms and will be used to assess an applicant’s ability to advance in the process; as such, responses to supplemental questions should be treated as test examination responses. Information contained herein does not constitute either an expressed or implied contract. Qualifying Under Education - Verification of Education Required All candidates qualifying for the position under the education requirement must submit a copy of their official/unofficial transcripts (verifying the courses and units completed) or degree (verifying institution, student, date, degree and area of specialization conferred) by the final filing date. Candidates who fail to submit their transcripts by the final filing date will be disqualified from the recruitment. PLEASE NOTE THE FOLLOWING: Candidates who attended a college or university that is accredited by a foreign or non-U.S. accrediting agency must have their educational units evaluated by an educational evaluation service. The result must be submitted to the Human Resources Department no later than the close of the recruitment. Please contact the local college or university to learn where this service can be obtained. How to Submit Your Documents In addition to uploading attachments when applying online, candidates may submit documents by fax to (707) 784-3424, or by email to recruitment@solanocounty.com . Be sure to include the recruitment title and the recruitment number in your email or fax. Veteran’s Preference Points To be eligible, applicant must have served at least 181 consecutive days of active duty in the Armed Forces of the United States and have received either an honorable discharge or a general discharge under honorable conditions. A COPY OF THE DD 214, SHOWING DISCHARGE TYPE (GENERALLY COPY 4), MUST BE RECEIVED IN THE HUMAN RESOURCES DEPARTMENT BY THE FINAL FILING DATE (or APPLICATION REVIEW DEADLINE). Applicants who have a service connected disability must also submit a recent award letter from the VA stating they are receiving disability benefits for service connected reasons. Veteran applicants for initial County employment with an honorable or general under conditions discharge shall receive five (5) points added to their combined score. Disabled veterans rated at not less than 30% disability shall have ten (10) points added to their combined score. Veteran’s preference points will only be added to passing scores in competitive open examinations. We offer a benefits package to employees which includes health care, dental, vision, retirement, deferred compensation plans, flexible spending accounts, life insurance, holidays, vacation, and sick leave. To learn more, view our benefits summary . Closing Date/Time: Continuous
Manages and oversees a major information technology system, group, or program including staff and contract resources; plans, designs, and coordinates the maintenance of the most difficult and complex infrastructure system or computerized data processing and applications systems for large, multi departmental or county wide functions; acts as a project/team leader and technical expert in assigned area(s) of responsibility, and oversees major information technology initiatives. Positions in this class head a major information technology section, program or initiative and may supervise lower level information technology professionals. Positions in this classification have the highest subject matter expertise for the assigned area and are proficient in project management, system development and design, GIS, infrastructure design and planning, and emerging technology development and implementation. This class is distinguished from the: Information Technology Analyst IV by responsibility for a major section, program or initiative with a high level of independence and responsibility for significant resources. Click here for the recruitment brochure with more information. The Ideal Candidate Cisco Technology Expertise: Proven expertise in configuring, managing, and troubleshooting a wide range of Cisco networking equipment, including routers, switches, firewalls, and wireless solutions. Advanced proficiency in working with the latest Cisco technologies, such as Cisco ACI, DNA Center, SD-WAN, and intent-based networking solutions. Routing experience in BGP, OSPF, EIGRP, HSRP, QOS, STP/RSTP/MSTP In-depth understanding of core Routing and Switching TCP IPv4 & IPv6 protocols, DNS, DHCP, SNMP, VLAN, VPN, MPLS, etc. Configure and maintain Cisco Firepower rule sets for security management. Network Design and Optimization: Demonstrated ability to design and implement network architectures that align with County objectives, emphasizing efficiency, reliability, and security. Proven experience in optimizing network performance, minimizing downtime, and ensuring seamless connectivity. Have experience designing, implementing, troubleshooting, and managing various networks, topologies, firewalls, Virtual Local Area Networks (VLANs), Cisco hardware and security mechanisms. Security and Compliance: In-depth knowledge of Cisco security solutions and protocols, including experience in implementing and maintaining robust security measures to safeguard against cyber threats. Familiarity with industry standards and compliance requirements, ensuring network security and data integrity. Be able to maintain the security and accessibility of the network. Troubleshooting and Incident Response: Strong analytical and problem-solving skills with a track record of effectively diagnosing and resolving complex network, communication, and hardware issues. Experience in developing and implementing incident response plans to minimize the impact of network disruptions. Have strong multitasking skills to analyze, plan, coordinate, implement, support, and administer the county-wide network that includes Transmission Control Protocol/Internet Protocol (TCP/IP), local area networks, wide area networks, wireless networks (Wi-Fi), and Virtual Private Networks (VPN). Understanding of the OSI model. Familiarity with ITIL v3 standards, procedures, policies. Team Collaboration and Leadership: Strong leadership skills with an ability to collaborate with cross-functional teams, providing technical leadership and mentorship. Self-motivated with the ability to work autonomously and make decisions based on technical confidence within mobility and core technology. Effective communication abilities, ensuring clear and concise documentation of network configurations and changes. Capability to understand County department requirements and provide tailored network solutions. Project management skills, enabling the successful completion of multiple projects within specified deadlines. Proficiency in managing external vendor services and implementation initiatives. Demonstrated expertise in developing and maintaining network documentation, along with establishing appropriate procedures. Positive demeanor for effective communication and interaction with others. Ability to analyze and facilitate the acquisition, installation, and application of vendor-supplied software and hardware products. Strong attention to detail in all aspects of work. Essential Duties This class specification represents the core area of responsibilities; specific position assignments will vary depending on the needs of the department. Coordinate the organization, staffing and operational activities for assigned information technology programs, initiatives, and projects; participate in the development and implementation of goals, objectives, policies and priorities related to information technology; recommend and implement resulting policies and procedures; identify opportunities for improving service delivery methods and procedures; identify resource needs; review with appropriate management staff; implement improvements. Oversees, coordinates, and participates in organizational, operational, and procedural analyses to determine information input, work processes, and desired output for potential and/or up dated computerization for a large number of users in support of a multi departmental or county wide applications; reviews and analyzes a variety of forms, documents, reports, data output, and record-keeping requirements. Consults with customer/user departments and advises on the feasibility of converting systems to computerized applications; analyzes departmental and County wide operations, functions, services, interdepartmental relationships, and the information sharing needs in the development of new and/or up dated systems and procedures; recommends improvements in operations and administration of existing systems. Direct, coordinate and review the work plan for assigned Information Services activities; assign work activities and projects; monitor work flow; review and evaluate work products, methods and procedures; meet with staff to identify and resolve problems. Oversee and coordinate the implementation of information technology projects; develop priorities for assigned projects; manage projects to ensure completion in a timely manner; recommend problem resolution or alternatives to keep projects on schedule. Participate in the development, preparation, and maintenance of the information technology strategic plans; recommend County-wide information technology standards; evaluate and develop proposed standards for hardware, software and networks. Select, train, motivate and evaluate Information Services personnel; provide or coordinate staff training; work with employees to correct deficiencies; implement discipline and termination procedures. Participate in the development and administration of assigned program budget; forecast funds needed for staffing, training, equipment, materials and supplies; monitor and approve expenditures; recommend adjustments as necessary. Provide staff assistance to higher level management staff; participate on a variety of committees; prepare and present staff reports and other correspondence as appropriate and necessary. Maintains professional knowledge in applicable areas and keeps abreast of changes in job-related rules, statutes, laws and new business trends; makes recommendations for the implementation of changes; reads and interprets professional literature; attends training programs, workshops and seminars as appropriate. Position Requirements Education: Bachelor’s degree from an accredited college or university, preferably in Information Technology or related field. Experience: Six (6) years of information technology systems and/or application development and support experience including two (2) years of project lead or supervisory responsibility. Note: Additional experience may substitute on a year for year basis for the educational requirement. LICENSING, CERTIFICATION AND REGISTRATION REQUIREMENTS: Applicants may be required to possess a valid California Driver’s License, Class C. Some positions in this class will require technical certifications demonstrating expertise in specific bodies of knowledge. Note: All licenses, certificates and registrations requisite to the position must be kept current while employed in this class. This may include the completion of continuing education units to maintain the required registration in good standing. Supplemental Information Selection Process The position is open until filled and can close at any time. Based on the information provided in the application documents, the qualified applicants may be invited for further examination and will either be pre-scheduled by the Department of Human Resources or be invited to self-schedule. All applicants meeting the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination . Depending upon the number of applications received, the selection process may consist of an initial application screening, a mandatory information meeting, a supplemental questionnaire assessment, a written and/or practical exam, an oral board exam, or any combination listed. Responses to supplemental questions may be used as screening and testing mechanisms and will be used to assess an applicant’s ability to advance in the process; as such, responses to supplemental questions should be treated as test examination responses. Information contained herein does not constitute either an expressed or implied contract. Qualifying Under Education - Verification of Education Required All candidates qualifying for the position under the education requirement must submit a copy of their official/unofficial transcripts (verifying the courses and units completed) or degree (verifying institution, student, date, degree and area of specialization conferred) by the final filing date. Candidates who fail to submit their transcripts by the final filing date will be disqualified from the recruitment. PLEASE NOTE THE FOLLOWING: Candidates who attended a college or university that is accredited by a foreign or non-U.S. accrediting agency must have their educational units evaluated by an educational evaluation service. The result must be submitted to the Human Resources Department no later than the close of the recruitment. Please contact the local college or university to learn where this service can be obtained. How to Submit Your Documents In addition to uploading attachments when applying online, candidates may submit documents by fax to (707) 784-3424, or by email to recruitment@solanocounty.com . Be sure to include the recruitment title and the recruitment number in your email or fax. Veteran’s Preference Points To be eligible, applicant must have served at least 181 consecutive days of active duty in the Armed Forces of the United States and have received either an honorable discharge or a general discharge under honorable conditions. A COPY OF THE DD 214, SHOWING DISCHARGE TYPE (GENERALLY COPY 4), MUST BE RECEIVED IN THE HUMAN RESOURCES DEPARTMENT BY THE FINAL FILING DATE (or APPLICATION REVIEW DEADLINE). Applicants who have a service connected disability must also submit a recent award letter from the VA stating they are receiving disability benefits for service connected reasons. Veteran applicants for initial County employment with an honorable or general under conditions discharge shall receive five (5) points added to their combined score. Disabled veterans rated at not less than 30% disability shall have ten (10) points added to their combined score. Veteran’s preference points will only be added to passing scores in competitive open examinations. We offer a benefits package to employees which includes health care, dental, vision, retirement, deferred compensation plans, flexible spending accounts, life insurance, holidays, vacation, and sick leave. To learn more, view our benefits summary . Closing Date/Time: Continuous
San Joaquin County, CA
Stockton, California, usa
Introduction San Joaquin County’s Information System Division (ISD) has an opening for a highly skilled information security professional. The Senior IT Security Engineer (Information Systems Analyst IV) is a member of ISD’s Information Security Team reporting to the Information Security Team Lead/Information Security Officer. The Senior IT Security Engineer acts as the senior staff member on a three-person team which is responsible for managing the information security controls and overall program for ISD and for several County departments. Job responsibilities include: incident response, threat hunting, risk management program maintenance, internal audit, security control implementation and testing, audit response, information security awareness and education delivery, and mentorship/development of junior information security staff. ISD is an award-winning IT department that has been recognized by the National Association of Counties (NACo) as among the most innovative and customer-service oriented IT Departments among all US Counties. Be a part of our success! This examination is being given to fill one vacancy in the ISD department and to establish a selective eligible list to fill future ISA IV PMO vacancies. Please be advised that Human Resources will only be accepting online applications for this recruitment. Resumes and paper applications will not be accepted in lieu of an online application. A completed application must be received online by the final filing deadline. DEFINITION Under direction, performs highly advanced professional computer and related systems support work within the Information Systems Division; provides highly advanced support to one or more departments with very complex computer systems and programs; may perform database administration duties; and performs other work as required in accordance with Rule 3, Section 3 of the Civil Service Rules. CLASS CHARACTERISTICS This is the highly advanced journey level class in the Information Systems Analyst series. Incumbents perform work of a professional nature, utilizing skills that require an understanding of very complex analytical procedures and processes while working with a very high level of independent authority and judgment. As assigned, some positions may exercise direct, functional or technical supervision over lower level staff; however, these supervisory duties are ancillary in nature and are not considered to be the primary purpose of the class. The program assignment will determine the emphasis of an incumbent’s duties as described below. This class is distinguished from the Information Systems Analyst III by the fact that incumbents assume responsibility for providing highly advanced systems analysis, design and development support to one or more departments with highly complex systems and programs, or serve as systems database administrators. Employees at this level may also be assigned to serve as a project lead on components of systems development projects and may provide lead direction and training to assigned project staff. This class is distinguished from the Information Systems Analyst V in that the latter serves as the highest level within the series, and assumes responsibility for coordinating a major functional/operational program area within the County’s most complex and strategic systems, network and database areas of operation. TYPICAL DUTIES Provides highly advanced professional level support to one or more departments with highly complex systems and programs; areas of responsibility include the analysis, evaluation, design, development and testing of these strategic systems, networks, programs and applications across multiple platforms and technologies; serves as database administrator on assigned systems. Designs and develops current or new systems for large and complex systems; analyzes user operations and business requirements to design and develop technology solution; reviews, evaluates and recommends current and third party systems and applications; creates or oversees the development of data flow diagrams and other systems documentation to develop program specifications; designs optimum system configurations; develops and implements testing plan; ensures system quality assurance; determines whether new program meets the client’s business and technology requirements and adjusts as required. Provides highly complex support in planning, developing, integrating, testing and evaluating the County’s local and wide area networks; determines network system requirements; studies the integrity and security of data to establish system configuration; monitors systems to control and support network traffic; devises and implements strategies for connection of other systems through the use of routers, bridges and gateways. Participates in the evaluation of network protocols, hardware and software to determine their applicability to County network needs; evaluates new applications to determine integration with current systems and applications. Investigates, analyzes and resolves network-related problems; resolve compatibility problems across systems and networks; troubleshoots complex network failures, router problems and telecommunications problems; recommends and implements changes and improvements. Analyzes network security and performance issues; identifies potential security and utilization or performance issues; designs strategies and recommendations to improve security and network performance. Performs database analysis, administration and maintenance duties; provides support to information technology staff in planning, designing and implementing databases; designs and modifies database structure, tables, files, views, and indexes; manages and maintains database and file space allocation; develops methodologies to export data from mainframe environment to other platforms; plans future storage requirements. Ensures database availability to system users; provides and controls user access; maintains database security to ensure data integrity; monitors users to ensure compliance with operational and security procedures; monitors database performance; makes database tuning changes as required; makes recommendations on enhancements to optimize resources; conducts and maintains database systems back ups to ensure timely recovery of data; develops alternative strategies for data recovery. As assigned, serves as project leader on components of information systems projects; analyzes client information system needs; recommends solutions and appropriate technology to meet client needs; designs project and resource plans and schedules; develops proposals using cost/benefit analyses; coordinates the installation and evaluation of proposed hardware and software to ensure compatibility with existing systems; coordinates programming activities; controls, monitors and reports budget expenditures; directs members of the project team; provides written reports and presentations on project status. Performs technical writing duties in the development and production of complex system documentation, instructional and procedural manuals; identifies training issues and coordinates training sessions for client users on assigned systems or applications; develops training schedule; designs training manuals; conducts training sessions; trains assigned project staff in their areas of work including structured programming and development methods, procedures and techniques. Attends and participates in professional group meetings; stay abreast of new trends and innovations in the field of information technology. May exercise direct or technical and functional supervision over lower level staff; assists in selecting, training, motivating and evaluating assigned staff; provides or coordinates staff training; works with employees to correct deficiencies. MINIMUM QUALIFICATIONS The following special requirements were approved by the Director of Human Resources on March 22, 2024. Education : Graduation from an accredited four-year college or university with a major in computer science, information systems, mathematics, business administration or a related field. Experience : Three years of increasingly professional, analytical information security work in an information systems environment. Substitution #1 : (Complete only if you do not possess a Bachelors' degree required under Pattern I) Possession of an approved information systems technology certificate may substitute for all or part of the required education. Please list the IT certificates that you possess. (The list of approved certificates and/or courses is available here ) Substitution #2 : Additional qualifying experience may substitute for the above required education on a year-for-year basis to a maximum of two years. KNOWLEDGE Operations, services and activities of a comprehensive information systems program across multiple operating platforms; advanced principles and practices of system design, development, analysis, testing and security administration; methods and techniques of evaluating complex systems and business requirements and developing information systems solutions; advanced programming languages, methods and techniques including integrated database management applications; operations, services and activities of local and wide area network design, development and administration; local and wide area network protocols; methods and techniques of resolving complex network system compatibility and integration issues; principles, practices, methods and techniques of supporting a comprehensive database design, management and administration program; operational characteristics of a variety of database systems, tools and utilities; principles and practices of quality assurance, data security, integrity, backup and recovery processes in assigned systems area; principles of lead supervision and training; principles and practices of project leadership; pertinent Federal, State and local codes, laws and regulations. ABILITY Analyze department operations, procedures and data to recommend, design and develop logical solutions to complex systems problems; perform highly complex systems and applications programming and analysis duties; recommend and implement quality assurance and security procedures for assigned systems; provide advanced level technical systems support by identifying and resolving problems for highly complex systems and applications; provide complex support in the design, configuration, implementation and testing of wide area network operating systems, hardware and software; analyze and troubleshoot complex local and wide area network operating, hardware and software system problems; perform database administration and maintenance functions; evaluate and make recommendations to accommodate future data storage needs; develop and modify database models based on County information technology needs; prepare clear and concise technical reports and documentation; as assigned, lead, direct and review the work of project staff; communicate clearly and concisely, both orally and in writing; establish and maintain effective working relationships with those contacted in the course of work. PHYSICAL/MENTAL REQUIREMENTS Mobility - Frequent use of keyboards; frequent sitting, standing or walking for long periods; occasional pushing/pulling, bending, squatting and crawling; driving. Lifting - frequently 5-30 pounds; occasionally 70 pounds or less. Vision - constant use of good overall vision; frequent reading/close-up work; occasional color, depth and peripheral vision. Dexterity - frequent repetitive motion; frequent writing; frequent grasping, holding, reaching. Hearing/Talking - frequent talking/hearing in person and on the telephone. Emotional/Psychological - frequent decision making and concentration; frequent public contact; occasional working alone, working nights and traveling. Environmental - frequent exposure to noise. San Joaquin County complies with the Americans with Disabilities Act and, upon request, will consider reasonable accommodations to enable individuals with disabilities to perform essential job functions. Equal Opportunity Employer San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation. For more information go to Equal Employment Opportunity Division (sjgov.org) . Accommodations for those covered by the Americans with Disabilities Act (ADA): San Joaquin County complies with the Americans with Disabilities Act and, upon request, will consider reasonable accommodations to enable individuals with disabilities to perform essential job functions. BENEFITS Employees hired into this classification are members of a bargaining unit which is represented by SEIU Local 1021 . Health Insurance : San Joaquin County provides employees with a choice of three health plans: a Kaiser Plan, a Select Plan, and a Premier Plan. Employees pay a portion of the cost of the premium. Dependent coverage is also available. Dental Insurance : The County provides employees with a choice of two dental plans: Delta Dental and United Health Care-Select Managed Care Direct Compensation Plan. There is no cost for employee only coverage in either plan; dependent coverage is available at the employee’s expense. Vision Insurance : The County provides vision coverage through Vision Service Plan (VSP). There is no cost for employee only coverage; dependent coverage is available at the employee’s expense. For more detailed information on the County’s benefits program, visit our website at www.sjgov.org under Human Resources/Employee Benefits. Life Insurance : The County provides eligible employees with life insurance coverage as follows: 1 but less than 3 years of continuous service: $1,000 3 but less than 5 years of continuous service: $3,000 5 but less than 10 years of continuous service: $5,000 10 years of continuous service or more: $10,000 Employee may purchase additional term life insurance at the group rate. 125 Flexible Benefits Plan : This is a voluntary program that allows employees to use pre-tax dollars to pay for health-related expenses that are not paid by a medical, dental or vision plan (Health Flexible Spending Account $2550 annual limit with a $500 carry over); and dependent care costs (Dependent Care Assistance Plan $5000 annual limit). Retirement Plan : Employees of the County are covered by the County Retirement Law of 1937. Please visit the San Joaquin County Employees’ Retirement Association (SJCERA) at www.sjcera.org for more information. NOTE: If you are receiving a retirement allowance from another California county covered by the County Employees’ Retirement Act of 1937 or from any governmental agency covered by the California Public Employees’ Retirement System (PERS), you are advised to contact the Retirement Officer of the Retirement Plan from which you retired to determine what effect employment in San Joaquin County would have on your retirement allowance. Deferred Compensation : The County maintains a deferred compensation plan under Section 457 of the IRS code. You may annually contribute $22,500 or 100% of your includible compensation, whichever is less. Individuals age 50 or older may contribute to their plan, up to $30,000. The Roth IRA (after tax) is also now available. Vacation : Maximum earned vacation is 10 days each year up to 3 years; 15 days after 3 years; 20 days after 10 years; and 23 days after 20 years. Holidays : Effective July 1, 2017, all civil service status employees earn 14 paid holidays each year. Please see the appopriate MOU for details regarding holidays, accruals, use, and cashability of accrued time. Sick Leave : 12 working days of sick leave annually with unlimited accumulation. Sick leave incentive : An employee is eligible to receive eight hours administrative leave if the leave balance equals at least one- half of the cumulative amount that the employee is eligible to accrue. The employee must also be on payroll during the entire calendar year. Bereavement Leave : 3 days of paid leave for the death of qualifying family member, 2 additional days of accrued leave for death of employee’s spouse, domestic partner, parent or child. Merit Salary Increase : New employees will receive the starting salary, which is the first step of the salary range. After employees serve 52 weeks (2080 hours) on each step of the range, they are eligible for a merit increase to the next step. Job Sharing : Employees may agree to job-share a position, subject to approval by a Department Head and the Director of Human Resources. Educational Reimbursement Program : Eligible employees may be reimbursed for career-related course work up to a maximum of $850 per fiscal year. Eligible employees enrolled in an approved four (4) year College or University academic program may be reimbursed up to $800 per semester for a maximum of $1600 per fiscal year. Parking Supplemental Downtown Stockton: The County contributes up to $20 per pay period for employees who pay for parking and are assigned to work in the Downtown Core Area. School Activities : Employees may take up to 40 hours per year, but not more than eight (8) hours per month, to participate in their children’s school activities. Selection Procedures Applicants who meet the minimum qualifications will go through the following examination process: Written Exam : The civil service written exam is a multiple choice format. If the written exam is administered alone, it will be 100% of the overall score. Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list. Oral Exam : The oral exam is a structured interview process that will assess the candidate’s education, training, and experience and may include a practical exercise. The oral exam selection process is not a hiring interview. A panel of up to four people will determine the candidate’s score and rank for placement on the eligible list. Top candidates from the eligible list are referred for hiring interviews. If the oral exam is administered alone, it will be 100% of the overall score. Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list. Written & Oral Exam: If both a written exam and an oral exam is administered, the written exam is weighted at 60% and the oral exam is weighted at 40% unless otherwise indicated on the announcement. Candidates must achieve a minimum rating of 70% on each examination in order to be placed on the eligible list. Rate-out: A rate-out is an examination that involves a paper rating of the candidate’s application using the following criteria: education, training, and experience. Candidates will not be scheduled for the rate-out process. Note: The rating of 70 referred to may be the same or other than an arithmetic 70% of the total possible points. Testing Accommodation: Candidates who require testing accommodation under the Americans with Disabilities Act (ADA) must call Human Resources Division at (209) 468-3370 prior to the examination date. Veteran’s Points : Eligible veterans, unmarried widows and widowers of veterans of the United States Armed Forces who have been honorably discharged and who have served during wartime shall be given veteran’s points in initial appointment to County service. Eligible veterans receive 5 points and eligible disabled veterans receive 10 points. Disabled veterans must submit a recent award letter stating a 10% service connected disability issued by the United States Veterans Administration. Note: A copy of your DD214 showing the discharge type must be received in the Human Resources by the date of the examination. Acceptable wartime service dates: September 16, 1940 to December 31, 1946 June 27, 1950 to January 31, 1955 August 5, 1964 to May 7, 1975 Persian Gulf War, August 2, 1990, through a date to be set by law or Presidential Proclamation. Eligible Lists: Candidates who pass the examination will be placed on an eligible list for that classification. Eligible lists are effective for nine months, but may be extended by the Human Resources Director for a period which shall not exceed a total of three years from the date established. Certification/Referral: Names from the eligible list will be referred to the hiring department by the following methods. Rule of the Rank: The top rank or ranks of eligibles will be referred for hiring interviews. The minimum number of names to be referred will be equal to the number of positions plus nine, or 10% of the eligible list, whichever is higher. When filling nine or more positions in a department at the same time, the top rank or ranks will be referred and the minimum number of names shall be two times the number of positions to be filled or 10% of the eligible list, whichever is higher. This applies only to open competitive recruitments. Rule of Five: The top five names will be referred for hiring interviews. This applies only to department or countywide promotional examination. Rule of the List: For classifications designated by the Director of Human Resources, the entire eligible list will be referred to the department. Physical Exam: Some classifications require physical examinations. Final appointment cannot be made until the eligible has passed the physical examination. The County pays for physical examinations administered in its medical facilities. Pre-Employment Drug Screening Exam: Some classifications require a new employee successfully pass a pre-employment drug screen as a condition of employment. Final appointment cannot be made until the eligible has passed the drug screen. The County pays for the initial drug screen. Employment of Relatives: Applicants who are relatives of employees in a department within the 3rd degree of relationship, (parent, child, grand parent, grand child or sibling) either by blood or marriage, may not be appointed, promoted, transferred into or within the department when; They are related to the Appointing Authority or The employment would result in one of them supervising the work of the other. Department Head may establish additional limitations on the hiring of relatives by departmental rule. Proof of Eligibility: If you are offered a job you will be required to provide proof of U.S. citizenship or other documents that establish your eligibility to be employed in the U.S. HOW TO APPLY Please be advised that Human Resources will only be accepting Online Application submittals for this recruitment. Paper application submittals will not be considered or accepted. Apply Online: www.sjgov.org/department/hr Office hours: Monday - Friday 8:00 am to 5:00 pm; excluding holidays. Phone: (209) 468-3370 Job Line: For current employment opportunities please call our 24-hour job line at (209) 468-3377. When a final filing date is indicated, applications must be submitted online to the Human Resources Division before the submission deadline. Resumes and paper applications will not be accepted in lieu of an online application. ( The County assumes no responsibility for online applications which are not received by the Human Resources Division) . San Joaquin County Substance Abuse Policy: San Joaquin County has adopted a Substance Abuse Policy in compliance with the Federal Drug Free Workplace Act of 1988. This policy is enforced by all San Joaquin County Departments and applies to all San Joaquin County employees. Equal Opportunity Employer : San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation. For more information go to www.sjgov.org/department/hr/eeo . Click on a link below to apply for this position: Fill out the Supplemental Questionnaire and Application NOW using the Internet. Apply Online View and print the Supplemental Questionnaire. This recruitment requires completion of a supplemental questionnaire. You may view and print the supplemental questionnaire here . View and print the official application form as an Acrobat pdf file. A San Joaquin County application form is required for this recruitment. You may print this Acrobat PDF document and then fill it in. Contact us via conventional means. You may contact us by phone at (209) 468-3370, or by email , or apply for a job in person at the San Joaquin County Human Resources Division. Closing Date/Time: Open Until Filled
Introduction San Joaquin County’s Information System Division (ISD) has an opening for a highly skilled information security professional. The Senior IT Security Engineer (Information Systems Analyst IV) is a member of ISD’s Information Security Team reporting to the Information Security Team Lead/Information Security Officer. The Senior IT Security Engineer acts as the senior staff member on a three-person team which is responsible for managing the information security controls and overall program for ISD and for several County departments. Job responsibilities include: incident response, threat hunting, risk management program maintenance, internal audit, security control implementation and testing, audit response, information security awareness and education delivery, and mentorship/development of junior information security staff. ISD is an award-winning IT department that has been recognized by the National Association of Counties (NACo) as among the most innovative and customer-service oriented IT Departments among all US Counties. Be a part of our success! This examination is being given to fill one vacancy in the ISD department and to establish a selective eligible list to fill future ISA IV PMO vacancies. Please be advised that Human Resources will only be accepting online applications for this recruitment. Resumes and paper applications will not be accepted in lieu of an online application. A completed application must be received online by the final filing deadline. DEFINITION Under direction, performs highly advanced professional computer and related systems support work within the Information Systems Division; provides highly advanced support to one or more departments with very complex computer systems and programs; may perform database administration duties; and performs other work as required in accordance with Rule 3, Section 3 of the Civil Service Rules. CLASS CHARACTERISTICS This is the highly advanced journey level class in the Information Systems Analyst series. Incumbents perform work of a professional nature, utilizing skills that require an understanding of very complex analytical procedures and processes while working with a very high level of independent authority and judgment. As assigned, some positions may exercise direct, functional or technical supervision over lower level staff; however, these supervisory duties are ancillary in nature and are not considered to be the primary purpose of the class. The program assignment will determine the emphasis of an incumbent’s duties as described below. This class is distinguished from the Information Systems Analyst III by the fact that incumbents assume responsibility for providing highly advanced systems analysis, design and development support to one or more departments with highly complex systems and programs, or serve as systems database administrators. Employees at this level may also be assigned to serve as a project lead on components of systems development projects and may provide lead direction and training to assigned project staff. This class is distinguished from the Information Systems Analyst V in that the latter serves as the highest level within the series, and assumes responsibility for coordinating a major functional/operational program area within the County’s most complex and strategic systems, network and database areas of operation. TYPICAL DUTIES Provides highly advanced professional level support to one or more departments with highly complex systems and programs; areas of responsibility include the analysis, evaluation, design, development and testing of these strategic systems, networks, programs and applications across multiple platforms and technologies; serves as database administrator on assigned systems. Designs and develops current or new systems for large and complex systems; analyzes user operations and business requirements to design and develop technology solution; reviews, evaluates and recommends current and third party systems and applications; creates or oversees the development of data flow diagrams and other systems documentation to develop program specifications; designs optimum system configurations; develops and implements testing plan; ensures system quality assurance; determines whether new program meets the client’s business and technology requirements and adjusts as required. Provides highly complex support in planning, developing, integrating, testing and evaluating the County’s local and wide area networks; determines network system requirements; studies the integrity and security of data to establish system configuration; monitors systems to control and support network traffic; devises and implements strategies for connection of other systems through the use of routers, bridges and gateways. Participates in the evaluation of network protocols, hardware and software to determine their applicability to County network needs; evaluates new applications to determine integration with current systems and applications. Investigates, analyzes and resolves network-related problems; resolve compatibility problems across systems and networks; troubleshoots complex network failures, router problems and telecommunications problems; recommends and implements changes and improvements. Analyzes network security and performance issues; identifies potential security and utilization or performance issues; designs strategies and recommendations to improve security and network performance. Performs database analysis, administration and maintenance duties; provides support to information technology staff in planning, designing and implementing databases; designs and modifies database structure, tables, files, views, and indexes; manages and maintains database and file space allocation; develops methodologies to export data from mainframe environment to other platforms; plans future storage requirements. Ensures database availability to system users; provides and controls user access; maintains database security to ensure data integrity; monitors users to ensure compliance with operational and security procedures; monitors database performance; makes database tuning changes as required; makes recommendations on enhancements to optimize resources; conducts and maintains database systems back ups to ensure timely recovery of data; develops alternative strategies for data recovery. As assigned, serves as project leader on components of information systems projects; analyzes client information system needs; recommends solutions and appropriate technology to meet client needs; designs project and resource plans and schedules; develops proposals using cost/benefit analyses; coordinates the installation and evaluation of proposed hardware and software to ensure compatibility with existing systems; coordinates programming activities; controls, monitors and reports budget expenditures; directs members of the project team; provides written reports and presentations on project status. Performs technical writing duties in the development and production of complex system documentation, instructional and procedural manuals; identifies training issues and coordinates training sessions for client users on assigned systems or applications; develops training schedule; designs training manuals; conducts training sessions; trains assigned project staff in their areas of work including structured programming and development methods, procedures and techniques. Attends and participates in professional group meetings; stay abreast of new trends and innovations in the field of information technology. May exercise direct or technical and functional supervision over lower level staff; assists in selecting, training, motivating and evaluating assigned staff; provides or coordinates staff training; works with employees to correct deficiencies. MINIMUM QUALIFICATIONS The following special requirements were approved by the Director of Human Resources on March 22, 2024. Education : Graduation from an accredited four-year college or university with a major in computer science, information systems, mathematics, business administration or a related field. Experience : Three years of increasingly professional, analytical information security work in an information systems environment. Substitution #1 : (Complete only if you do not possess a Bachelors' degree required under Pattern I) Possession of an approved information systems technology certificate may substitute for all or part of the required education. Please list the IT certificates that you possess. (The list of approved certificates and/or courses is available here ) Substitution #2 : Additional qualifying experience may substitute for the above required education on a year-for-year basis to a maximum of two years. KNOWLEDGE Operations, services and activities of a comprehensive information systems program across multiple operating platforms; advanced principles and practices of system design, development, analysis, testing and security administration; methods and techniques of evaluating complex systems and business requirements and developing information systems solutions; advanced programming languages, methods and techniques including integrated database management applications; operations, services and activities of local and wide area network design, development and administration; local and wide area network protocols; methods and techniques of resolving complex network system compatibility and integration issues; principles, practices, methods and techniques of supporting a comprehensive database design, management and administration program; operational characteristics of a variety of database systems, tools and utilities; principles and practices of quality assurance, data security, integrity, backup and recovery processes in assigned systems area; principles of lead supervision and training; principles and practices of project leadership; pertinent Federal, State and local codes, laws and regulations. ABILITY Analyze department operations, procedures and data to recommend, design and develop logical solutions to complex systems problems; perform highly complex systems and applications programming and analysis duties; recommend and implement quality assurance and security procedures for assigned systems; provide advanced level technical systems support by identifying and resolving problems for highly complex systems and applications; provide complex support in the design, configuration, implementation and testing of wide area network operating systems, hardware and software; analyze and troubleshoot complex local and wide area network operating, hardware and software system problems; perform database administration and maintenance functions; evaluate and make recommendations to accommodate future data storage needs; develop and modify database models based on County information technology needs; prepare clear and concise technical reports and documentation; as assigned, lead, direct and review the work of project staff; communicate clearly and concisely, both orally and in writing; establish and maintain effective working relationships with those contacted in the course of work. PHYSICAL/MENTAL REQUIREMENTS Mobility - Frequent use of keyboards; frequent sitting, standing or walking for long periods; occasional pushing/pulling, bending, squatting and crawling; driving. Lifting - frequently 5-30 pounds; occasionally 70 pounds or less. Vision - constant use of good overall vision; frequent reading/close-up work; occasional color, depth and peripheral vision. Dexterity - frequent repetitive motion; frequent writing; frequent grasping, holding, reaching. Hearing/Talking - frequent talking/hearing in person and on the telephone. Emotional/Psychological - frequent decision making and concentration; frequent public contact; occasional working alone, working nights and traveling. Environmental - frequent exposure to noise. San Joaquin County complies with the Americans with Disabilities Act and, upon request, will consider reasonable accommodations to enable individuals with disabilities to perform essential job functions. Equal Opportunity Employer San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation. For more information go to Equal Employment Opportunity Division (sjgov.org) . Accommodations for those covered by the Americans with Disabilities Act (ADA): San Joaquin County complies with the Americans with Disabilities Act and, upon request, will consider reasonable accommodations to enable individuals with disabilities to perform essential job functions. BENEFITS Employees hired into this classification are members of a bargaining unit which is represented by SEIU Local 1021 . Health Insurance : San Joaquin County provides employees with a choice of three health plans: a Kaiser Plan, a Select Plan, and a Premier Plan. Employees pay a portion of the cost of the premium. Dependent coverage is also available. Dental Insurance : The County provides employees with a choice of two dental plans: Delta Dental and United Health Care-Select Managed Care Direct Compensation Plan. There is no cost for employee only coverage in either plan; dependent coverage is available at the employee’s expense. Vision Insurance : The County provides vision coverage through Vision Service Plan (VSP). There is no cost for employee only coverage; dependent coverage is available at the employee’s expense. For more detailed information on the County’s benefits program, visit our website at www.sjgov.org under Human Resources/Employee Benefits. Life Insurance : The County provides eligible employees with life insurance coverage as follows: 1 but less than 3 years of continuous service: $1,000 3 but less than 5 years of continuous service: $3,000 5 but less than 10 years of continuous service: $5,000 10 years of continuous service or more: $10,000 Employee may purchase additional term life insurance at the group rate. 125 Flexible Benefits Plan : This is a voluntary program that allows employees to use pre-tax dollars to pay for health-related expenses that are not paid by a medical, dental or vision plan (Health Flexible Spending Account $2550 annual limit with a $500 carry over); and dependent care costs (Dependent Care Assistance Plan $5000 annual limit). Retirement Plan : Employees of the County are covered by the County Retirement Law of 1937. Please visit the San Joaquin County Employees’ Retirement Association (SJCERA) at www.sjcera.org for more information. NOTE: If you are receiving a retirement allowance from another California county covered by the County Employees’ Retirement Act of 1937 or from any governmental agency covered by the California Public Employees’ Retirement System (PERS), you are advised to contact the Retirement Officer of the Retirement Plan from which you retired to determine what effect employment in San Joaquin County would have on your retirement allowance. Deferred Compensation : The County maintains a deferred compensation plan under Section 457 of the IRS code. You may annually contribute $22,500 or 100% of your includible compensation, whichever is less. Individuals age 50 or older may contribute to their plan, up to $30,000. The Roth IRA (after tax) is also now available. Vacation : Maximum earned vacation is 10 days each year up to 3 years; 15 days after 3 years; 20 days after 10 years; and 23 days after 20 years. Holidays : Effective July 1, 2017, all civil service status employees earn 14 paid holidays each year. Please see the appopriate MOU for details regarding holidays, accruals, use, and cashability of accrued time. Sick Leave : 12 working days of sick leave annually with unlimited accumulation. Sick leave incentive : An employee is eligible to receive eight hours administrative leave if the leave balance equals at least one- half of the cumulative amount that the employee is eligible to accrue. The employee must also be on payroll during the entire calendar year. Bereavement Leave : 3 days of paid leave for the death of qualifying family member, 2 additional days of accrued leave for death of employee’s spouse, domestic partner, parent or child. Merit Salary Increase : New employees will receive the starting salary, which is the first step of the salary range. After employees serve 52 weeks (2080 hours) on each step of the range, they are eligible for a merit increase to the next step. Job Sharing : Employees may agree to job-share a position, subject to approval by a Department Head and the Director of Human Resources. Educational Reimbursement Program : Eligible employees may be reimbursed for career-related course work up to a maximum of $850 per fiscal year. Eligible employees enrolled in an approved four (4) year College or University academic program may be reimbursed up to $800 per semester for a maximum of $1600 per fiscal year. Parking Supplemental Downtown Stockton: The County contributes up to $20 per pay period for employees who pay for parking and are assigned to work in the Downtown Core Area. School Activities : Employees may take up to 40 hours per year, but not more than eight (8) hours per month, to participate in their children’s school activities. Selection Procedures Applicants who meet the minimum qualifications will go through the following examination process: Written Exam : The civil service written exam is a multiple choice format. If the written exam is administered alone, it will be 100% of the overall score. Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list. Oral Exam : The oral exam is a structured interview process that will assess the candidate’s education, training, and experience and may include a practical exercise. The oral exam selection process is not a hiring interview. A panel of up to four people will determine the candidate’s score and rank for placement on the eligible list. Top candidates from the eligible list are referred for hiring interviews. If the oral exam is administered alone, it will be 100% of the overall score. Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list. Written & Oral Exam: If both a written exam and an oral exam is administered, the written exam is weighted at 60% and the oral exam is weighted at 40% unless otherwise indicated on the announcement. Candidates must achieve a minimum rating of 70% on each examination in order to be placed on the eligible list. Rate-out: A rate-out is an examination that involves a paper rating of the candidate’s application using the following criteria: education, training, and experience. Candidates will not be scheduled for the rate-out process. Note: The rating of 70 referred to may be the same or other than an arithmetic 70% of the total possible points. Testing Accommodation: Candidates who require testing accommodation under the Americans with Disabilities Act (ADA) must call Human Resources Division at (209) 468-3370 prior to the examination date. Veteran’s Points : Eligible veterans, unmarried widows and widowers of veterans of the United States Armed Forces who have been honorably discharged and who have served during wartime shall be given veteran’s points in initial appointment to County service. Eligible veterans receive 5 points and eligible disabled veterans receive 10 points. Disabled veterans must submit a recent award letter stating a 10% service connected disability issued by the United States Veterans Administration. Note: A copy of your DD214 showing the discharge type must be received in the Human Resources by the date of the examination. Acceptable wartime service dates: September 16, 1940 to December 31, 1946 June 27, 1950 to January 31, 1955 August 5, 1964 to May 7, 1975 Persian Gulf War, August 2, 1990, through a date to be set by law or Presidential Proclamation. Eligible Lists: Candidates who pass the examination will be placed on an eligible list for that classification. Eligible lists are effective for nine months, but may be extended by the Human Resources Director for a period which shall not exceed a total of three years from the date established. Certification/Referral: Names from the eligible list will be referred to the hiring department by the following methods. Rule of the Rank: The top rank or ranks of eligibles will be referred for hiring interviews. The minimum number of names to be referred will be equal to the number of positions plus nine, or 10% of the eligible list, whichever is higher. When filling nine or more positions in a department at the same time, the top rank or ranks will be referred and the minimum number of names shall be two times the number of positions to be filled or 10% of the eligible list, whichever is higher. This applies only to open competitive recruitments. Rule of Five: The top five names will be referred for hiring interviews. This applies only to department or countywide promotional examination. Rule of the List: For classifications designated by the Director of Human Resources, the entire eligible list will be referred to the department. Physical Exam: Some classifications require physical examinations. Final appointment cannot be made until the eligible has passed the physical examination. The County pays for physical examinations administered in its medical facilities. Pre-Employment Drug Screening Exam: Some classifications require a new employee successfully pass a pre-employment drug screen as a condition of employment. Final appointment cannot be made until the eligible has passed the drug screen. The County pays for the initial drug screen. Employment of Relatives: Applicants who are relatives of employees in a department within the 3rd degree of relationship, (parent, child, grand parent, grand child or sibling) either by blood or marriage, may not be appointed, promoted, transferred into or within the department when; They are related to the Appointing Authority or The employment would result in one of them supervising the work of the other. Department Head may establish additional limitations on the hiring of relatives by departmental rule. Proof of Eligibility: If you are offered a job you will be required to provide proof of U.S. citizenship or other documents that establish your eligibility to be employed in the U.S. HOW TO APPLY Please be advised that Human Resources will only be accepting Online Application submittals for this recruitment. Paper application submittals will not be considered or accepted. Apply Online: www.sjgov.org/department/hr Office hours: Monday - Friday 8:00 am to 5:00 pm; excluding holidays. Phone: (209) 468-3370 Job Line: For current employment opportunities please call our 24-hour job line at (209) 468-3377. When a final filing date is indicated, applications must be submitted online to the Human Resources Division before the submission deadline. Resumes and paper applications will not be accepted in lieu of an online application. ( The County assumes no responsibility for online applications which are not received by the Human Resources Division) . San Joaquin County Substance Abuse Policy: San Joaquin County has adopted a Substance Abuse Policy in compliance with the Federal Drug Free Workplace Act of 1988. This policy is enforced by all San Joaquin County Departments and applies to all San Joaquin County employees. Equal Opportunity Employer : San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation. For more information go to www.sjgov.org/department/hr/eeo . Click on a link below to apply for this position: Fill out the Supplemental Questionnaire and Application NOW using the Internet. Apply Online View and print the Supplemental Questionnaire. This recruitment requires completion of a supplemental questionnaire. You may view and print the supplemental questionnaire here . View and print the official application form as an Acrobat pdf file. A San Joaquin County application form is required for this recruitment. You may print this Acrobat PDF document and then fill it in. Contact us via conventional means. You may contact us by phone at (209) 468-3370, or by email , or apply for a job in person at the San Joaquin County Human Resources Division. Closing Date/Time: Open Until Filled
City of Los Angeles
City Of Los Angeles, California, United States
DUTIES ANNUAL SALARY: $115,967 to $169,503 The salary in the Department of Water and Power is $138,058 to $171,529. NOTES : Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City’s on-premises and cloud-based databases; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; utilizes database tools to perform various types of database backups and recoveries; ensures database security and compliance with SB1386 or data privacy acts; researches current database issues and technologies; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor’s degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field; AND ONE OF THE FOLLOWING : Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing. A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience: Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google Certified Professional Data Engineer PROCESS NOTES: Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met. Some positions may require a valid California driver’s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI). Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf . Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section. Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing. Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to: Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA) SELECTIVE CERTIFICATION: In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. Applications will only be accepted on-line on the dates listed below: Friday, September 13, 2024 to Thursday, September 26, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the selection process in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, SEPTEMBER 13, 2024 and THURSDAY, SEPTEMBER 26, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between TUESDAY, NOVEMBER 5, 2024 and TUESDAY, NOVEMBER 12, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, SEPTEMBER 13, 2024 and THURSDAY, SEPTEMBER 26, 2024 , it is anticipated that interviews will begin during the period of DECEMBER 2, 2024 to DECEMBER 13, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: 9/26/2024 11:59 PM Pacific
DUTIES ANNUAL SALARY: $115,967 to $169,503 The salary in the Department of Water and Power is $138,058 to $171,529. NOTES : Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City’s on-premises and cloud-based databases; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; utilizes database tools to perform various types of database backups and recoveries; ensures database security and compliance with SB1386 or data privacy acts; researches current database issues and technologies; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor’s degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field; AND ONE OF THE FOLLOWING : Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing. A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience: Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google Certified Professional Data Engineer PROCESS NOTES: Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met. Some positions may require a valid California driver’s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI). Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf . Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section. Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing. Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to: Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA) SELECTIVE CERTIFICATION: In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. Applications will only be accepted on-line on the dates listed below: Friday, September 13, 2024 to Thursday, September 26, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the selection process in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, SEPTEMBER 13, 2024 and THURSDAY, SEPTEMBER 26, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between TUESDAY, NOVEMBER 5, 2024 and TUESDAY, NOVEMBER 12, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, SEPTEMBER 13, 2024 and THURSDAY, SEPTEMBER 26, 2024 , it is anticipated that interviews will begin during the period of DECEMBER 2, 2024 to DECEMBER 13, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: 9/26/2024 11:59 PM Pacific