Job Details

Senior Programmer Analyst

Division: Information Technology Services
Contact Name: Tammy Smoke
Contact Email:
Contact Phone: (740) 670-5150
Date Posted: 4/7/2014
Position Location: 20 S. 2nd Street, Newark, OH, 43056
Position Description:

Participates in all phases of the System Development Lifecycle (SDLC) to enforce efficiency, consistency, interoperability, and standards throughout all development-related projects.

Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect environment database (how data is stored in terms of physical characteristics such as location, amount of space, and access method), using various Oracle and SQL Server back-end database applications through standardized ADO and ADO.NET connections.

Reviews project request identifying and articulating business needs and processes; estimates time and cost required to complete project; determines if project requires creating a series of new applications or modules or making modifications to existing programs that access data stored in databases.

Prepares project notebook including a workflow chart and Entity-Relationship Diagram to document the business processes for automation and rules to be enforced. Transforms these functional and data requirements into an intuitive user interface.

Converts project specifications into instructional programming code with additional emphasis placed on application security, system performance, and data integrity. Applies all of these variables to the testing of the code, modules, and application within current environment: Visual Studio.NET, Visual Basic 6, Visual Basic for Applications (VBA), MS Access HTML, ASP, JavaScript and CSS.

Reviews and analyzes design of database environment prior to creating objects, modifying objects, updating database records, or modifying existing applications or modules.

Revises agency definition of data as defined in data dictionary (information about data, including name, description, source of data item, and keywords for categorizing and searching for data item descriptions); determines and enters changes to data dictionary descriptions, including type, structure, and intended use of data within system.

Develops logical data models describing data elements and how they are used; writes description of how user accesses data.

Applies derivatives of data mapping techniques into data conversion strategies. Implements these strategies using 2nd and 3rd generation programming languages to massage and populate data.

Evaluates the effectiveness of existing development and database platforms and makes recommendations on the migration from current platforms and standards.

Maintains database security policy including location, space requirements, logins, access methods, stored procedures and audit trails to protect company data resources against unauthorized access and accidental destruction.

Meets all job safety requirements and all applicable OSHA safety standards that pertain to the essential functions of the position and all agency safety procedures.

Brief Description:

Under general supervision from the department head may lead lower level programmer/analysts on Information Technology Services projects involving the design, development, implementation, and maintenance of business applications for streamlining, automating, and integrating the operations of all county agencies.

Job Prerequisites:

Bachelor’s degree from four-year college or university; and three (3) to five (5) years related experience and/or training; or equivalent combination of education and experience. experience required. Additional Qualifications (Agency/Dept. Qualifications): Significant knowledge of Crystal Reporting preferred.

Application Procedure:

Submit completed application, resume and cover letter to the Licking County Human Resources Department, 20 South Second Street, 3rd Floor, Newark, Ohio 43055. Applications can be obtained in person in the Human Resources Department between 8:00 a.m. and 4:30 p.m. daily or printed from the web site at



Job Type: Full Time
Pay Type: Salary