Application Developer

About the role

The Oklahoma Department of Agriculture, Food, and Forestry’s Consumer Protection Services Division is seeking development support for a new Inspections application. The application will enable field inspectors to collect agricultural inspection data via online forms, store the data in a SQL database, and generate and store PDF documents. The existing inspections program will be decommissioned in Spring 2027, and the replacement system is being built in‑house. The contractor will work with JavaScript and SQL at a beginner‑to‑intermediate level.

Responsibilities

• Convert approximately seventy existing fillable PDF inspection documents into new interactive HTML forms for data collection.
• Use JavaScript to build functionality that saves inspector inputs to the SQL database.
• Utilize Jinja templates to compile saved inputs back into new PDF files.
• Provide additional JavaScript development support as needed to keep the project on track.

Requirements

• Beginner to intermediate experience.
• Staff experienced in JavaScript, SQL (T‑SQL or any SQL dialect), HTML, and CSS.
• Additional experience that is a plus (can be learned on the job): Python, Docker, Jinja, Git/GitHub.

Required Skills

• JavaScript
• SQL
• HTML
• CSS

Schedule

Full‑time, Monday through Friday (8 am to 5 pm) with a flexible schedule allowed. Contract duration: 9 months.

Location

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