Sign upLog in
See more jobs

Oracle APEX & Forms Developer (DEP TAS1)

Phoenix Business, Inc

  • Remote, PA
  • 3 days ago
  • Remote

    Highlights

    Participate in all phases of the software development lifecycle, including requirements gathering, analysis, development, testing, deployment, and production support. Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle and SQL Server.

    Numbers & Facts

    LocationRemote, PA (
    Remote
    )

    Description


    Oracle APEX & Forms Developer (DEP TAS1)
    Key Responsibilities
    • Analyze existing Oracle Forms applications, including architecture, data structures, and integrations.
    • Support the migration and conversion of Oracle Forms applications to Oracle APEX.
    • Design and develop modern Oracle APEX user interfaces in collaboration with the technical lead.
    • Help establish UI/UX design standards for future APEX applications.
    • Develop and maintain PL/SQL stored procedures, functions, packages, and advanced SQL queries.
    • Perform data extraction, data analysis, and scripting for reporting and system enhancements.
    • Review existing technical documentation, system architecture, requirements, reporting, and functionality.
    • Implement and support application security, user roles, and authorization models.
    • Perform performance profiling and tuning to improve application responsiveness and maintainability.
    • Prepare technical, business-functional, and system documentation.
    • Participate in all phases of the software development lifecycle, including requirements gathering, analysis, development, testing, deployment, and production support.
    • Provide mentoring and knowledge transfer to Commonwealth IT staff and other developers.
    • Support production deployments and release management activities.
    • Provide weekly project status updates to management.
    • Generate reports for executive management, end users, and Bureau of Information Technology (BIT) staff.

    Required Qualifications
    • Bachelor's degree in Computer Science or a related field.
    • 5 7 years of experience developing applications using Oracle PL/SQL, including:
      • Stored procedures, functions, and packages
      • Advanced SQL queries
    • 5 7 years of experience developing applications using Oracle APEX.
    • Strong knowledge of Oracle RDBMS, preferably Oracle Database 19c.
    • Hands-on experience with SQL Developer and/or TOAD.
    • Understanding of data modeling principles.
    • Experience integrating web services.
    • Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle and SQL Server.
    • Strong analytical, problem-solving, written, and verbal communication skills.
    Preferred Qualifications
    • Experience modernizing legacy Oracle Forms applications.
    • Previous experience with Commonwealth of Pennsylvania or environmental systems.
    • Exposure to XML, HTML, web services, Java, PL/SQL APIs, and SOA architecture.
    • Experience working in Agile/Scrum development environments.
    • Strong understanding of Oracle Database 19c features.
    • Experience supporting regulatory or mission-critical systems.
    • Ability to create clear and comprehensive technical and functional documentation.

    Similar Jobs