City of West Sacramento West Sacramento, CA, USA
Sep 15, 2023Full Time
DEFINITION: The Information Technology Specialist performs a variety of professional level work in designing, installing, managing, updating, integrating and securing Information Technology systems; provides professional level analysis and guidance to help solve business problems; operates computer equipment as required; and provides functional and technical assistance to City personnel. SUPERVISION RECEIVED AND EXERCISED: Receives general supervision from the Information Technology Manager and/or his/her designee. The Information Technology Specialist may provide technical and/or functional supervision over support staff as-needed. CLASS CHARACTERISTICS: This class is distinguished as being at the journey-level having responsibility for the full range of technical and professional functions necessary to accomplish the tasks and duties assigned with minimal direction or assistance. EXAMPLES OF ESSENTIAL FUNCTIONS: (Illustrative Only): Management reserves the right to add, modify, change or rescind the work assignments of different positions and to make reasonable accommodations so that qualified employees can perform the essential functions of the job. Technical Services Prepares and maintains system procedures and documentation, including data networks involving fiber and ethernet cabling as well as networking equipment (core and edge switches, routers, wireless access points and controllers), telecommunications, phone and voicemail equipment. Designs, implements, supports, manages and ensures operating capacity of the local area networks (LAN), wide area networks (WAN) to ensure proper 24/7 operational functioning. Consults and/or provides technical assistance to City staff for server, storage and network related questions and concerns. Analyzes, builds, deploys, and maintains city servers. Manages and maintains City server environment (operating systems, security, system updates, etc.). Monitors network security systems such as firewall, intrusion detection systems, event log, spam filtering, internet filtering, anti-virus system, and ensures that the security and integrity of the City's network infrastructure is maintained at all times. Monitors and maintains system backups and disaster recovery. Maintains and supports network domain services (i.e. active directory, DNS, DHCP, etc.). Analyzes, builds, configures, deploys, and maintains network and telecommunication equipment (i.e. routers, switches, firewalls, etc.). Designs, develops, tests, and implements computer applications and systems. Analyzes problems with existing network applications. Analyzes current server, storage and network related processes, procedures and workflows. Recommends and implements enhancements based on analysis. Assists in determining network, server and storage equipment needs. Administers e-mail and collaboration systems. Primarily responsible for advanced security measures and initiatives. Provide project management; develop project plans and detailed project objectives; develop and guide project timelines; assess and manage risks; manage issues. Data & Analytics Administers database management system, schedules upgrades and monitors systems. Design, update and install databases for new systems. Perform data mining using state-of-the-art methods. Knowledge of and experience with implementing machine learning techniques and algorithms to solve complex data related problems to help drive business needs. Knowledge of and experience with using data science and visualization toolkits to help drive business related decisions. Conducting deep quantitative analysis to understand the strengths and weaknesses of datasets and identify the root causes of complex social and economic problems In-depth understanding and experience with the SQL. Interpret data and analyze results using statistical techniques including, but not limited to, distributions, statistical testing, and multiple regression. Identify, analyze, and interpret trends or patterns in complex data sets. Research, plan, install, configure and test new data related systems; maintain and upgrade existing systems. Design and implement interfaces between database systems. Optimize database systems by performing routine maintenance procedures. Create and maintain user permissions, system privileges, passwords and other security methods for securing access to database systems. Provide technical support in the planning of new database systems including hardware, operating systems, licensing and storage requirements for new systems. Enforce data quality standards and perform quality control checks on associated data. Monitor database performance against established standards; detect and troubleshoot problems. Provide advanced level support for the data, analysis and database related issues. Coordinate assigned functions with and provide support to other departments, other jurisdictions and agencies, and the general public; conduct user training on group or individual basis as needed; advise and train information systems personnel on database issues. Partner with City departments and provide database solutions to meet business needs; integrate database solutions with other City enterprise solutions. Knowledge of extract, transform and load (ETL) tools and methodologies. Assist in the development and maintenance of database policies and procedures. Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality. Acquire data from primary or secondary data sources and maintain databases/data systems. Filter and "clean" data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems. Work with management to prioritize business and information needs. Locate and define new process improvement opportunities Provide project management; develop project plans and detailed project objectives; develop and guide project timelines; assess and manage risks; manage issues. Enterprise Systems Perform analytical and technical work through enterprise systems that support assigned City business applications. Conduct business analysis; evaluate business processes; determine business needs; identify requirements; and develop business plan analysis for City enterprise systems. Provide and/or ensure follow up on trouble calls and tickets; correspond with or meet customers and vendors as needed to understand and resolve concerns. Analyze data and information trends to support system capacity/performance planning or diagnose issues related to assigned systems; compile and prepare reports and documentation on analysis findings. Perform installation and configuration duties and related data migration, conversion, and maintenance and extraction work; implement and maintain databases, database tables and database objects; develop database scripts as needed for assigned systems. Perform configuration, testing and troubleshooting for network/communications devices and/or interfaces that support assigned systems. Coordinate implementation of the system software, including conversion of data to new systems; work with application support personnel to resolve system problems. Assist departments in defining requirements for proposed business applications; review, analyze and evaluate business applications and user needs; translate business objectives into application requirements. Develop and participate in the development of requests for proposals, quotes, or information; participate in the selection; and assist with the oversight of consultants and vendors. Perform reporting, testing and general maintenance of enterprise systems and identify alternative methods for better operation and use. Research, plan, install, configure and test new application systems and interfaces; maintain and upgrade existing application systems and interfaces. Analyze and resolve technology related problems; resolve compatibility problems and troubleshoot system software, hardware and communication problems. Prepare and maintain documentation for each application; design backup procedures; and analyze problems with existing applications. Work closely with assigned City departments and divisions to understand and identify user computer system and equipment needs; analyze and evaluate present or proposed business procedures or problems to define enterprise application needs. Create, record, and maintain user access and security; provide training to users regarding enterprise applications use and operating procedures. Monitor automated system processes; monitor logs and files for evidence of problems or system failures; ensure business resumption after system failures. Research, compile and prepare reports and documentation on program activities; analyze program and develop corrective action, maintain records of findings and corrective actions; prepare periodic status reports. Serve as liaison with system software and hardware suppliers and vendors; monitor contracted services for quality and compliance with City standards. Client Services Plan, prioritize, and review the work of staff assigned to a variety of technical information technology functions that may include the installation and configuration of hardware and software, troubleshooting of desktop operating systems, and end user, as assigned. Develop schedules and methods to accomplish assignments ensuring work is completed in a timely and efficient manner. Participate in evaluating the activities of staff, recommending improvements and modifications. Provide and coordinate staff training; work with employees to correct deficiencies. Provide technical support in diagnosing and solving the more difficult problems by telephone or remote access; respond to help desk trouble tickets according to urgency and priority levels; log calls into help desk software. Develop documentation and standard operating procedures as they relate to assignment. Oversee and participate in projects related to the deployment of PC's, the procurement of software and hardware, and/or hardware consolidation. Test, implement and maintain computer systems to manage devices and automate distribution of software and security updates. Participate in the development and implementation of automation and process improvement in the areas of software distribution, security updates and the management of desktop computer. Test and implement upgrades to desktop enterprise applications and operations systems. Troubleshoot and resolve the more difficult projects related to network account management; provide support for emergency incident diagnosis resolution. Install and configure desktop computers, printers, and other desktop peripherals; install and support various software and train customers in the use of hardware and software. Support and troubleshoot current desktop operating systems; perform basic diagnostic testing; analyze root cause of problem and develop long-term solutions. Analyze failed equipment and perform repairs or return equipment to vendor; review and test vendor repairs. Order supplies and maintain and track inventory; assist in asset management of personal computers, laptops, and related peripheral equipment.