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
EITHER PATTERN I
Experience: One year as an Information Systems Analyst III in San Joaquin County.
OR PATTERN II
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 responsible professional, analytical computer and related systems work in an information systems environment.
Substitution # 1: Possession of an approved information systems technology certificate, or completion of an approved information systems training course may substitute for all or part of the above required education. A list of approved certificates and/or courses shall be maintained within the Human Resources Department.
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.
Notify Me when a Job Opens for the above position(s)