Under direction, performs highly advanced professional duties in the analysis, design, evaluation, development, testing and implementation of strategic systems, networks and programs across multiple platforms and technologies within an assigned department; performs database management duties; troubleshoots, analyzes and resolves highly complex systems and network hardware and software problems; 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 level class in the Department Information Systems Analyst series. Incumbents perform work of a professional rather than technical nature, utilizing skills that require an understanding of analytical procedures and processes. This class is distinguished from the Department Information Systems Analyst III level in that positions at the Department Information Systems Analyst IV level serve as the highest-level resource within the department for systems and network design, development and implementation and/or serve as department systems database administrators. Employees at this level may also serve as a project manager for an assigned information systems project, although project management alone is not the only distinguishing characteristic for allocation to this level of the series. 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.
TYPICAL DUTIES
Provides highly advanced professional level support in the analysis, design, evaluation, development, testing and implementation of strategic systems, networks and programs across multiple platforms and technologies.
Plans, develops, integrates, tests and evaluates the department's local and wide area networks; determines network system requirements; evaluates network protocols, hardware and software to determine their applicability to department network needs; evaluates new applications to determine integration with current systems and applications; studies the integrity and security of data; monitors systems to control and support network traffic; devises and implements strategies for connection of other systems through the use of network infrastructure and components.
Investigates, analyzes and resolves highly complex network-related problems; resolves compatibility problems across multiple 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 management, analysis, administration and maintenance duties; provides support to department information technology staff in planning, designing and implementing databases; designs and modifies database structures, tables, files, views, and indices; manages and maintains database and file space allocation; develops methodologies to export and import data within multiple operating environments; 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.
Designs and develops current or new programs 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 programs; 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.
As assigned, serves as project manager on systems projects; analyzes client information system needs; recommends solutions and appropriate technology; 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.
As assigned, 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.
Attends and participates in professional group meetings; stays abreast of new trends and innovations in the field of information technology.
MINIMUM QUALIFICATIONS
Note: Incumbents who, at the time that Classification Study #01-22 is adopted by the Board of Supervisors, occupy full-time Civil Service positions reclassified to this class by the study, shall be deemed to meet the requirements listed below.
EITHER PATTERN I
Experience: One year as a Department Information Systems Analyst III in San Joaquin County.
OR PATTERN II
Education: Graduation from an accredited four-year college or university with major course work 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 part or all of the 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 and network design, development, analysis, testing and security administration; methods and techniques of evaluating complex systems and business requirements and developing information systems solutions; information systems infrastructure planning and development; advanced principles and practices of structured programming; advanced programming languages, methods and techniques including integrated database management; principles and practices of local and wide area network design, protocols, development, security and administration; operational characteristics of multiple operating system environments, networks, and associated hardware, software, database and related components; 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; relational database design and management theory, techniques and tools; principles and practices of quality assurance, data security, integrity, backup and recovery; principles and practices of project management; 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, network and applications programming and analysis duties; recommend and implement quality assurance and security procedures; provide highly advanced level technical systems support; perform feasibility studies and conduct cost-benefit analyses; design and integrate systems and programs within multiple operating environments; analyze and resolve highly complex system and network problems using logical and methodical processes; 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; develop and modify database models based on department information technology needs; prepare clear and concise technical reports and documentation; as assigned, provide project management services; 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 data entry devices; 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 (ADA) 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)