Under close supervision, performs a variety of professional, technical and analytical duties in the operation of enterprise, client/server and desktop computer systems and networks; assists in the analysis of city, county and criminal justice agencies' data processing needs; assists in the design, testing and implementation of systems; helps to perform network design and maintenance, data/database analysis/administration, and modifications to existing computer applications; performs related duties as required.

(Illustrative only. Any one position may not require all of the listed KSAs nor do the listed examples include all the KSAs which may be required.)

Listed categories are the same as Senior Computer Programmer Analyst, but performed with less than average difficulty and under close supervision.

Knowledge of: (one or more of the following categories may be required)

All Categories:
Principles of computer data processing.
Design, installation, and maintenance of enterprise, distributed, client server and desktop computer systems.
Principles and practices of computer network systems analysis and design.
Current trends and new technologies in data processing.
Desktop software packages and operating systems
Principles of effective documentation.
Principles of effective customer service.

Operating Systems:
Methods and practices of installation for upgrading of client servers, desktop computer hardware and software.
Computer systems configurations.
Operating system structures.

Networking:
Principles of computer network systems analysis and design.
Local area network hardware and transmission protocols.
Data communications concepts and principles.
Internet and intranet architecture.
Network security policies, techniques, and procedures.
Licensing Agreement enforcement.

Programming:
Standard programming languages.
Computer operating systems/hardware.
Program design and analysis.
Principles and techniques of programming.
Programming languages (Java, C, C++, Visual Basic, etc.) and utilities.

Database Administration:
Database management systems.
Database design.
Database tools.
Data/file management tools.
Database utilities.
Data warehouse and multi-dimensions.
File and data recovery.
Database security methods and techniques.
Physical control standards and procedures.
Database software (Oracle, SQL, etc.)

Web:
In-depth graphic design.
User interface design.
Advertising and marketing.
Information architecture.
Management of e-commerce.
Front-end web code such as HTML and JavaScript.

Business:
Business systems analysis.
Business software packages.

GIS:
Desktop GIS software for analysis, query, and visualization (e.g., ESRI's ArcView).
WEB-based GIS application interfaces and data presentation.
Desktop or Workstation GIS advanced software for data creation, geo processing, and conversion (e.g., ESRI's Arc Info).

Skill to: (All Categories)
Operate personal computers, mainframe terminals, or related hardware.
Troubleshoot hardware and software problems.
Prepare concise reports.

Ability to: (All Categories)
Read and understand technical publications, manuals, and documents.
Generate appropriate documentation related to software, networks, and system usage.
Work effectively in a team setting.
Establish priorities for work tasks.

Each applicant must have completed a total of 36 quarter credit hours from an accredited college or university of which 18 credit hours must in computer science, information technology, and/or computer programming and 18 quarter credit hours must be in one or more of the following areas: geography, engineering, business administration, public administration, chemistry, mathematics, or a related field.

OR

Each applicant must have completed 18 quarter credit hours from an accredited college or university in computer science, information technology, and/or computer programming. In addition, each applicant must have one year of professional, paid work experience performing work in computer support and/or troubleshooting.

OR

Each applicant must have completed 18 quarter credit hours from an accredited college or university in computer science, information technology, and/or computer programming and six months of professional, paid work experience performing work in computer support and/or troubleshooting. In addition, each applicant must have completed an extended certification program (i.e. Novell or Windows NT engineer, Microsoft MCSE or Oracle DBA). Completion of other certification programs not listed will be reviewed on a case-by-case basis.

OTHER REQUIREMENTS
Possession of, or ability to obtain, a valid Driver's License is required for some positions.
Some positions may require a criminal background investigation and fingerprinting due to the sensitive nature of the work.
May be required to work irregular hours and be on-call.

Environmental Conditions: Office environment, exposure to computer screens; travel to sites within the City/Hamilton County may be required.

Physical Conditions: Duties require maintaining physical condition necessary for sitting and standing for prolonged periods of time; general manual dexterity; must be able to operate assigned vehicle (as required)