COMPUTER PROGRAMMER/ANALYST (NON-COMPETITIVE)

City-of-Cincinnat; Cincinnati (OH); On-site; USD 65,000 - 90,000; Full time

Job summary

City-of-Cincinnat seeks a professional to support enterprise and desktop computer systems, assist in data processing needs analysis for city agencies, and help design, test, and implement new systems. Responsibilities include network design and database analysis along with documentation.

The role emphasizes collaboration, adherence to security practices, and ongoing learning of emerging technologies in data processing and GIS contexts.

Qualifications

• Knowledge of computer data processing principles.
• Design, installation, and maintenance of enterprise and desktop systems.
• Database management and data security methods.
• Programming languages such as Java, C, C++, Visual Basic.
• Ability to document and communicate technical information.
• Understanding of network architectures and protocols.

Responsibilities

• Operate and support enterprise, client/server, and desktop systems.
• Assist in analyzing data processing needs of city agencies.
• Assist in design, testing, and implementation of systems.
• Perform network design, maintenance, and data analysis tasks.
• Prepare concise reports and documentation.

Skills

Data processing

Network design

Programming languages

Database administration

Documentation

Team collaboration

Education

36 quarter credit hours in IT related fields

18 hours in geography/engineering/business/public administration/math etc.

Tools

Oracle

SQL

HTML/JavaScript

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

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