"Alerted.org

SENIOR COMPUTER PROGRAMMER ANALYST (Law Enforcement Software Application Developer)

Print (https://www.governmentjobs.com/careers/cincinnati/jobs/newprint/4952242)

Apply



SENIOR COMPUTER PROGRAMMER ANALYST (Law Enforcement Software Application Developer)

Salary

$79,504.27 - $106,847.10 Annually

Location

Ohio 45202, OH

Job Type

Full-time Classified

Job Number

25-01811 (NC)

Department

Enterprise Technology Solutions

Opening Date

05/23/2025

Closing Date

Continuous

+ Description

+ Benefits

+ Questions

General Statement of Duties

The City of Cincinnati's County Law Enforcement Regionally (CLEAR) section, of the Enterprise Technology Solutions (ETS) department is currently seeking to fill the position of Senior Computer Programmer Analyst ( software development assignment) 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.

Additionally, our aim is to recruit a candidate with strong web development experience and .Net programming skills.

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, 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.

Required Education and Experience

TRANSCRIPTS FROM AN ACCREDITED COLLEGE OR UNIVERSITY MUST BE ATTACHED TO THIS APPLICATION IN ORDER TO BE CONSIDERED

Each applicant must have completed anAssociate's Degreefrom an accredited college or university with amajor in computer science, information technology, criminal justice, or a related field. In addition, each applicant must have one year of professional paid work experienceperforming work related to that listed in the KSAs.

OR

Each applicant must have completed45-quarter credit hoursfrom 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 experienceperforming 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. Candidates must attach their Joint Services Transcripts evaluated by the American Council on Education (ACE) if they would like military course work to be considered as part of the application review. Please follow the link below for additional information.

https://www.dantes.doded.mil/EducationPrograms/get-credit/creditmilitary.html

Working and Physical Conditions

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

Probationary Period:

Twelve Months.

Supervision Exercised:

May exercise technical and functional supervision over professional, technical, and clerical personnel.

HR Contact: [email protected] ([email protected]) ov

The below information is solely intended as a summary of the benefits available and is subject to change. 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.

The City of Cincinnati offers its employees 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. A summary of these benefits for full-time employment is listed below. This is a general listing of benefits for all employees and is not intended to be a comprehensive listing for all bargaining units.

The City offers a variety of training programs, ranging from job-specific skills such as computer and equipment instruction, to helping supervisors improve their management techniques.

Equal Employment Opportunity

The City of Cincinnati is dedicated to providing equal employment without regard to race, gender, age, color, religion, disability status, marital status, sexual orientation or transgendered status, or ethnic, national or Appalachian origin, or on the basis of any other category protected under federal, state and local laws.

Holidays

The City of Cincinnati has 11 paid holidays annually that include:

New Year's Day

Martin Luther King Day

President's Day

Memorial Day

Juneteenth

Independence Day

Labor Day

Veterans' Day

Thanksgiving Day

Day after Thanksgiving

Christmas

Health Insurance

The City of Cincinnati 80/20 offers 3 medical plans to all full time City of Cincinnati employees and eligible dependents: the 80/20 PPO medical plan, the HDHP medical plan with an HSA contribution, and a Health Reimbursement Arrangement for those enrolled on another non-city eligible group plan.

Eligible dependents include:

Legal Spouse or Equal Partner

Child (natural child, adopted child, and/or child who the group has determined is covered under a "Qualified Medical Child Support Order")

Step-child

Child for whom the employee or employee's spouse/equal partner is a legal guardian

Basic Life Insurance

A $50,000 Basic Life Insurance policy is paid for by the City for certain eligible employees. Full time employees not eligible for the City-paid basic life insurance policy are generally provided a similar benefit through their union group.

Supplemental Life, Long Term Disability, Accident & Critical Illness Insurance

Most full time City employees are eligible to participate in a supplemental life insurance program, a long term disability plan, and accident and critical illness insurance programs at their own expense. Premiums are determined by age, amount of coverage, and various additional factors.

Flexible Benefits Plans

Healthcare Flex Spending Account

City employees can participate in the Healthcare Flex Spending Account that can be used to pay out-of-pocket medical, prescription, dental, and vision care expenses for employees and family members.

Dependent Care Flex Spending Account

City employees can participate in a Dependent Care Flex Spending Account that can be used to pay work-related dependent care expenses. Participants can set aside money each year through pre-tax payroll deductions to pay for these expenses.

Transportation Expense Reimbursement Account

City employees can participate in a Transportation Expense Reimbursement Account (TERA) that can be used to reimburse expenses related to traveling to and from work. Participants can set-up a pre-tax payroll deduction up to an IRS regulated amount.

Healthy Lifestyles Program

City employees can voluntarily participate in a wellness incentive program that encourages and rewards employees and their spouses/equal partners for making positive choices for better health. The City of Cincinnati will contribute up to $300/year to a Health Reimbursement Account for each the employee and their spouse/equal partner for meeting specified program goals. These dollars can be used to offset qualified out-of-pocket medical expenses.

Integrated Health Reimbursement Arrangement (HRA)

This is a voluntary program that serves as an alternative healthcare option to traditional medical plans. If you have alternate group health coverage available to you through a spouse, equal partner, another job, or a non-city retirement plan, you may be eligible for this plan which reimburses you for the difference in premiums between the plans and your covered out of pocket expenses on the other plan.

Retirement Plan

The City provides a defined benefit pension plan for part-time and full-timeemployees. New hires and re-hired employees are required to participate in the City of Cincinnati's Retirement System (CRS), regardless of previous participation in an Ohio State pension system or any another state or federal pension system. CRS is funded by employer and employee contributions, and investment returns from plan assets. CRS provides retirement and health care benefits subject to eligibility requirements. The following groups are excluded from participation in CRS: Mayor and Members of City Council; Sworn Police & Fire; Police Recruits; and Rehired Ohio Police & Fire Retirees.

Deferred Compensation

As an Ohio government employer, the City offers employees the ability to participate in a 457(b) tax-deferred retirement savings plan. The City makes an annual match to your 457(b) of up to $750, or as otherwise specified in applicable regulations and union contracts.

01

Which best describes your highest level of education completed?

+ High School Diploma or GED

+ Some College

+ Associates degree

+ Bachelors degree

+ Masters degree

+ Doctoral Degree

+ None of the above

02

Have you completed an Associate's Degree (or higher) from an accredited college or university with a major in computer science, information technology, criminal justice, or a related field?

+ Yes

+ No

03

Specifically, what degree(s) do you possess?

04

Have you completed at least 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?

+ Yes

+ No

05

Do you understand a TRANSCRIPT must be attached or your application will be rejected? Please ensure your transcript document is attached to this application.

+ I understand, and I have attached my transcript to this application

06

How many years of software development experience do you possess?

+ None

+ Some, less than 1

+ At least 1, less than 2

+ At least 2, less than 3

+ At least 3, less than 4

+ At least 4, less than 5

+ At least 5

07

This employee will perform a Mid-Senior level Software Developer role for the County Law Enforcement Applied Regionally (CLEAR) section of the Enterprise Technology Solutions (ETS) department. This employee coordinates assigned CLEAR projects; assists in the design, development, testing, and implementation of criminal justice information systems. The duties include but are not limited to N-Tier Web Development, Custom Application Development, Interface Development, Database Programming, Application Security and Customer Support. Do you understand and accept the roles and responsibilities for this position?

+ Yes, I understand and accept

08

Please indicate your areas of Programming experience. (Check all that apply)

+ C#

+ ASP.Net

+ HTML

+ CSS

+ JavaScript

+ Angular JS

+ AJAX

+ JQuery

+ MVC

+ Bootstrap

+ Webservices

+ REST API

+ XML, XSD, XSLT

+ T-SQL

+ DDL, DML for SQL

+ Complex Stored Procedures

+ Team Foundation

+ None of the above

09

I understand and agree that this position requires the following: 1) Ability to obtain and maintain certification by Ohio Law Enforcement Automated Data Systems (LEADS) and FBI NCIC, which requires fingerprinting and criminal background investigation. 2) Ability to work irregular hours and be on call. 3) Ability to act in compliance with the City's information security policy, contracts/license agreements, administrative regulations and related standards and procedures in the Human Resources Policies and Procedures. 4) Ability to work with coworkers, customers, and senior management to understand business issues and their environment. 5) Ability to obtain a valid driver's license.

+ Yes, I understand and agree.

Required Question

Employer

City of Cincinnati

Address

805 Central Avenue Suite 200

Cincinnati, Ohio, 45202

Phone

513-352-2400

Website

http://agency.governmentjobs.com/cincinnati/default.cfm