SENIOR COMPUTER PROGRAMMER ANALYST (NC) - DATABASE ADMINISTRATION

About the role

The County Law Enforcement Applied Regionally (CLEAR) section of the Enterprise Technology Solutions (ETS) division is currently seeking to fill the position of Senior Computer Programmer Analyst. This employee assists in the analysis of city, county, and criminal justice agencies' data processing needs; assists in the design, testing, and implementation of systems; performs database design, implementation, and maintenance of databases; administration of new and existing databases. Performs other related duties as required.

Responsibilities

• Assists in the analysis of city, county, and criminal justice agencies' data processing needs;
• Assists in the design, testing, and implementation of systems;
• Performs database design, implementation, and maintenance of databases;
• Administers new and existing databases;
• Installs, configures, upgrades and maintains hardware and software, including that related to local and wide area networks;
• Troubleshoots any application or server connections;
• Identifies the need for hardware and software upgrades and perform upgrade;
• Develops specifications, codes, tests and documents application programs;
• Develops specifications, codes, and tests interfaces and conversion programs or procedures;
• Creates and maintains medium project work plans;
• Creates data flow documents which detail systems or business problems;
• Evaluates and tests options for backup, restoration, and recovery procedures;
• Evaluates and specifies software requirements;
• Drafts requests for proposals to accomplish design objectives;
• Places orders with vendors;
• Applies a general understanding of protocols, topology, hardware and software, and network design;
• Applies network hardware and software troubleshooting skills;
• Provides second level network problem escalation resolution;
• Develops and administers end-user training programs;
• Affirms that appropriate IT security is considered in all tasks;
• Acts in compliance with the City of Cincinnati's Information Security Policy, Administrative Regulations, and related standards and procedures in the City's Human Resources Policies and Procedures.

Requirements

Each applicant must have completed an 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. In addition, each applicant must have one year of professional paid work experience performing work similar to that listed under "Examples of Work Performed."

Qualifications

Each applicant must have completed 45-quarter credit hours from an accredited college or university with 30 of the 45 credit hours being in computer science, information technology, and/or computer programming. In addition, each applicant must have two years of professional paid work experience performing work similar to that listed under "Examples of Work Performed."

Skills

• Knowledge Of (One or more of the following categories may be required): 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. 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.).

Benefits

Not all benefits listed are available for every position. Benefits can vary depending on applicable labor agreements and/or salary plan. For specific questions, contact the HR Contact indicated on the Job Posting.

Pay

Competitive salaries and a comprehensive benefit package designed to actively attract and retain quality employees' to add additional value to the City of Cincinnati's workforce.

Schedule

May be required to work irregular hours and be on-call.