Programmer Analyst 3

Ampcus, Inc; Richmond (VA); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Ampcus Inc. is seeking a Programmer Analyst 3 in Richmond, VA (Hybrid) to support data modernization initiatives for vital statistics and vital records projects.

The role focuses on migrating legacy PL/SQL Web Toolkit modules to Oracle APEX while addressing security and HIPAA compliance requirements. The candidate will work on VVESTS–a mission-critical system interfacing with state and federal agencies, and contribute to securing and modernizing web applications using JavaScript/jQuery, CSS, and

Qualifications

• Oracle 11g/18c/19c database experience is required (5 years).
• Strong SQL and PL/SQL experience is required (5 years).
• JavaScript or jQuery experience is required (5 years).
• Oracle APEX experience is required (5 years).
• Oracle PL/SQL Web Toolkit experience is desired (2 years).
• RESTful and SOAP Web services desired (2 years).

Responsibilities

• Support data modernization of vital statistics and vital records systems.
• Migrate PL/SQL Web Toolkit modules to Oracle APEX.
• Address security and HIPAA compliance in modernization efforts.
• Collaborate with VVESTS modules and integration with state/federal agencies.

Skills

Oracle 11g/18c/19c database

SQL/PLSQL

Javascript or Jquery

Oracle APEX

Oracle PL/SQL Web Toolkit

RESTful and SOAP Webservices

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

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

• 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

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.