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.

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.

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.

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 administe