Remote contract opportunity to modernize legacy Oracle Forms applications and migrate them to Oracle APEX on Oracle Database 19c.

Analyze existing Oracle Forms application architecture, data structures, and integrations
Support migration and conversion from Oracle Forms to Oracle APEX
Collaborate with the technical lead to design and build modern APEX user interfaces
Assist in defining UI/UX design standards for future APEX applications
Develop and maintain PL/SQL stored procedures, functions, packages, and advanced queries
Perform data pulls, data analysis, and scripting to support reporting and system enhancements
Review documentation to understand requirements, architecture, reporting, and functionality
Implement and support application security roles and authorization models across integrated Oracle systems
Conduct performance profiling and tuning to improve maintainability and responsiveness
Create technical, business, functional, and system documentation
Participate across the system development lifecycle: requirements gathering, analysis, coding, testing, deployment, and post-production support
Provide mentoring and knowledge transfer to internal IT staff and other developers
Assist with production deployments and release management activities
Deliver weekly status updates to management
Produce reports for executive management, end users, and IT staff

Bachelor’s degree in computer science or a related field
5–7 years of Oracle PL/SQL development experience, including:
- Stored procedures
- Functions
- Packages
- Advanced queries
5–7 years of experience developing applications using Oracle APEX
Strong knowledge of Oracle RDBMS, preferably Oracle Database 19c
Strong experience using 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 and problem-solving skills
Strong written and verbal communication skills

Oracle PL/SQL development experience (stored procedures, functions, packages, advanced queries) Required, 5 years
Oracle APEX application development experience Required, 5 years
Strong Oracle RDBMS knowledge (Oracle Database 19c preferred) Required
Strong SQL Developer and/or TOAD experience Required
Data modeling principles understanding Required
Web services integration experience Required
Performance tuning, debugging, and testing SQL in Oracle and SQL Server Required
Bachelor’s degree in computer science or related field Required
Environmental or regulatory systems experience Desired

Prior experience with environmental or regulatory systems (preferred, not required)
Experience modernizing legacy Oracle Forms applications
Exposure to: XML, HTML, Web services, Java, PL/SQL APIs, SOA architecture
Exposure to Agile/Scrum development methodologies
Strong understanding of Oracle Database 19c features
Experience supporting regulatory or mission-critical systems
Ability to produce clear, comprehensive technical and functional documentation

Proper email communication will only be done to and from @astyra.com email addresses
8-month remote Oracle APEX Developer (PL/SQL) contract role for modernizing and migrating legacy Oracle Forms applications to Oracle APEX on Oracle Database 19c
Requires Oracle PL/SQL and Oracle APEX development experience in an Agile/Scrum environment

Oracle APEX Developer (PL/SQL)

Job Description