What are the responsibilities and job description for the Remote - Oracle APEX Developer || W2 position at HYR GLOBAL SOURCE INC?
Remote - Oracle APEX Developer
Work Authorization: U.S. Citizens and Green Card Holders preferred, all valid work authorizations may apply
Working Hours: Eastern Time Zone
Primary Technologies: Oracle APEX, OCI, PL/SQL and SQL
Position Overview: We are seeking a hands-on Oracle APEX Developer to design and build new enterprise applications using Oracle APEX, Oracle Cloud Infrastructure, PL/SQL and SQL.
The consultant will develop APEX pages, forms, reports, dashboards and workflows and integrate these applications with Oracle Fusion Cloud ERP and other enterprise systems. The ideal candidate must have strong end-to-end Oracle APEX development experience rather than primarily administrative or support experience.
Experience developing Oracle Integration Cloud integrations is highly preferred but is not the primary focus of this position.
Key Responsibilities
- Design, develop and deploy new enterprise applications using Oracle APEX.
- Build responsive APEX pages, forms, interactive reports, interactive grids, dashboards and charts.
- Develop application workflows, validations, approval processes, navigation and role-based functionality.
- Create and maintain APEX shared components, templates, lists of values, dynamic actions and reusable application components.
- Develop complex SQL queries, views, packages, procedures, functions, triggers and database APIs using PL/SQL.
- Design Oracle database tables, indexes, sequences, constraints and other database objects supporting APEX applications.
- Integrate Oracle APEX applications with Oracle Fusion Cloud ERP.
- Develop and consume REST and SOAP web services for communication between APEX, Oracle Cloud ERP and external applications.
- Use Oracle REST Data Services to expose and consume secure REST APIs.
- Develop APEX integrations supporting Oracle Cloud ERP business processes and data across Financials, Procurement, HCM or other applicable modules.
- Build file-upload, data-validation, error-handling and transaction-monitoring capabilities within APEX applications.
- Develop secure authentication, authorization and role-based access controls.
- Deploy and support APEX applications within Oracle Cloud Infrastructure.
- Configure and use OCI services required for application hosting, database connectivity, security, storage and monitoring.
- Troubleshoot application performance, SQL execution, PL/SQL errors, integrations and production issues.
- Optimize APEX pages, database queries and PL/SQL processes for performance and scalability.
- Prepare technical designs, database models, integration mappings, deployment documents and production-support procedures.
- Participate in requirements gathering, solution design, development, testing, deployment and post-production support.
- Work with business users and Oracle ERP functional teams to translate requirements into practical APEX solutions.
- Follow secure development, code-review, source-control and release-management practices.
Required Qualifications
- Strong hands-on experience developing enterprise applications using Oracle APEX.
- Demonstrated experience building new APEX applications from design through production deployment.
- Advanced experience developing:
- APEX pages and navigation
- Forms and validations
- Interactive reports and grids
- Dashboards and charts
- Dynamic actions
- Approval workflows
- Shared components
- Authentication and authorization schemes
- Advanced SQL and PL/SQL development experience.
- Experience designing Oracle database schemas and related database objects.
- Experience deploying or supporting APEX applications in Oracle Cloud Infrastructure.
- Experience integrating Oracle APEX with Oracle Fusion Cloud ERP.
- Strong understanding of REST APIs, SOAP services, JSON, XML and authentication methods.
- Experience with Oracle REST Data Services.
- Strong troubleshooting, debugging and performance-tuning skills.
- Ability to work remotely during Eastern Time Zone business hours.
#LI-SS3