Oracle Developer — Ashburn, VA
Зарплата не указана
ОткликнутьсяRole Summary
The Oracle APEX Developer will build, extend, maintain, and modernize enterprise applications using Oracle APEX 24.x and Oracle Database 19c. This role is responsible for developing secure, high-performance applications supporting complex financial, disbursing, and collections data. The position will also migrate Oracle Forms and Reports functionality to modern APEX solutions while preserving business rules, functionality, and auditability. Success requires strong PL/SQL expertise, secure coding practices, and experience delivering applications in controlled or regulated environments.
Responsibilities
• Build and maintain Oracle APEX applications using App Builder, pages, regions, interactive grids and reports, forms, master-detail components, dynamic actions, validations, computations, and processes.
• Configure session state, authorization schemes, authentication schemes, application items, Shared Components, and APEX plug-ins.
• Develop client-side functionality using the APEX JavaScript API, Universal Theme customization, and client-side validation.
• Integrate REST Data Sources and ORDS to support application and enterprise data requirements.
• Tune application performance through pagination, lazy loading, indexing strategies, and other techniques for large financial datasets.
• Develop PL/SQL packages, procedures, functions, triggers, autonomous transactions where appropriate, and bulk-processing solutions.
• Apply transactional integrity, locking, exception handling, parameterized SQL, least-privilege schemas, and fine-grained auditing practices.
• Convert complex Oracle Forms modules and Reports into APEX equivalents, including multi-block forms, master-detail interfaces, LOVs, triggers, program units, and reporting functionality.
• Implement secure development practices, including input validation, output encoding, CSRF protection, session management hardening, encryption, audit trails, and segregation of duties.
• Support Git-based development, code reviews, unit and integration testing, and controlled application deployments.
Qualifications
• Proven production experience building, extending, and maintaining Oracle APEX applications on version 24.x, or recent 23.x experience with clear knowledge of migration to 24.x.
• Strong Oracle Database 19c or equivalent enterprise database experience.
• Advanced PL/SQL development skills, including packages, procedures, functions, triggers, bulk processing, and high-volume transactional data handling.
• Hands-on experience migrating complex Oracle Forms and Reports applications to Oracle APEX.
• Knowledge of APEX state management, client-side and server-side processing, report generation strategies, and common migration challenges.
• Experience developing secure applications for financial, banking-like, public-fund accountability, or other regulated environments.
• Familiarity with database and application security guidance, including STIG concepts and the OWASP Top 10 as applied to APEX.
• Experience with Git-based workflows, code reviews, unit testing, integration testing, and controlled deployments.
• Demonstrated ability to protect sensitive data through secure coding, encryption, comprehensive audit trails, and segregation-of-duties controls.
• Ability to work remotely from an approved location.
• Must be eligible to obtain the required Public Trust determination. U.S. citizenship may be required based on contract and agency requirements.
Publishing Pay Range: $40.00 – $46.00 hourly
This is a fully remote role and can be performed from an approved location.