Overview
Skills
Job Details
Education: A bachelor’s degree or master’s degree from an accredited college or university in Computer Science, Information Systems, or other related field,
Certifications:
• Oracle certifications (e.g., Oracle PL/SQL Developer Certified Associate, Oracle APEX Developer, Oracle Middleware certifications) are preferred.
Required Experience:
1. Experience in application development using Oracle Forms, Oracle APEX, and PL/SQL.
2. Experience with Oracle Database development, performance tuning, and troubleshooting. Proficiency in Oracle Fusion Middleware components (e.g., WebLogic Server, Oracle HTTP Server).
3. Experience integrating applications with enterprise financial systems such as Florida PALM and FLAIR.
4. Knowledge of State of Florida accounting practices from a technical implementation perspective.
5. Demonstrated experience ensuring PCI compliance in application development.
6. Strong written and verbal communication skills.
Preferred Experience
1. Knowledge of the Florida Accounting Information Resource (FLAIR) or Florida PALM
2. Experience with Oracle REST Data Services (ORDS).
3. Familiarity with Agile development methodologies.
4. Experience with version control systems and CI/CD pipelines.
5. Knowledge of application and data security best practice.
6. Experience working in a government or public sector environment
Responsibilities:
• Design, develop, test, and deploy Oracle Forms and APEX applications.
• Write and maintain PL/SQL scripts, stored procedures, and triggers.
• Support and maintain Oracle database objects and schemas.
• Configure and manage Oracle Fusion Middleware components.
• Provide technical support for application issues and enhancements.
• Participate in integration efforts with Florida PALM and FLAIR systems.
• Performing Extract, Transform, and Load (ETL) operations to move data between internal systems (e.g., databases, applications, data warehouses) and external systems (e.g., third-party APIs, partner platforms, cloud services).
• Ensuring data is accurately extracted from source systems, transformed to meet business and technical specifications, and loaded into appropriate target environments.
• Collaborating with stakeholders to define data mapping, transformation rules, and validation requirements.
• Implementing data quality checks and error handling mechanisms to ensure integrity and reliability of data flows.
• Supporting scheduled and on-demand ETL processes as required by business operations or project timelines.
• Coach, mentor, and train OATS team members and other FDACS staff.
• Create and maintain technical documentation and Standard Operating Procedures (SOPs).
• Attend and participate in project meetings and provide regular status updates.
• Submit weekly project reports and time sheets