Application Developer

Socket.dev; Oklahoma; On-site; USD 60,000 - 90,000; Full time

Job summary

The Oklahoma Department of Agriculture, Food, and Forestry’s Consumer Protection Services Division seeks a development-focused contractor to modernize the inspections workflow. You will convert existing fillable PDFs into interactive HTML forms used for data collection by field inspectors, with data stored in SQL.

Responsibilities include implementing JavaScript to save inspector inputs to SQL, using Jinja to render inputs back into PDFs, and providing additional JS support to keep the project

Qualifications

• Beginner to intermediate experience in JavaScript, SQL, HTML, and CSS.
• Plus: Python, Docker, Jinja, Git/GitHub experience.

Responsibilities

• Convert ~70 existing fillable PDF inspection documents into interactive HTML forms for data collection.
• Use JavaScript to save inspector inputs to the SQL database and compile inputs back into PDFs with Jinja templates.
• Provide JavaScript development support to keep the project on track.

Skills

JavaScript

SQL

HTML

CSS

Tools

Docker

Jinja

Git/GitHub

Job description

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