COMPUTER PROGRAMMER ANALYST (POLICE-ITMS)

City of Cincinnati; West Virginia; On-site; USD 70,000 - 95,000; Full time

Job summary

City of Cincinnati seeks a professional to operate and support enterprise, client/server and desktop systems. You will analyze data processing needs for city agencies, assist in design, testing and implementation, and help maintain networks and databases. Strong knowledge of programming languages and web UI is required.

The role emphasizes collaboration, documentation, and customer service under supervision, with diverse duties across IT operations.

Qualifications

• Total of 36 quarter credit hours with 18 in CS/IT/Programming and 18 in geography/engineering/business/public admin/math or related field.
• Alternatively 18 CS/IT/Programming plus one year of professional paid work in computer support/troubleshooting.
• Six months plus extended certification (Novell/Windows NT/MCSE/Oracle DBA) acceptable.

Responsibilities

• Operate enterprise, client/server and desktop computer systems and networks.
• Assist analysis of city, county and criminal justice data processing needs.
• Assist design, testing and implementation of systems and perform network design/maintenance and data administration.

Skills

Enterprise systems

Network design

Database administration

Programming languages

Web design/UI

Education

36 quarter credit hours in CS/IT/Programming

Additional certification programs (e.g., MCSE, Oracle DBA)

Tools

Oracle

SQL

Java

C/C++

Job description

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

All Categories

• Principles of computer data processing.
• Design, installation, and maintenance of enterprise, distributed, client server and desktopcomputer 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 computerhardware 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, andconversion (e.g., ESRI's Arc Info).

Skill to

• Operate personal computers, mainframe terminals, or related hardware.
• Troubleshoot hardware and software problems.
• Prepare concise reports.

Ability to

• 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)