Job Classification: PR4 – Programmer 4
Will Close to Submissions on: Monday 10/2/17 at 10:00 am
(Repost of 48724. Candidate not selected due to lack of Winforms/Telerik experience. The ideal candidate will have hands-on experience with coding - not leading a team that does the coding.)
Contract Length: 640 Hours with possible extensions
Work Hours 40 Hours a week. 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
Interview Process: All interviews must be on-site and in person. Please do not submit candidates that cannot interview in-person.
Location Ohio Department of Agriculture- 8995 E Main St Reynoldsburg Ohio
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.
Requirement 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 Food Safety Inspection Licensing System (FILS).
Project:
The rewrite and platform refresh of the Food Safety Inspection Licensing System (FILS) will be the primary focus. The legacy food safety applications are coded in MS Access 2007 connected to SQL Server 2008 R2 databases via an OLE connection (.adp). The corresponding SQL databases contain complex stored procedures, views, triggers and functions which must be evaluated, modified and created. Programmer should have proficiency with SQL and interfaces (SQL Server Manager, SQL Studio Management). Food Safety employees manage regulatory, licensing and inspection functions via two complex compiled MS Access project (.ade). The agency has shifted the development platform from MS Access to C#. The rewrite of FILS is the primary responsibility but the legacy MS Access applications 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.
Interview:
During the interview process with the Ohio Department of Agriculture staff, the resource consultant must demonstrate competence/experience in their specific area(s) of project assignment. The resource’s experience must also be documented for review and verification. Offered resources not showing technical or functional competence/experience will be sufficient reason to reject the Offeror’s proposal. It is the responsibility of the Offeror to pre-screen their candidates to ensure compliance.
1. Strong communication/ leadership skills.
2. Strong influence, collaboration and negotiation experience.
3. Ability to collaborate with supporting resources across business and/or functional lines.
4. Have excellent oral and written skills/possess strong meeting and work session facilitation skills.
5. Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines.
6. Have strong understanding of prioritization stemming from the elicitation of system and/or user requirements.
7. Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills.
8. Must be knowledgeable in the English language/speak clearly and understandably use the English language.
Mandatory Requirements/Time :
. Telerik (WinForms/Reporting) 2 Years of Experience Required
. MS Access /VBA - Visual Basic for Applications 3 Years of Experience
. Visual Studio 2010(Window Forms, Solution, Projects) 4 Years of Experience
. T-SQL (Stored Procedures/Views) 4 Years of Experience
. C# 4 Years of Experience
. ADO.Net 3 Years of Experience
. MS-SQL Server/Express 4 Years of Experience
. MicroSoft Sync 1 Years of Experience
. MS-SQL Server Tools 4 Years of Experience
Desired/Nice to Have:
. Object Oriented Programming Experience 2 Years of Experience
. Crystal Reports 2 Years of Experience
. 4 Year Degree or Equivalent
