53739: Columbus, OH – IT – AGR – Programmer 4/PR4

Job Title: Programmer 4

Will close to new submissions: Friday, May 25th at 10:00am EST
Interviews: Onsite only

This position is expected to last through 2018, but extensions past 6/30/18 are not guaranteed.

Short Description:

The Programmer is responsible for analysis, design, coding, component and assembly testing. The focus will be on participating as a member of a development team charged with development of the Plant Health Inspection Forms System (PHIFS).

Agency Overview:

The Ohio Department of Agriculture provides leadership for Ohio’s No. 1 industry – food and agriculture. The department administers numerous regulatory, food safety and consumer protection programs for the benefit of all Ohioans and helps build marketing opportunities for Ohio farmers and food processors. Department staff members inspect meat, poultry, food and dairy processing facilities, in addition to large livestock and other farms. The Ohio Department of Agriculture also houses a food, animal, and plant safety laboratory network that hosts a flurry of scientific activity, including analyzing everyday food and milk products and testing for deadly diseases like anthrax, West Nile, and Avian Influenza. The agency web site is located at www.agri.ohio.gov.

Project:

The development of PHIFS will be the primary focus. The legacy system is composed of MS Excel Workbooks for each inspection type form.  The data tier will be developed and component tested in a SQL database environment containing tables, complex stored procedures and views.  The Programmer should have proficiency with SQL and development tool interfaces (SQL Server Manager, SQL Studio Enterprise Manager). Plant Health employees manage regulatory inspection functions via MS Excel workbooks. The agency is shifting the development platform from an MS Excel Workbooks design to Win-Forms/Web-Forms utilizing C# language as the code behind while implementing a 3-Tier methodology. The rewrite of the Plant Health Inspection Forms System (PHIFS) is the primary responsibility.

Position Description:

The programmer must fit in teamwork environment as well as follow direction.  The Programmer may be responsible for all phases of the Software Development Life Cycle (SDLC); gather project business requirements, analysis of hardware/software requirements, design forms and reports, database modifications, code review, component testing, user support and training, and maintenance.  Development will be performed in a test environment and promoted to production environment upon approval by a senior developer or supervisor.  Participation in a modified Agile work environment (i.e., SCRUM) will be necessary. The programmer must use established formats, review and understand existing code, controls, SQL stored procedures, views and related tables.   The programmer must adhere to agency coding standards, procedures, and complete documentation such as impact analysis and change control. Use of third party tools is prohibited without prior approval by the project programmer or supervisor.  The Programmer will participate in weekly developer workgroup meetings to discuss progress, obstacles, timelines, and goals.

Working hours will be 5 days a week; 8 hours per day - starting no earlier than 8:00AM and ending no later than 5:00PM. State holidays will be observed.

Skill Set:

Visual Studio 2017 (Win-Forms, Web-Forms, Solution/Projects)   Required    4

T-SQL (Stored Procedures/Views)                                                              Required 4

C#              Required        4

Object Oriented Programming Experience                                             Desired     2

ADO.Net                                                                                                          Required   3

MS-SQL Server/Express                                                                           Required      4

Telerik (WinForms/WebForms/Reporting)                                             Required   2

MicroSoft Sync/SQL Replication                                                             Required       3

4 Year Degree or Equivalent                                                                     Desired          4

MS-SQL Server Tools                                                                                 Required         4

Boot Strap                                                                                                      Required        2

JQuery.js                                                                                                        Required         2

Popper.js                                                                                                        Nice to Have   1

Identity                                                                                                           Desired            1

3-Tier Development                                                                                   Required           2

 

 

Comments are closed.