Application Development Analyst - Oracle Forms, Oracle APEX

Job Title: Application Development Analyst - Oracle Forms, Oracle APEX

Location: Tallahassee, FL

Mode: Contract

BACKGROUND:

The Department requires application development and Oracle database services to support its financial systems. This includes the development and maintenance of applications using Oracle Forms, Oracle APEX, and PL/SQL, as well as integration support for Florida PALM and FLAIR. The selected contractor will also provide expertise in Oracle Fusion Middleware to ensure secure, scalable, and high-performing application environments. Familiarity with State of Florida accounting practices and PCI compliance is essential to ensure technical alignment with state and regulatory standards. SCOPE The Contractor will provide an experienced Application Development Analyst to: Design, develop, and maintain Oracle-based financial applications. Support integration efforts with Florida PALM and FLAIR systems. Responsible for designing, developing, and maintaining data integration processes to support application functionality and reporting requirements. Develop and maintain PL/SQL scripts, stored procedures, and database packages. Utilize Oracle Fusion Middleware for application deployment, security, and integration. Ensure applications align with State of Florida accounting practices from a technical perspective. Ensure applications meet data security and Payment Card Industry (PCI) compliance standards. Collaborate with business and technical teams to gather requirements and implement solutions. Ensure application performance, security, and compliance with Department and regulatory standards. The Contractor, through its selected candidate, must perform all tasks and complete the deliverables identified in this Statement of Work (SOW).

QUALIFICATION REQUIREMENTS:

CANDIDATE To accomplish the work outlined above, FDACS requires an experienced Application Development Analyst with the following skills and experiences listed below. This list is not exhaustive; nor are all skills required. Technical Skills, written and verbal communication, and experiences will be the basis for evaluation of responses to the RFQ. Minimum Qualifications 5 years of experience in application development using Oracle Forms, Oracle APEX, and PL/SQL. Experience with Oracle Database development, performance tuning, and troubleshooting. Proficiency in Oracle Fusion Middleware components (e.g., WebLogic Server, Oracle HTTP Server). Experience integrating applications with enterprise financial systems such as Florida PALM and FLAIR. Knowledge of State of Florida accounting practices from a technical implementation perspective. Demonstrated experience ensuring PCI compliance in application development. Strong written and verbal communication skills. Preferred Experience Knowledge of the Florida Accounting Information Resource (FLAIR) or Florida PALM Experience with Oracle REST Data Services (ORDS). Familiarity with Agile development methodologies. Experience with version control systems and CI/CD pipelines. Knowledge of application and data security best practice. Experience working in a government or public sector environment. Educational qualifications meeting at least one of the following levels: bachelor s or master s degree in computer science, Information Systems, or another related field or equivalent work experience. Oracle certifications (e.g., Oracle PL/SQL Developer Certified Associate, Oracle APEX Developer, Oracle Middleware certifications) are preferred.

CONTRACTOR RESPONSIBILITIES

The Application Development Analyst will be responsible for the following tasks: 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.