Systems Analyst II

Unified Government of Athens-Clarke County•Athens, GA

2d•Onsite

About The Position

The purpose of this job is to perform systems and applications analysis, development, implementation, support, and maintenance activities. Duties and responsibilities include, but are not limited to: analyzing automation needs county wide; plan, design, develop, and launch efficient information systems and operations systems in support of core organizational functions, manage hardware and software usage, configure and deploy end user devices, respond to service desk calls, and train end users. This individual will apply proven communication, analytical and problem-solving skills to help identify, communicate and resolve systems issues in order to maximize the benefit of IT systems investments.

Requirements

Bachelor's degree in computer science, information management, information systems geographic information systems (GISA), mathematics, business administration or a related field and three years of experience in one or more of the following areas in a multi-user environment required: Database Administration, Network Management, Desktop Management, Server Management, Virtual Environment Administration, Enterprise E-Mail Administration, Application Development, Security Management, Storage Area Network, GIS Administration, Project Management, and/or Document Management; or any equivalent combination of education, training, and experience which provides the requisite knowledge, skills, and abilities for this position.
Must have one (1) or more entry-level IT certifications in any of the following: A+, Network+, Project+, Security+, Server+, CYSA+, ArcGIS Desktop Associate, Microsoft Beginner Level (any), Cisco CCST (cybersecurity or networking), or VMWare VCTA-DCV.
Extensive practical knowledge in importing data for use in reporting software, spreadsheets, graphs, and flow charts.
Must possess a valid driver's license.
Criminal fingerprint background check must indicate eligibility for access to sensitive public data.
Knowledge of the policies, practices, procedures, and activities of the Athens-Clarke County Government and the operations and functions of the Information Technology Department.
Knowledge of applicable legal policies, procedures, and methods as required in the performance of duties.
Knowledge of computer terminology.
Knowledge of the following: Troubleshooting and resolving hardware, software and peripheral problems
Current Microsoft operating systems
Mobile operating systems (Android/Apple iOS, Windows).
Mid-range and mainframe (iSeries/AS400, Unix) Systems analysis and design methods (problem definition, collection of data, establishing facts, drawing conclusions and making appropriate recommendations)
Basic network knowledge: design topologies, protocol usage and troubleshooting
Business Intelligence applications (SSRS, Crystal Reports, Cognos)
Programming languages (including scripting, web, client/server, mainframe/midrange)
Staying up to date with current technology trends and principles
Project management principles
Virtual environments (virtual desktop infrastructure, virtual application delivery, hypervisors)
Database management
Knowledge of hardware and software utilized by Athens-Clarke County.
Knowledge of access control systems and technologies, including badge readers, electronic credentials, access control panels, system management software, and basic troubleshooting and monitoring functions.
Knowledge of outdoor video surveillance systems, including camera types, placement and coverage considerations, video management software, recording capabilities, and basic troubleshooting.
Ability to compile, organize, prepare and maintain an assortment of records, reports and information in an effective manner and according to division, departmental and/or other governmental regulations.
Ability to comprehend and apply the regulations and procedures of the division and the department.
Ability to communicate technical information to other personnel.
Ability to develop knowledge of the job functions and terminology used by personnel in other departments in order to understand and meet automation needs.
Ability to communicate and interact effectively with management, other IT staff members, vendors, and all groups involved in the activities of the Athens-Clarke County government.
Ability to assemble information and write reports and documents in a concise, clear, and effective manner.
Ability to plan, organize, and prioritize short and long term assignments and work activities.
Ability to use independent judgment in routine and non-routine situations.
Ability to perform mathematical calculations.
Ability to assist and instruct a wide variety of ACC government personnel in the proper and optimal use of available automation tools and systems.
Ability to acquire, integrate, and apply new technical knowledge.
Ability to work in a team oriented, collaborative environment.
Skill in troubleshooting and problem-solving.
Must be physically able to operate a variety of machinery and equipment including computer equipment and tools for electronic and mechanical repairs.
Must be able to use body members to work, move or carry objects or materials.
stooping, kneeling, crouching, climbing, crawling, reaching, standing, walking, pushing, pulling, lifting, fingering, grasping, feeling, seeing, talking, hearing, and repetitive motions.
Must be able to exert up to 50 pounds of force occasionally, and/or up to 20 pounds of force frequently.
Requires the ability to compare and/or judge the readily observable functional, structural, or compositional characteristics (whether similar to or divergent from obvious standards) of data, people, or things.
Requires the ability to hear, speak and/or signal people to convey or exchange information. Includes giving / receiving assignments and/or directions to co-workers or assistants / from supervisors.
Requires the ability to read a variety of computer documents, manuals, diagrams, reports, and informational documentation, directions, instructions, and methods and procedures.
Requires the ability to prepare technical documentation, flow charts, system reports, purchase orders, correspondence, and other records, reports, and charts using prescribed formats and conforming to all rules of punctuation, grammar, diction, and style.
Requires the ability to speak to people and groups of people with poise, voice control, and confidence.
Requires the ability to learn and understand complex principles and techniques; to acquire and be able to expound on knowledge of topics related to primary occupation; and to make independent judgment in the absence of management.
Requires the ability to record and deliver information, to explain procedures, and to follow oral and written instructions.
Must be able to communicate effectively and efficiently in a variety of administrative, technical or professional languages including computer, accounting, legal, and personnel terminology.
Requires the ability to utilize mathematical formulas; add and subtract totals; multiply and divide; utilize and determine percentages; interpret graphs; perform calculations involving variables, formulas, square roots, and polynomials.
Requires the ability to inspect items for proper length, width, and shape, visually with various computer equipment and tools.
Requires the ability to coordinate hands, fingers, and accurately eyes in using computer equipment and tools.
Requires the ability to use the keyboard, lift, bend, push, and pull objects or materials using body parts as the position necessitates.
Requires the ability to handle a variety of items such as screwdrivers, crimpers, strippers, line testing equipment, and other computer equipment and tools.
Must have the ability to use one hand for twisting or turning motion while coordinating other hand with different activities.
Must have minimal levels of eye/hand/foot coordination.
Requires the ability to differentiate between colors and shades of color.
Requires the ability to deal with people beyond giving and instructions.
Must be adaptable to performing under considerable stress when confronted with an emergency.
Must be able to communicate via telephone, two-way radio.

Nice To Haves

Database Administration
Network Management
Desktop Management
Server Management
Virtual Environment Administration
Enterprise E-Mail Administration
Application Development
Security Management
Storage Area Network
GIS Administration
Project Management
Document Management
Clariti built on Salesforce and/or associated systems preferred

Responsibilities

Conducts systems analysis of manual and automated systems for unified government departments and divisions; review and analyze the effectiveness and efficiency of existing systems and develop strategies for further leveraging these systems or migrating to new platforms.
Evaluates hardware and software based upon current and anticipated user needs and vendor demonstrations.
Collaborates with management, staff, and internal customers to determine desired technological goals, priorities, and resources.
Analyzes operating procedures and develops related operating manuals.
Designs and implements systems; writes, compiles, changes, and tests new programs and conversions between systems.
Performs system configurations, installations, and modifications.
Trains users on hardware and software; demonstrates new systems and assists users with computer related problems.
Designs inter-machine program conversions.
Provides advanced technical assistance and troubleshooting for computer hardware, software, network and/or other related technology problems.
Assists with problem and/or process identification, definition and resolution.
Tests and de-bugs systems; writes internal, on-line, system, and user program documentation.
Plans and performs disaster data recovery activities as needed.
Consults with outside technical engineers when performing troubleshooting and problem solving activities as needed.
Implements and maintains security of confidential data, applications, and systems.
Provides on-call support services to all departments.
Develops and maintains contacts with vendors and technicians.
Tracks and documents time usage in monthly reports and bi-weekly time sheets.
Tracks hardware and software assets.
Implement, and review backup jobs and security systems on the ACC network servers and other storage systems.
Develop business recovery documents for equipment failure and disaster recovery.
Review logs for backup and recovery to ensure backup is performing correctly and system recovery is possible and review network data packets to ensure that systems are not infected with viruses.
Test recovery plans and systems to ensure they work properly.
Consult with departments regarding critical data on local machines (PCs) to ensure it is recoverable, as well as, applications & system security.
Make recommendations on future backup and recovery needs, virus, intrusion and detection systems for budget planning.
Administer all backup systems, virus, intrusion and detection systems used within Athens-Clarke County.
Monitor and review intrusion detection equipment to ensure Athens-Clarke County's network has adequate defenses in place against intrusion.
Monitor security of applications to ensure that access to databases is controlled according to policy.
Assess and develop long-term strategic goals for production databases in conjunction with data owners.
Work with staff to upgrade database architectures, standards, and quality assurance policies and procedures.
Create models for new database development and/or changes to existing ones and performs database management.
Respond to and resolve database access and performance issues.
Monitor database system details within the database, including stored procedures, SQL queries, and execution times, and implement efficiency improvements as they are identified using data processing techniques, entity relationships, or the Unified Modeling Language (UML).
Monitor, optimize, and allocate physical data storage for database systems.
Plan and coordinate data migrations between systems as necessary.
Develop, implement, and maintain change control and testing processes for modifications to databases.
Establish appropriate end-user database access control levels.
Develop routines for end-users to facilitate best practices database use.
Functions as a control point for all system administration duties of the CAD application
Supervises, maintains, and controls security access for the system and maintains associated documentation.
Maintains CAD system software and its associated database components in coordination with the RMS Administrator.
Interfaces with clients and In Tyler/New World support to track problems and document resolutions.
Maintains a test environment for all CAD changes, conducts tests on changes before implementation into production, and documents changes for change control.
Installs and upgrades new components of the CAD software as required.
Operates hardware specific to the CAD application so as to test and ensure integrity and durability.
Interfaces with the Local and Wide Area Network staff of IT to plan and coordinate network needs.
Cross trains with the RMS Administrator to assume those duties in times when staff in those positions are not available.
Functions as a control point for all system administration duties of the RMS application.
Supervises, maintains, and controls security access for the system and maintains associated documentation.
Maintains RMS system software and its associated database components in coordination with the Database Administrator and CAD Administrator.
Interfaces with clients and Tyler/New World support to track problems and document resolutions.
Maintains a test environment for all RMS changes, conducts tests on changes before implementation into production, and documents changes for change control.
Installs and upgrades new components of the RMS software as required.
Operates hardware specific to the I/Leads application so as to test and ensure integrity and durability.
Interfaces with the Local and Wide Area Network staff of IT to plan and coordinate network needs.
Cross trains with the CAD Administrator and Database Administrator to assume those duties in times when staff in those positions are not available.
Conducts system requirement analysis for new GIS applications and monitors application development using a system life cycle development methodology.
Monitors interdependent GIS map layers (map layers that more than one department depend on) for quality assurance (accuracy and timely maintenance).
Implements software and hardware standards to ensure that GIS related hardware and software is up-to-date and capable of meeting department needs.
Coordinates, plans and implements GIS system upgrades.
Ensures that GIS policies and standards are maintained.
Plans, reviews and recommends annual GIS budget.
Operates hardware and software related to GIS applications as necessary.
Maintains and administers the GIS database for the Tyler/New World Computer Aided Dispatch (CAD) and Tyler/New World Records Management System including the acquisition of data, development, modification, compliance and enhancement of the GIS system.
Acts as a liaison between GIS users with ACCPD and UGAPD, other ACC departments, planning entities, systems developers, and consultants in the development, testing, implementation and review of systems, both existing and proposed.
Assists in the training of users of the GIS system and Tyler/New World CAD and RMS map.
Maintains up to date knowledge of the Tyler/New World systems and recommends enhancements.
Writes and develops specifications for the GIS database and application systems.
Troubleshoots problems and is accountable for the day-to-day database and technical support.
Assists in the implementation of GIS database application on a PC based network.
Maintains an operational understanding of the source data for the Tyler/New World CAD and RMS map and the procedures for implementing map data into the map.
Adds new features or "layers" and other attributes to the map.
Conducts analysis on existing Tyler/New World GIS database systems and performs updates or modifications as required.
May provide recommendations for improvements to related policies, systems, processes and guidelines.
Performs other related work (including weather or extreme emergency duties) as required.
Performs other related duties as required.
Maintains and administers permitting and plans review software (Clariti built on Salesforce and/or associated systems preferred), including the acquisition of data, development, modification, compliance, and enhancement of this software.
Acts as a liaison between the Building Inspections Department and all other departments utilizing the software.
Assists in training users of the Permitting and Plans review software.
Provides recommendations and implementations for software improvements.
Provides technical support of the Permitting and Plans review software.