Applications Architect (Oracle PL/SQL) (On-site)

Join Our Team

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.

If you are interested in furthering your career with Kyra and help us improve the way governments serve their citizens, please send your resume, and make sure to include salary expectation, availability, and contact information. You do not want to miss this opportunity!

Title

Applications Architect (Oracle PL/SQL) (On-site)

Required Skills and Experience

* 8+ 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

* Experience designing, developing, and maintaining applications such as the Administrative Image Management System (AIMS), Financial Inquiry System (FIS), and Revenue Online Collection (ROC).
* 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.

Primary 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 client 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.

Education

* 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.

Location

Tallahassee, FL

Duration

Long-Term

Why Kyra?

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.

Background & References

Verifiable professional references will be required along with the resume; however, references will be checked/contacted after the interview and before the project starts. Level two background check will be done on the selected candidate for employment, criminal (State & Federal), education, and others as mandated by the client. Please make sure your resume and all other information provided are accurate. Any misrepresentation will mean permanent disqualification by the client. Equal employment opportunity employer.