Senior Computer Programmer Analyst; Nc - Database Administration

CITY OF CINCINNATI – Senior Computer Programmer Analyst (CLEAR)

The County Law Enforcement Applied Regionally (CLEAR) section of the Enterprise Technology Solutions (ETS) division seeks a Senior Computer Programmer Analyst with strong database programming and database administration skills. The role assists in the analysis of city, county, and criminal justice agencies' data processing needs; assists in design, testing, and implementation of systems; performs database design, implementation, and maintenance; and administers new and existing databases.

Other related duties may be required.

• Perform professional, technical, and analytical duties in the operation of enterprise, client/server, and desktop computer systems and networks.
• Analyze data processing needs for city, county, and criminal justice agencies; assist in system design, testing, and implementation.
• Design, implement, and maintain databases; administer data and database security and integrity; modify existing applications as needed.
• Perform related duties as 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 providing effective customer service
• Database Administration
  • Database management systems
  • Database design
  • Database tools and data/file management tools
  • Data warehouse and multi-dimensions
  • Data recovery and database security methods
  • Physical control standards and procedures
  • Database software (Oracle, SQL, etc.)

• Operating Systems: installation methods, configurations, and maintenance
• Networking: analysis, LAN hardware, data communication, Internet/intranet architecture, security policies
• Programming: standard languages, program design and analysis, techniques, and utilities
• Web: UI design, information architecture, front-end coding (HTML, JavaScript)
• Business: systems analysis, business software packages
• GIS: desktop GIS software, web interfaces, data presentation, geo-data concepts and integration

• Install, configure, upgrade, and maintain hardware and software for LAN/WAN environments
• Perform hardware modifications and troubleshoot network hardware/software problems
• Read and prepare clear and concise reports and technical documents
• Work with minimal supervision and provide effective customer service
• Develop and implement cost-effective improvements for technical systems
• Analyze, design, program, test, debug, document, and maintain various systems and applications
• Develop data storage and archiving procedures

Illustrative duties include installing and maintaining servers and network equipment, troubleshooting applications and server connections, developing specifications, coding, testing, and documenting programs, creating data flow documents, evaluating backup/restoration procedures, drafting procurement requests, and ensuring IT security considerations in all tasks.

Required education and experience include one of the following:

• Associate's Degree from an accredited college or university with a major in computer science, information technology, computer programming, criminal justice, geography, or a related field, and one year of professional paid work experience performing work similar to the listed examples.
• 45 quarter credit hours from an accredited college or university (30 in computer science/IT/programming) and two years of professional paid work experience performing similar work. A certification program (e.g., Novell or Windows NT engineer) may substitute for one year of experience.

• Valid driver’s license for some positions
• Some positions may require criminal background investigation and fingerprinting
• May be required to work irregular hours and be on-call

Military education and experience may be substituted for college coursework on a case-by-case basis. Candidates may attach Joint Services Transcripts evaluated by ACE for consideration. Information can be found at the following resource:

https:// Programs/get-credit/credit military.html

Office environment with exposure to computer screens; travel to sites within the City/Hamilton County may be required. Duties require sitting/standing for extended periods and basic manual dexterity; ability to operate an assigned vehicle as required.

Probationary Period: Twelve Months.

Supervision Exercised: May supervise professional, technical, and clerical personnel.

HR Contact: (Use the "Apply for this Job" box below).