Under general direction, performs the highest level of professional computer and related systems support work, including comprehensive and complex systems design, analysis and development within the Information Systems Division; assumes responsibility for developing, directing and ensuring operational availability and security of the County's most complex and strategic operations including mainframe, networked and database systems; and performs other work as required in accordance with Rule 3, Section 3 of the Civil Service Rules.
This is the highest-level class in the Information Systems Analyst series. Incumbents perform work of a professional nature, utilizing skills that require an understanding of the most complex analytical procedures and processes in the Division while working with a very high level of independent authority and judgment. The program assignment will determine the emphasis of an incumbent's duties as described below.
This class is distinguished from the Information Systems Analyst IV class by the fact that incumbents in this class serve as the highest level technical resource within their assigned systems area and also assume responsibility for directing and coordinating operational and technical functions for the County's most complex and strategic systems, network and database operations.
Assumes responsibility for developing, directing and ensuring operational availability and security of the County's most complex and strategic operations including mainframe, networked and database systems.
Performs comprehensive systems analysis to design and develop new systems and enhancements to current systems; consults, confers and coordinates activities with users, staff from various departments, outside agencies and vendors to resolve program, system, operational and procedural problems; analyzes problems and recommends corrective action.
Plans, develops and analyzes additions, changes and enhancements to mainframe system software; researches, evaluates, installs and implements new versions and releases for integration into existing systems; determines impact on existing County systems and applications; troubleshoots, analyzes and resolves hardware and software related problems; coordinates and documents testing procedures.
Serves as technical resource in architecting wide area network and Internet/Intranet growth that supports the County's strategic direction; directs, plans and coordinates the development, implementation and maintenance of the County's Internet and Intranet sites to ensure service availability and connectivity to County departments.
Develops and administers strategies, policies and procedures for network availability and security; designs and implements firewall strategies to ensure County data security and integrity.
Installs and maintains new and upgraded software for database management systems; establishes procedures for database operation, control and recovery.
Serves as technical advisor for data planning, modeling, conceptual and physical design of database entities; updates and maintains County data dictionary.
Ensures database availability to system users; provides controls, grants and revokes user access; develops standards and strategies for maintaining database security and integrity; monitors users to ensure compliance with operational and security procedures; performs database management duties; provides support to information technology staff in planning, designing and implementing highly complex databases; designs, creates, maintains and modifies database structure, tables, files, views, and indexes; manages database and file space allocation; develops methodologies to export data from mainframe environment to other platforms; makes recommendations on strategies to meet future storage requirements.
Develops, maintains and enforces data resource management standards and procedures; develops standards and strategies for data recovery.
Serves as project leader on 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; evaluates proposed system hardware and software to ensure compatibility with existing systems; oversees the installation and evaluation of software and hardware; controls 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 highly complex system documentation, instructional and procedural manuals.
Trains assigned project staff in their areas of work including system, network and database design, development, and programming methods, procedures and techniques.
Attends and participates in professional group meetings; stays abreast of new trends and innovations in the field of information technology.
Experience: One year as an Information Systems Analyst IV in San Joaquin County.
Note: This requirement shall be waived for individuals employed within the Information Systems Division in the San Joaquin County classes of Senior Office Systems Analyst and Senior Systems Programmer on September 13, 2000. Individuals employed within the Information Systems Division in the San Joaquin County classes of Systems and Programming Analyst IV, Systems and Procedures Analyst II or Systems and Programming Coordinator on September 13, 2000 shall receive credit for their experience in those classes on a year-for-year basis.
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: Four 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.
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; advanced methods and techniques of evaluating business requirements and developing information systems solutions for strategic County systems; principles and practices of project management; advanced principles and practices of programming languages, job control languages, and executive control command; advanced principles and practices of system software and hardware installation and troubleshooting; functional structure of various operating system components, including system control programs and data access methods; advanced concepts, principles and practices of Internet and Intranet web site design, development and administration; advanced concepts, principles and practices of wide area network design, development, protocols, security and administration; operations, services and activities of a comprehensive database administration program; advanced programming techniques including integrated database management applications; advanced methods and techniques of developing data security, integrity, backup and recovery processes; advanced principles of database design, administration, management and integrity; principles and concepts of relational database management systems; principles and concepts of data planning, modeling, design and storage; operational characteristics of database support tools, servers and communication devices; principles of lead supervision and training; methods and techniques of developing complex application technical user manuals and documentation; pertinent Federal, State and local laws, codes and regulations.
Direct and coordinate technical operations and services in assigned systems area; serve as technical advisor in assigned systems area; analyze department procedures and data to develop logical solutions to complex systems problems; recommend, evaluate, design, develop, test and install complex operating systems, applications and supporting hardware and software; plan, develop, establish, monitor and maintain system security strategies in assigned systems area; provide advanced level technical support for the implementation and maintenance of mainframe software systems; perform operational functions on mainframe systems; plan and oversee quality assurance and security procedures for mainframe, database, and network systems; provide support to complex wide are network design and implementation projects; troubleshoot and analyze complex local and wide area network operating, hardware and software problems; design and manage physical storage structures; develop strategies to accommodate future data storage needs; evaluate database needs and develop database models to meet County information technology needs; as assigned, lead and review the work of project staff; prepare clear and concise technical reports and documentation; communicate clearly and concisely, both orally and in writing; establish and maintain effective working relationships with those contacted in the course of work.
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.