SENIOR COMPUTER PROGRAMMER ANALYST (LAW ENFORCEMENT SOFTWARE APPLICATION DEVELOPER)

The City of Cincinnati's County Law Enforcement Regionally (CLEAR) section, of the Enterprise Technology Solutions (ETS) division is currently seeking to fill the position of Senior Computer Programmer Analyst with a talented and motivated individual with strong Software Development and Database Programming skills. This employee coordinates assigned CLEAR projects; assists in the design, development, testing, and implementation of criminal justice information systems; provides highly responsible and complex staff assistance to senior management and client agencies. Assists in the analysis of city, county, and criminal justice agencies' data processing needs; performs database design, implementation and maintenance of databases; administration of new and existing databases. Performs other CLEAR duties as required.Knowledge of: 
C#, VB.Net, ASP.Net.
HTML, CSS, JavaScript, JQuery, AJAX.
Web API, WPF, WCF, SignalR
Webforms, Winforms and Webservices.
Mobile application frameworks and wireless infrastructure.
XML, XSLT, XML schemas.
T-SQL, PL/SQL, Microsoft Power shell.
SQL Server and other databases such as Oracle.
SQL Server security.
SQL Server backup and recovery methods.
Active Directory and SQL Server authentication.
VMware including VCenter.
Data modeling techniques.
Website and Active Directory administration.
Current trends in data processing and database technology.
Remote device management and tools.
Source code version control (Source Safe, Team Foundation, etc.). 

Skills to: 
Design and develop highly reliable applications.
Develop applications using a combination of server-side code, client-side scripts and services.
Develop a responsive, rich and interactive user interface.
Apply best practices and make appropriate trade-offs based on business requirements when designing an application.
Diagnose technical problems, recommend solutions, and provide excellent customer support.
Create and maintain SQL Server and other databases such as Oracle.
Design, code and maintain DDL for SQL Server to create tables, indexes, views, triggers, user defined functions and stored procedures.
Create and maintain scheduled jobs in SQL Server.
Develop and maintain backup and recovery plans for SQL Server and other databases.
Create ad-hoc management reports using a combination of T-SQL and Excel.
Create XML schemas and write XSLT style sheets to transform data.
Analyze and improve database query efficiency.
Analyze and tune database for optimum efficiency.
Troubleshoot, diagnose and resolve database and system performance issues. 

Ability to:
Adapt to new processes and technologies and become proficient in their use.
Work with minimal supervision.
Provide guidance, support and technical supervision to other members of the CLEAR staff in all issues pertaining to applications and databases.
Assist personnel from law enforcement agencies in troubleshooting problems with applications.
Maintain positive employee and customer relations.
Communicate clearly and concisely, both orally and in writing.
Work effectively with diverse customer and colleague groups.
Maintain and support highly critical systems on a 24x7x365 basis.
Provide 24x7 level 1 technical support on a rotating basis.Each applicant must have completed an Associate's Degree from an accredited college or university with a major in computer science, information technology, criminal justice, or a related field. In addition, each applicant must have one year of professional paid work experience performing work related to that listed in the KSAs.
OR
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 or a related field. In addition, each applicant must have two years of professional paid work experience performing work related to that listed in the KSAs.

OTHER REQUIREMENTS
Must have a valid Driver's License 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.
Ability to obtain and maintain certification by Ohio Law Enforcement Automated Data Systems (LEADS) and FBI NCIC, which requires fingerprinting and criminal background investigation.
 
MILITARY EDUCATION & EXPERIENCE EVALUATION
Military education and experience may be substituted for college level course work at the lower and upper division baccalaureate and graduate levels and apprenticeship training at the vocational certificate level on a case by case basis based on the American Council on Education (ACE) Military Guide recommendations.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).