Job Title: PR4 / Programmer 4
NFP Rate: $70.45
Will close to submissions: Wednesday 12/20/17 at 10:00am EST
Interviews: One onsite interview required. Tentatively scheduled for 1/4/18
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 a rewrite of the Amusement Ride Inspection and Licensing System.
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 rewrite and platform refresh of the Amusement Ride Inspection Licensing System (ARILS) will be the primary focus. The legacy application is coded in WinForms and connected to SQL Server 2008 R2 databases via an OLE connection. The corresponding SQL databases contain complex stored procedures, views, and functions which must be evaluated, modified and created. Programmer should have proficiency with SQL and interfaces (SQL Server Manager, SQL Studio Management). Amusement Ride employees manage regulatory, licensing and inspection functions via a complex compiled WinForms project. The agency is shifting the development platform from an older WinForms design and paper process to WinForms/WebForms C#. The rewrite of ARILS is the primary responsibility but the legacy MS Access application may also require maintenance and support during the engagement.
The programmer must fit in teamwork environment as well as follow direction. 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, unit testing, user support and training, and maintenance. Development will be performed in a test environment and promoted to production environment upon approval by senior developer or supervisor. Participation in a modified Agile work environment (i.e., SCRUM) will be necessary. Programmer must use established formats, review and understand existing code, controls, SQL stored procedures and views. 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. Programmer will participate in weekly developer working group 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 (WinForms, WebForms, Solution, Projects) Required 4
- T-SQL (Stored Procedures/Views) Required 4
- C# Required 4
- Object Oriented Programming Experience Nice to Have 2
- ADO.Net Required 3
- MS-SQL Server/Express Required 4
- Telerik (WinForms/WebForms/Reporting) Required 2
- MicroSoft Sync 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
