Job Title: Programmer Analyst 3

Location(s): Richmond, VA
(Hybrid)

Short Description:
Works as part of our client's Office of Information Management (OIM) team to plan, coordinate, develop, and implement data modernization initiatives for vital statistics and vital records projects.

Complete Description:
Our client's Vital Events and Screening Tracking System (VVESTS) is currently a PL/SQL Web Toolkit application running on the mod_plsql gateway. This technology is outdated. All VVESTS modules capture and process highly sensitive Personally Identifiable Information (PII) and Protected Health Information (PHI), making web application security a top priority. The modernization effort requires the use of the latest web technologies, JavaScript/jQuery frameworks, templates, and CSS standards to address security vulnerabilities and ensure strict compliance with HIPAA regulations.

VVESTS is a mission-critical system that supports applications such as the Birth Registry, Death Registry (EDRS), and Screening Registry. The system integrates with multiple state agencies as well as several federal agencies and exchanges data with the state's Immunization Information System.

The project involves migrating all PL/SQL Web Toolkit modules and pages to Oracle Application Express (APEX), Oracle's low-code development platform for building secure, scalable enterprise applications.

The primary focus of this role will be supporting the data modernization of vital statistics and vital records systems.

Skills:

Skill Required / Desired Amount of Experience Expertise Rating Move Oracle 11g/18c/19c database Required 5 Years Strong sql and pl/sql experience Required 5 Years Javascript OR Jquery Required 5 Years Oracle APEX Required 5 Years Oracle PL/SQL web toolkit Highly desired 2 Years RESTful and SOAP Webservices Desired 2 Years