Application Developer

Client: Oklahoma Department of Agriculture, 2800 N. Lincoln Blvd., Oklahoma City, OK 73105

Duration: 9 months

Schedule: Fulltime - Monday thru Friday (8am to 5pm) - flex schedule allowed.

Description

The Oklahoma Department of Agriculture, Food, and Forestry’s Consumer Protection Services Division is looking for development support for our new Inspections application. The Inspections application will allow agency field inspectors to collect agricultural inspections data via online forms, save the data to the SQL database, and generate and store PDF documents. The Department’s existing inspections program is scheduled to be decommissioned in Spring of 2027, and the replacement system is being developed in-house. Essential to this effort is a contracted developer practiced with JavaScript and SQL whose experience level ranges from beginner to intermediate.

This position’s primary responsibilities consist of converting the approximately seventy existing fillable PDF inspection documents into new interactive HTML forms that will be used by department inspectors for data collection. The developer will use JavaScript to build the functionality for inspector inputs to be saved to the SQL database, and Jinja templates will be used to compile those inputs back into new PDF files. Secondary responsibilities include providing JavaScript development support as needed to help keep the current project on track.

Requirements

Beginner to Intermediate Experience. Should have staff who are experienced in the following: 

• JavaScript 

• SQL (T-SQL but any form of knowing SQL will be fine) 

• HTML 

• CSS

The following experience is a plus, but can be learned on the job: 

• Python 

• Docker 

• Jinja 

• Docker 

• Git/GitHub

Required Skills

• JavaScript

• SQL

• HTML

• CSS