VDH Programmer Analyst 3

^{Varmoda is seeking an experienced Oracle APEX / PL/SQL Developer to design, develop, maintain, and modernize enterprise applications built on Oracle technologies. The ideal candidate will have extensive experience with Oracle Database (11g, 18c, and 19c), PL/SQL development, and Oracle Application Express (APEX), along with expertise in application modernization, web services integration, and secure data handling.}

^{This role will be responsible for supporting existing applications, developing new Oracle APEX solutions, and assisting with the migration of legacy PL/SQL Web Toolkit applications to modern, scalable architectures.}

^{Key Responsibilities}

• ^{Design, develop, test, and maintain enterprise applications using Oracle APEX.}
• ^{Create and optimize SQL queries, PL/SQL packages, stored procedures, functions, triggers, and database objects.}
• ^{Support Oracle Database environments including Oracle 11g, 18c, and 19c.}
• ^{Develop secure, scalable, and high-performing web applications using Oracle APEX best practices.}
• ^{Support and modernize legacy applications built using the Oracle PL/SQL Web Toolkit.}
• ^{Participate in application migration and modernization initiatives from legacy platforms to Oracle APEX.}
• ^{Develop and maintain integrations using RESTful and SOAP web services.}
• ^{Enhance front-end user experience through JavaScript and jQuery development.}
• ^{Troubleshoot application and database performance issues.}
• ^{Collaborate with business stakeholders, analysts, and technical teams to gather requirements and deliver solutions.}
• ^{Implement security controls and best practices for the protection of Personally Identifiable Information (PII) and Protected Health Information (PHI).}
• ^{Ensure compliance with organizational security standards and applicable regulations, including HIPAA requirements.}
• ^{Prepare technical documentation, design specifications, and deployment procedures.}

^{Required Qualifications}

^{Oracle Database}

• ^{Minimum 5 years of experience supporting Oracle database-driven enterprise applications.}
• ^{Experience with Oracle 11g, Oracle 18c, and Oracle 19c environments.}
• ^{Strong understanding of database design, performance tuning, and optimization.}

^{SQL and PL/SQL}

• ^{Minimum 5 years of hands-on experience with:}
  • ^{SQL development}
  • ^{PL/SQL programming}
  • ^{Stored Procedures}
  • ^Packages
  • ^Functions
  • ^Triggers
  • ^{Database performance optimization}

^{Oracle APEX}

• ^{Minimum 5 years of experience developing applications using Oracle Application Express (APEX).}
• ^{Experience creating secure, scalable, and responsive enterprise applications.}

^{JavaScript / jQuery}

• ^{Minimum 5 years of experience with JavaScript and/or jQuery.}
• ^{Experience enhancing user interfaces and modernizing web application functionality.}

^{Desired Qualifications}

^{Oracle PL/SQL Web Toolkit}

• ^{Minimum 2 years of experience supporting or developing Oracle PL/SQL Web Toolkit applications.}
• ^{Experience migrating legacy PL/SQL Web Toolkit applications to Oracle APEX.}

^{Web Services Integration}

• ^{Minimum 2 years of experience with:}
  • ^{RESTful APIs}
  • ^{SOAP Web Services}
  • ^{System-to-system integrations}

^{Security & Compliance}

• ^{Experience handling sensitive data, including:}
  • ^{PII (Personally Identifiable Information)}
  • ^{PHI (Protected Health Information)}
• ^{Knowledge of HIPAA compliance and secure software development practices.}

^{Preferred Skills}

• ^{Oracle Application Development Framework knowledge.}
• ^{Oracle performance tuning and query optimization.}
• ^{Experience with application lifecycle management and deployment practices.}
• ^{Familiarity with Agile/Scrum development methodologies.}
• ^{Strong problem-solving and analytical skills.}
• ^{Excellent verbal and written communication skills.}

^Education

• ^{Bachelor''s degree in Computer Science, Information Technology, Information Systems, or a related field.}
• ^{Equivalent combination of education and relevant experience may be considered.}