Application Development

Title: Application Development

Location: Oklahoma City OK (Onsite)

Duration: 9 Months

Description

The Oklahoma Department of Agriculture Food and Forestrys 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 Departments 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 positions 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