Note: The job is a remote job and is open to candidates in USA. HYR Global Source Inc is seeking a hands-on Oracle APEX Developer to design and build enterprise applications using Oracle APEX, Oracle Cloud Infrastructure, PL/SQL, and SQL. The role focuses on developing APEX applications, integrating them with Oracle Fusion Cloud ERP and other enterprise systems, and supporting secure, scalable deployments.
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
Skills
- 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
- U.S. Citizens and Green Card Holders preferred
- Experience developing Oracle Integration Cloud integrations is highly preferred
Benefits
- Remote work during Eastern Time Zone business hours
Company Overview