Programmer Analyst 3

The Virginia Department of Health (VDH), Office of Information Management (OIM), is seeking an experienced Programmer Analyst 3 to support the modernization of Virginia’s Vital Events and Screening Tracking System (VVESTS). This position plays a key role in transforming critical public health applications by migrating legacy Oracle PL/SQL Web Toolkit applications to Oracle APEX while ensuring the highest standards of security, compliance, and performance for systems containing sensitive personal and health information., The Programmer Analyst 3 will support VDH’s data modernization initiatives by designing, developing, and implementing enhancements to the Virginia Vital Events and Screening Tracking System (VVESTS). The role focuses on migrating legacy Oracle PL/SQL Web Toolkit applications to Oracle APEX while maintaining secure, scalable, and compliant solutions that support Virginia’s Birth Registry, Death Registry, Screening Registry, and multiple integrations with state and federal agencies. This position requires strong expertise in Oracle technologies, SQL/PLSQL development, modern web technologies, and secure application development practices for systems handling sensitive PII and PHI. Responsibilities Application Development

• Develop and enhance enterprise applications using Oracle APEX.
• Migrate legacy Oracle PL/SQL Web Toolkit modules to Oracle APEX.
• Design, develop, test, and implement secure web-based solutions supporting vital records modernization initiatives.
• Develop and maintain Oracle database objects, stored procedures, packages, and SQL scripts.

Database Development

• Design and optimize Oracle 11g, 18c, and 19c database solutions.
• Develop complex SQL and PL/SQL code to support application functionality and data processing.
• Ensure data integrity, performance optimization, and efficient database operations.

Web Development

• Develop user interfaces using JavaScript and/or jQuery.
• Implement modern templates, CSS styling, and web technologies to improve usability and security.
• Support integration of enterprise applications with internal and external systems.

Integration & Security

• Develop and support RESTful and SOAP web services where applicable.
• Ensure applications comply with HIPAA requirements and organizational security standards.
• Help modernize legacy systems while mitigating application security vulnerabilities.

Collaboration & Project Support

• Work closely with the Virginia Department of Health Office of Information Management team.
• Support data modernization initiatives related to vital statistics and vital records.
• Collaborate with technical teams supporting integrations with Virginia state agencies and federal partners.
• Participate in planning, coordination, development, testing, implementation, and ongoing application support.

• Be legally authorized to work in the United States without employer sponsorship, now or in the future.
• Physically reside within the United States for the duration of the assignment.
• Be available to interview in person.
• Be willing to work onsite five days per week during the first 30 days, with the potential to transition to a hybrid schedule of three onsite days per week based on performance and business needs., * Minimum 5 years of experience with Oracle 11g, 18c, or 19c databases.
• Minimum 5 years of strong SQL and PL/SQL development experience.
• Minimum 5 years of experience with JavaScript or jQuery.
• Minimum 5 years of experience developing applications with Oracle APEX.
• Must be legally authorized to work in the United States without employer sponsorship, now or in the future.
• Must physically reside within the United States for the duration of the assignment.
• Must be available for an in-person interview.
• Must be willing to work onsite five days per week during the first 30 days and transition to a three-day onsite schedule thereafter based on performance and business needs.

Preferred Qualifications

• 2 years of experience with Oracle PL/SQL Web Toolkit.
• 2 years of experience developing RESTful and SOAP web services.

Ampcus

• Richmond, VA 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 Te…