Oracle Technical Architect

Key Responsibilities

• Design, develop, test, deploy, and maintain Oracle Forms and Oracle APEX applications.
• Develop and maintain PL/SQL scripts, stored procedures, triggers, and database packages.
• Support and maintain Oracle database schemas, objects, and performance tuning.
• Configure and manage Oracle Fusion Middleware components (WebLogic Server, Oracle HTTP Server).
• Design and support data integrations and ETL processes, including data extraction, transformation, validation, and loading.
• Support integrations with Florida PALM and FLAIR systems.
• Implement data quality checks, error handling, and monitoring for ETL processes.
• Ensure compliance with State of Florida accounting practices, PCI standards, and data security requirements.
• Provide application troubleshooting, enhancements, and performance optimization.
• Create and maintain technical documentation and SOPs.
• Collaborate with business and technical stakeholders; mentor and support FDACS/OATS staff.

Required Skills & Experience

• 8+ years of application development using Oracle Forms, Oracle APEX, and PL/SQL.
• Strong experience with Oracle Database development, performance tuning, and troubleshooting.
• Proficiency in Oracle Fusion Middleware (WebLogic Server, Oracle HTTP Server).
• Experience integrating applications with enterprise financial systems such as Florida PALM and FLAIR.
• Experience with ETL processes and data integration between internal systems, external systems, APIs, and cloud services.
• Demonstrated experience ensuring PCI compliance in application development.
• Knowledge of State of Florida accounting practices (technical implementation).
• Strong written and verbal communication skills.