Job Title: Application Architect specializing in an Oracle APEX environment
Location: Atlanta, GA (Remote acceptable; GA local candidates preferred)
Duration: 10-12+ Months
Experience: 10+ Years
Work Authorization: USA-authorized candidates
Key Responsibilities
Architecture Design
• Define end-to-end application architecture, technical standards, and reference patterns for enterprise low-code solutions built on Oracle APEX and Oracle Database (19c/23ai).
• Design scalable, multi-tier web applications utilizing Oracle REST Data Services (ORDS), WebLogic/Tomcat, and cloud-native infrastructure (AWS).
• Translate complex business requirements into normalized relational data models, modular APEX application workspaces, and reusable shared components.
• Lead legacy modernization initiatives, architecting migration paths from spreadsheets or monolithic systems into modern Oracle APEX applications.
Database, Backend & Integration
• Architect high-performance PL/SQL packages, APIs, triggers, and database views to encapsulate business logic within the database tier rather than the UI layer.
• Design and govern secure RESTful web services via ORDS to integrate Oracle APEX applications with external third-party enterprise systems.
• Need to work with senior DBA team members to establish database performance tuning standards, reviewing execution plans, indexing strategies, and SQL queries to maintain sub-second page load times under high concurrency.
Security, Governance & DevOps
• Implement enterprise security frameworks across APEX workspaces, including SAML 2.0 / OAuth2 / OIDC single sign-on, role-based access control (RBAC).
• Enforce secure coding practices to prevent SQL injection, cross-site scripting (XSS), and unauthorized session state manipulation.
• Design and automate CI/CD pipelines for Oracle APEX and database deployments using Git, and automated export/import utilities.
• Establish governance policies for multi-developer teams, including workspace isolation
Technical Leadership
• Partner with DBAs, infrastructure engineers, and enterprise architects to plan capacity, high availability (RAC/Data Guard), and disaster recovery for mission-critical APEX environments.
• Evaluate new Oracle APEX releases and features (such as AI Vector Search, Workflow, and Approvals) to drive continuous platform adoption and innovation.
Required qualifications
• 10+ years in systems analysis, design, and development.
• Hands-on experience designing Oracle Database and Oracle APEX solutions.
• Experience designing REST/API integrations with third-party services, including payment processing.
• Experience designing secure systems that handle personal or health information.
• Bachelor’s degree in computer science, Information Systems, or a related field.
• Strong ability to explain technical designs to non-technical leaders.
Preferred qualifications
• Government or public health experience, especially registries or licensing systems.
• Experience with identity verification, digital credentials, or mobile wallet passes.
• Experience designing legacy data migrations.
• Familiarity with the Health Insurance Portability and Accountability Act (HIPAA), NIST 800-53, or state IT security standards.
• TOGAF, Oracle Certified Professional, or cloud architect certification.