Oracle PL/SQL Developer
Kyra Solutions
Tallahassee, United States of America
yesterday
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Tallahassee, United States of America
Tech stack
Accounting Information Systems
Agile Methodologies
Application Integration Architecture
Oracle WebLogic Server
Information Systems
Databases
Data as a Services
Data Validation
ETL
Data Mapping
Data Security
Data Warehousing
Middleware
Web Servers
Oracle
Oracle Applications
Oracle Forms
PCI Data Security Standards
Performance Tuning
Cloud Services
Oracle APEX
Software Engineering
SQL Stored Procedures
PL-SQL
Oracle Fusion Middleware
Data Streaming
Apex Code
Information Technology
Software Version Control
Web Api
Job description
- 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.
Requirements
- 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 Skills and 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., * Bachelor s or master s degree in computer science, Information Systems, or another related field or equivalent work experience.
Certification
- Oracle certifications (e.g., Oracle PL/SQL Developer Certified Associate, Oracle APEX Developer, Oracle Middleware certifications) are preferred.
About the company
Do you want to make an impact on the world around you? The work we do at Kyra Solutions directly impacts government entities and the citizens they serve. In Transportation practice, our solutions are designed to save lives on the roadways and in our Regulatory practice, we are designing solutions to make government digital for your accessibility. Kyra works hard to offer long-term growth potential, competitive wages, and continuous professional development for our employees., Founded in 1997, Kyra Solutions is a national leader of transportation technology and regulatory solutions in government. We specialize in the art and science of digital transformation in government. Our commitment to providing the highest level of service and tailored solutions has supported our consistent double-digit growth for over a decade. We are headquartered in the greater Tampa Bay area with other offices across Florida and an innovation center in Silicon Valley, CA.
Because of our dedication to our employees, we have won one of the Best Companies to Work for in Florida 3 years in a row by Florida Trend magazine. Kyra has won other numerous awards including the coveted INC magazine s one of America s Fastest Growing Companies several years in a row. Kyra's commitment to our employees, to best practices in project management and business analysis, and to solution development has led to our achievement in becoming the first Project Management Institute certified company in Florida. Our proven successful track record has resulted in several prestigious awards including the State of Florida's Diversity Business of the Year Award. We are proud to be a sponsor for the TaxWatch Productivity Awards and partner to Florida TaxWatch.