SENIOR COMPUTER PROGRAMMER ANALYST (NC) - DATABASE ADMINISTRATION

City of CIncinnati

Cincinnati, OH

JOB DETAILS
SALARY
$83,479.48–$112,189.45 Per Year
SKILLS
Advertising, Analysis Skills, Background Investigation, Business Solutions, C Programming Language, C++ Programming Language, Child Support, Computer Hardware, Computer Maintenance, Computer Networks, Computer Programming, Computer Science, Computer Security, Computer Servers, Computer Services, Computer Systems, Criminal Justice, Customer Support/Service, Data Analysis, Data Description Language (DDL), Data Management, Data Modeling, Data Processing, Data Recovery, Data Warehousing, Database Administration, Database Analysis, Database Backup, Database Design, Database Management Software/Systems (DBMS), Database Programming, Database Recovery, Database Technology, Debugging Skills, Desktop Hardware, Desktop PC, Disaster Recovery, Documentation, Driver's License, Educational Evaluation, Environmental Issues, Equipment Maintenance/Repair, Federal Bureau of Investigation (FBI), File Management, Financial Systems, Flexible Spending Accounts, GPS (Global Positioning System), Geographic Information Systems (GIS), Geography, Graphic Design, HTML (HyperText Markup Language), Hardware Configuration Management, Hardware Installation, Hardware Upgrades, Health Insurance, Health Plan, Healthcare, Healthcare Reimbursement, High School Diploma, Higher Education, Human Resources, Information Architecture, Information Technology & Information Systems, Information/Data Security (InfoSec), Intranet, Java, JavaScript, Law Enforcement, License Agreements, Licensing, Licensing Compliance, Local Area Network (LAN), Manual Dexterity, Marketing, Medical Office Administration, Microsoft Active Directory, Microsoft Office, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Visual Basic, Microsoft Windows NT, Military, Network Administration/Management, Network Configuration Management, Network Design, Network Performance/Analysis, Network Protocols, Network Security, Network Software, Network System Hardware, Network Systems, Network Testing, On Call, Operating Systems, Oracle Applications, Oracle Database, Payroll Tax, Performance Tuning/Optimization, Preferred Provider Organization (PPO), Prescription Drugs, Problem Solving Skills, Programming Languages, Programming Methodologies, Project Planning, Proposal Writing, Purchasing/Procurement, Regulations, Request for Proposals (RFP), Requirements Management, SQL (Structured Query Language), Security Policy, Software Administration, Software Configuration Management, Software Design, Software Testing, Software Upgrades, Spatial Data, Stored Procedures, Surveying, System Integration (SI), Systems Administration/Management, Systems Analysis, Systems Maintenance, Team Foundation Server (TFS), Technical Leadership, Technical Training, Technical Writing, Test Design, Test Equipment, Testing, Topology, Training Program, Transmission Protocols, User Interface Design, User Interface/Experience (UI/UX), Vocational Training, Wide Area Network (WAN), Windows PowerShell, XML (EXtensible Markup Language), XQuery, XSD (XML Schema Definition), XSLT (Extensible Stylesheet Language Translation), eCommerce
LOCATION
Cincinnati, OH
POSTED
30+ days ago

SENIOR COMPUTER PROGRAMMER ANALYST (NC) - DATABASE ADMINISTRATION

Salary: $83,479.48 - $112,189.45 Annually Location: Ohio 45202, OH Job Type: Full-time Classified Job Number: 26-02706 Department: Enterprise Technology Solutions Opening Date: 03/25/2026 Closing Date: Continuous

Description

BenefitsQuestions

General Statement of Duties 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 with a talented and motivated individual with strong Database Programming and Database Administration skills.

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.

Employee performs a variety of professional, technical, and analytical duties in the operation of enterprise, client/server, and desktop computer systems and networks. 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 network design, implementation and maintenance, data/database analysis/administration, and modifications to existing computer applications. Performs related duties as required.

Minimum Qualifications (KSAs)(Illustrative only. Any one position may not require all of the listed KSAs nor do the listed examples include all the KSAs which may be required.)

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

------------------------------------------------

For informational purposes, other assignments that utilize the Senior Computer Programmer/Analyst classification include:

Operating Systems:

  • Methods and practices of installation for upgrading of client servers and desktop computer, hardware and software.
  • Computer system configurations.
  • Operating system structures.

Networking:

  • Principles of computer network systems analysis and design.
  • Local area network hardware and transmission protocols.
  • Data communication concepts and principles.
  • Internet and intranet architecture.
  • Network security policies, techniques, and procedures.
  • Network configuration, maintenance, and diagnostic procedures and techniques.
  • Licensing Agreement enforcement.

Programming:

  • Standard programming languages.
  • Computer operating systems/hardware.
  • Program design and analysis.
  • Principles and techniques of programming.
  • Programming languages (Java, C, C++, Visual Basic, etc.) and utilities.

Web:

  • In-depth graphic design.
  • User interface design.
  • Advertising and marketing.
  • Information architecture.
  • Management of e-commerce.
  • Front-end web code such as HTML and JavaScript.

Business:

  • Business systems analysis.
  • Business software packages.

GIS:

  • Desktop GIS software for analysis, query, and visualization (e.g., ESRIs ArcView).
  • WEB-based GIS application interfaces and data presentation.
  • Desktop or Workstation GIS advanced software for data creation, geo processing, and conversion (e.g., ESRIs Arc Info).
  • Geo-locational and Geo-relational dataset concepts and database structures.
  • Engineering/surveying principles and practices as related to GIS and GPS (global positioning systems) applications.
  • Interface and integration of GIS database systems with other public enterprise systems such as permitting, licensing, and financial systems.

Skill to:(All Categories)

  • Install, configure, upgrade and maintain hardware and software, including that related to local and wide area networks.
  • Perform hardware modifications such as chip replacement and board swaps.
  • Troubleshoot and resolve network hardware and software problems.
  • Use and maintain networking test equipment.

Ability to:(All Categories)

  • Read and prepare clear and concise reports and technical documents.
  • Work with minimal supervision.
  • Provide effective customer service.
  • Develop and recommend cost effective improvements for technical systems.
  • Implement systems based on design specifications and instructions.
  • Evaluate and recommend purchase of computer equipment, services and supplies.
  • Analyze, design, program, test, debug, document and maintain various systems and applications.
  • Develop procedures and means of storage for archiving data.

Examples of Work Performed(Illustrative only. Any one position within this classification may not include all of the duties listed nor do the listed examples include all of the tasks which may be performed.)

  • Performs all essential functions of a Computer Programmer Analyst.
  • Installs and maintains servers and network equipment.
  • Troubleshoots any application or server connections.
  • Installs, configures, and troubleshoots office network software and operating systems.
  • Identifies the need for hardware and software upgrades and perform upgrade.
  • Under minimal supervision, develops specifications, codes, tests and documents application programs.
  • Under minimal supervision, 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.
  • Identifies software requirements.
  • Drafts requests for proposals to accomplish design objectives.
  • Evaluates and specifies hardware and software configuration and places orders with vendors.
  • Applies a general understanding of protocols, topology, hardware and software, and network design.
  • Evaluates and specifies networking equipment and application.
  • Applies network hardware and software troubleshooting skills.
  • Provides second level network problem escalation resolution.
  • Develops and administers end-user training programs.
  • Assures that appropriate IT security is considered in all tasks.
  • Acts in compliance with the City of Cincinnatis Information Security Policy, Administrative Regulations, and related standards and procedures in the Citys Human Resources Policies and Procedures.

Required Education and ExperiencePLEASE REVIEW THIS SECTION CAREFULLY. IF YOU AIM TO QUALIFY VIA CREDIT HOURS, PLEASE ATTACH A COPY OF YOUR TRANSCRIPTS FROM AN ACCREDITED COLLEGE OR UNIVERSITY. OTHERWISE YOU CAN ATTACH COPY OF YOUR DIPLOMA OR TRANSCRIPTS.

Each applicant must have completed an Associates 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."

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

A certification program, such as a Novell or Windows NT engineer, may substitute for one year paid work experience (completion of other certification programs not listed will be reviewed on a case-by-case basis).

OTHER REQUIREMENTS

  • Must have a valid Drivers 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.

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: gustavo.rodriguez@cincinnati-oh.gov

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 Cincinnatis 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 Years Day
  • Martin Luther King Day
  • Presidents 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 employees 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-time employees. New hires and re-hired employees are required to participate in the City of Cincinnatis 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
  • 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.

***

Application Questions

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 Associates Degree (or higher) from an accredited college or university with a major in computer science, information technology, computer programming, criminal justice, geography or a related field? Your educational degree needs to be discernible within your application.

  • Yes
  • No

03 Have you completed at least 45-quarter credit hours from an accredited college or university with at least 30 of the 45 credit hours being in computer science, information technology, and/or computer programming? (If you aim to meet educational qualifications via credit hours, your transcript must be attached to this application)

  • Yes
  • No

04 Specifically, what field is your degree in? If no degree, type "N/A."

05 Do you understand that your application will be rejected if transcripts/diploma and résumé are not attached to this application? (Transcripts are required if you aim to meet the educational qualifications via credit hours. Otherwise transcripts OR diploma may be uploaded). Transcripts and/or diploma must be from a US-accredited institution. Applicants with international educational credentials must attach certification from a third-party educational credential evaluator.

  • Yes, I understand.

06 How many years of professional paid work experience do you possess performing work similar to that listed under "Examples of Work Performed?"

  • None
  • Some, less than 1
  • At least 1, less than 2
  • At least 2, less than 3
  • At least 3

07 This employee will perform a Database Administrator role for the County Law Enforcement Applied Regionally (CLEAR) section of the Enterprise Technology Solutions (ETS) division. The duties include but are not limited to Database Administration, Database Programming, Database Design, Implementation and testing of new databases, Maintain existing databases, and Database Security. Do you understand and accept the roles and responsibilities of this position?

  • Yes, I understand and accept

08 How many years of Database experience do you have?

  • At least 5
  • At least 4, less than 5
  • At least 3, less than 4
  • At least 2, less than 3
  • At least 1, less than 2
  • Some, less than 1
  • No experience

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

  • SQL Server
  • T-SQL
  • DDL, DML for SQL
  • Complex Stored Procedures
  • Data modeling techniques
  • Database backup and recovery methods
  • Database performance tuning and optimization
  • Disaster Recovery plans
  • Database Log Shipping
  • None of the above

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

  • XML
  • XSD
  • XSLT
  • XQuery
  • SQL to XML
  • None of the above

11 Which of the following do you have professional experience in? Select all that apply.

  • Active Directory
  • Power shell
  • MS Office Suite
  • Team Foundation Server
  • SQL Server Management Studio
  • Critical Database Support (24x7x365 basis)
  • None of the above

12 Please list any relevant professional certifications you possess. If none, type "N/A."

13 I understand and agree that this position requires the following abilities: 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 Citys 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 drivers 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

About the Company

C

City of CIncinnati