Overview
Skills
Job Details
Job Title: Oracle APEX Developer (Remote)
Location: Richmond, VA (Webcam Interview Required)
Duration: Long Term
Work Hours: 9:00 AM 6:00 PM EST (Full Availability Required)
Job Description:
We are seeking a Full-Time Oracle APEX Full Stack Developer to support a mission-critical financial application that plays a key role in managing major revenue streams. The ideal candidate will be experienced in full-cycle Oracle APEX application development, including system integration with Oracle ERP solutions, and capable of delivering high-performance database solutions in a fast-paced environment.
Key Responsibilities:
- Design, develop, and implement secure, scalable, and high-performing browser-based applications using Oracle APEX.
- Collaborate with business and technical teams to gather requirements and translate them into functional solutions.
- Write and maintain complex SQL and PL/SQL scripts for data conversion, integration, and migration.
- Develop and manage external tables, joins, indexes, sequences, and create optimized queries and shell scripts as required.
- Perform query optimization and performance tuning using SQL Trace, Explain Plan, Indexing strategies, and PL/SQL features like Bulk Collect and Bind.
- Troubleshoot and debug complex applications and resolve issues quickly and effectively.
- Design and build interactive and dynamic reports using built-in APEX reporting tools.
- Lead and participate in requirement-gathering sessions, solution design discussions, and defect remediation efforts.
Required Skills & Qualifications:
Skill Area | Details |
Oracle APEX Full Stack Development | Experience in full life-cycle development: requirements gathering, UI design, coding, testing, and deployment |
Custom Oracle APEX Applications | Strong background in designing and maintaining custom solutions |
SQL / PL/SQL | Proficient in writing scripts for data conversion and migration |
Database Development | Experience with external tables, joins, indexes, sequences |
Performance Tuning | Proficient in SQL tuning techniques and PL/SQL performance tools |
Reporting | Skilled in creating dynamic, interactive reports in Oracle APEX |
Debugging & Troubleshooting | Ability to quickly identify and remediate defects in complex applications |
Collaboration | Strong communication skills and ability to lead technical discussions |