Senior Oracle APEX Developer - Modernization (Remote)

LingaTech, LLC; Harrisburg (Dauphin County); À distance; USD 96 000 - 152 000; Plein temps

Résumé du poste

LingaTech, LLC is seeking a skilled Oracle developer to modernize legacy Oracle Forms into Oracle APEX on Oracle 19c, focusing on performance, security, and maintainability. The role involves Agile practices and cross-team collaboration.

You will design UI/UX standards, write PL/SQL, and support SDLC activities while guiding IT staff and ensuring successful deployments for mission-critical applications.

Qualifications

• 5 years of experience developing in Oracle PL/SQL, including stored procedures, functions, packages, and advanced queries.
• 5 years of experience developing applications using Oracle APEX.
• Strong knowledge of Oracle RDBMS, preferably Oracle 19c environments.
• Hands-on experience with SQL Developer and/or TOAD for database development and administration.
• Solid data modeling and relational database design understanding.
• Experience integrating applications with web services.
• Experience performance tuning, debugging, and testing SQL queries, views, and procedures in Oracle/SQL Server environments.

Responsabilités

• Analyze existing Oracle Forms applications to understand architecture, data structures, workflows, and system integrations.
• Convert and migrate legacy Oracle Forms applications into Oracle APEX solutions.
• Design and develop modern Oracle APEX user interfaces in collaboration with technical leadership.
• Help establish UI/UX standards and development best practices for future APEX applications.
• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced SQL queries.
• Perform data extraction, analysis, and scripting to support reporting and system enhancements.
• Review and interpret technical and functional documentation to understand business and system requirements.
• Implement and maintain application security, roles, and authorization models within Oracle environments.
• Conduct performance profiling, tuning, and optimization to improve application responsiveness and maintainability.
• Create and maintain technical, functional, and system documentation.
• Participate in all phases of the SDLC including requirements analysis, development, testing, deployment, and production support.
• Provide mentoring, knowledge transfer, and technical guidance to internal IT staff and development teams.
• Support production deployments and release management activities.
• Provide regular status updates and communicate progress to leadership.
• Generate reports and deliverables for executive stakeholders, technical teams, and end users.

Connaissances

Oracle PL/SQL

Oracle APEX

Oracle RDBMS

SQL Developer

TOAD

Data modeling

Web services

Performance tuning

Debugging & testing

Outils

SQL Developer

TOAD

Description du poste

LingaTech, LLC is seeking a skilled Oracle developer to modernize legacy Oracle Forms into Oracle APEX on Oracle 19c, focusing on performance, security, and maintainability. The role involves Agile practices and cross-team collaboration.

You will design UI/UX standards, write PL/SQL, and support SDLC activities while guiding IT staff and ensuring successful deployments for mission-critical applications.