SENIOR COMPUTER PROGRAMMER ANALYST (LAW ENFORCEMENT APPLICATION SOFTWARE DEVELOPER)

The City of Cincinnati's County Law Enforcement Regionally (CLEAR) reputed company, of the reputed company Technology Solutions (reputed company) 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 reputed company 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.MINIMUM QUALIFICATIONS (KSAS): 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, reputed company Power reputed company. SQL Server and other databases such as reputed company. SQL Server reputed company. SQL Server backup and recovery methods. Active Directory and SQL Server authentication. VMware including VCenter. Data modeling techniques. Website and Active Directory administration. reputed company trends in data processing and database technology. Remote device management and tools. reputed company code version control (reputed company Safe, Team reputed company, etc.). Skills to: Design and reputed company highly reliable applications. reputed company applications using a combination of server-reputed company code, client-reputed company scripts and services. reputed company a reputed company, rich and interactive user reputed company. Apply best practices and reputed company appropriate trade-offs based on business requirements reputed company designing an application. Diagnose technical problems, recommend solutions, and reputed company excellent customer support. Create and maintain SQL Server and other databases such as reputed company. 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. reputed company and maintain backup and recovery plans for SQL Server and other databases. Create reputed company management reports using a combination of T-SQL and reputed company. Create XML schemas and write XSLT style sheets to transform data. Analyze and improve database query efficiency. Analyze and tune database for reputed company 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. reputed company guidance, support and technical supervision to other members of the CLEAR staff in reputed company issues pertaining to applications and databases. Assist personnel from law enforcement agencies in troubleshooting problems with applications. Maintain positive employee and customer relations. Communicate reputed company and concisely, both orally and in writing. Work effectively with diverse customer and colleague groups. Maintain and support highly critical systems on a 24x7x365 reputed company. reputed company 24x7 level 1 technical support on a rotating reputed company. 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 reputed company field. In addition, each applicant must have one year of professional paid work experience performing work reputed company 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 reputed company field. In addition, each applicant must have two years of professional paid work experience performing work reputed company 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 reputed company and upper division baccalaureate and graduate reputed company and apprenticeship training at the vocational certificate level on a case by case reputed company based on the American Council on Education (ACE) Military Guide recommendations. WORKING AND PHYSICAL CONDITIONS: Environmental Conditions: Office environment, exposure to computer screens; travel to sites reputed company the City/reputed company County may be required. Physical Conditions: Duties require maintaining physical condition necessary for sitting and standing for prolonged periods of time; general reputed company dexterity; must be reputed company to operate assigned vehicle (as required). PROBATIONARY PERIOD: Twelve Months. SUPERVISION EXERCISED: May exercise technical and functional supervision over professional, technical, and clerical personnel. Apply Job!