Programmer Analyst 3
About The Position
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. Applications will be reviewed as received. Candidates must be legally authorized to work in the United States without employer sponsorship, now or in the future. Candidates must physically reside within the United States for the duration of the assignment. Candidates must be available to interview in person. Candidates must 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.
Requirements
- 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.
Nice To Haves
- 2 years of experience with Oracle PL/SQL Web Toolkit.
- 2 years of experience developing RESTful and SOAP web services.
Responsibilities
- 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.
- 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.
- 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.
- 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.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
