Job Description :
Position:Microsoft Programmer - IN PERSON Mandatory
Location:OH
Duration:6+ Months
Interviews: Onsite only.
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 .
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.
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