Software YBsGbWwcb – Oracle APEX / PL/SQL — Indianapolis, IN
Зарплата не указана
ОткликнутьсяКомпания: ••••••••
Локация: Indianapolis, IN
Формат: не указан
Занятость: Полная занятость
Грейд: Senior
Role Summary
This remote Software Developer role focuses on designing, developing, testing, documenting, and maintaining Oracle applications and software systems. The position requires advanced expertise in Oracle APEX, Oracle Database, PL/SQL, and the modernization of legacy Oracle Forms and Reports applications. The developer will support secure, scalable solutions for high-volume financial data and contribute throughout the software development lifecycle in an Agile environment.
Responsibilities
• Build, extend, maintain, test, and debug Oracle APEX applications using APEX 24.2 or a recent 23.x version with migration path expertise.
• Develop application 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, plug-ins, and REST Data Sources.
• Apply the APEX JavaScript API, Universal Theme customization, and client-side validation techniques.
• Develop and maintain PL/SQL packages, procedures, functions, triggers, and audit or logging processes.
• Design secure, high-performance database solutions using transactional integrity, locking, exception handling, bulk processing, parameterized SQL, least-privilege schemas, and fine-grained auditing.
• Tune APEX applications through pagination, lazy loading, indexing strategies, and other performance optimization methods for large financial datasets.
• Convert complex Oracle Forms modules and Reports into modern APEX applications while preserving business rules, functionality, and auditability.
• Reverse-engineer legacy Forms logic, including multi-block forms, master-detail relationships, LOVs, triggers, and program units.
• Collaborate within Agile development processes to document, evaluate, and enhance software applications and systems.
Qualifications
• At least 5 years of relevant experience with a bachelor’s degree, or 3 years of relevant experience with a master’s degree.
• Proven production experience with Oracle APEX 24.2 or recent 23.x versions, including migration path knowledge.
• Strong Oracle Database 19c or equivalent enterprise database experience.
• Advanced PL/SQL development skills, including packages, procedures, functions, triggers, autonomous transactions where appropriate, and high-volume data processing.
• Hands-on experience migrating Oracle Forms and Reports applications to Oracle APEX.
• Experience with APEX App Builder, Shared Components, plug-ins, REST Data Sources, ORDS integration, session state, and security schemes.
• Knowledge of secure coding practices for financial data and enterprise application environments.
• Experience with Oracle Forms, Oracle Reports, APEX, PL/SQL, and Agile methodologies.
• 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.