NeptuneItsolutions LLC · 4 weeks ago
Aplication Architect
Florida, United States
Contract
Onsite
Senior LevelNeptuneItsolutions LLC is seeking an Applications Architect to support the Florida Department of Agriculture and Consumer Services. The role involves designing, developing, and maintaining Oracle-based financial applications, ensuring compliance with state accounting practices and data security standards.
Information Services
Responsibilities
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
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
Qualification
Required
Experience in application development and Oracle database services
Proficiency in Oracle Forms, Oracle APEX, and PL/SQL
Expertise in Oracle Fusion Middleware
Familiarity with State of Florida accounting practices
Knowledge of PCI compliance standards
Ability to design, develop, and maintain Oracle-based financial applications
Experience in supporting integration efforts with Florida PALM and FLAIR systems
Ability to design, develop, and maintain data integration processes
Experience in writing and maintaining PL/SQL scripts, stored procedures, and database packages
Ability to ensure applications align with State of Florida accounting practices
Ability to ensure applications meet data security and PCI compliance standards
Experience in collaborating with business and technical teams to gather requirements
Ability to ensure application performance, security, and compliance with Department and regulatory standards
Experience in designing, developing, testing, and deploying Oracle Forms and APEX applications
Experience in configuring and managing Oracle Fusion Middleware components
Ability to provide technical support for application issues and enhancements
Experience in performing Extract, Transform, and Load (ETL) operations
Ability to ensure data integrity and reliability of data flows
Experience in creating and maintaining technical documentation and Standard Operating Procedures (SOPs)
Ability to coach, mentor, and train team members
Ability to attend and participate in project meetings and provide regular status updates
Ability to submit weekly project reports and time sheets
Completion of the Department's security awareness training within fifteen (15) calendar days of start date
Undergo a level 2 background check paid for by the Department
Sign and comply with confidentiality and data use agreements
Successfully pass the Department's ethics and security awareness online training
Obtain CJIS Certification
Company
NeptuneItsolutions LLC
Neptune IT Solutions is a global IT company offering strategic IT solutions and services for complex business problems in various sectors, including retail, healthcare, finance, education, and more.
2-10 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase