Oracle PL/SQL Developer (On-site from Day One)

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, 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

Oracle PL/SQL Developer (On-site from Day One)

Required Skills and Experience

* 7+ years experience with Oracle databases with the capability to write complex queries and develop complex PL/SQL database objects, including both DML and DDL.
* 3+ years experience with Oracle Forms.
* 3+ years experience with database and/or SQL performance tuning.
* 3+ years experience with financial data, preferably those that deal with accounting processes, procedures, and internal controls.
* Knowledge of relational database designs.
* Experience using continuous integration tools, preferably Jenkins.
* Knowledge of relational database designs.
* Knowledge of Information Systems Development Methodology (ISDM).
* Experience with database query tools (i.e., TOAD, SQL Developer, SQL Navigator).
* Knowledge of database security, including role-based security.
* Knowledge and experience with Unified Modeling Language (UML).
* Ability to be creative, to use sound judgment, and to display foresight to identify potential problems and design/specifications and assigned application software systems.
* Ability to establish and maintain effective working relationships with others.
* Ability to work independently.
* Ability to determine work priorities and ensure proper completion of work assignments.
* Ability to work well under pressure and meet deadlines without sacrificing quality.
* Excellent interpersonal, collaborative, oral and written communication skills.

Preferred Skills and Experience

* Oracle certification(s).
* Experience with standard principles of accounting, such as GAAP or International Financial Reporting Standards.
* Experience developing PHP applications and/or reports.
* Experience in web development leveraging XML and CSS.
* Experience with JQuery (Javascript library) or other Javascript frameworks (such as AngularJS, NodeJS, and React).
* Experience using code repositories, preferably Git.
* Experience using continuous integration tools, preferably Jenkins.
* Experience with environmental regulatory business processes and practices.
* Familiarity with Agile development, specifically Scrum, Extreme Programming (XP) and Kanban.
* Knowledge and understanding of Client technical environment.

Primary Responsibilities

* Provide maintenance, enhancement and support for a variety of the Client business applications.
* Assist in the preparation and documentation of program requirements and specifications.
* Research and document requirements of program users.
* Analyze existing schemas, documenting relationships and dependencies.
* Write scripts for migrating data from old data structures to new ones, which may include transforming data values to fit new standards.
* Leverage DDL and DML to administer Oracle database objects to include schemas, tables, fields, views, packages, and procedures.
* Update and manage scripts and scheduled tasks through operating system utilities such as CRON jobs.
* Write, translate and code software programs and applications per specifications.
* Assist in the development and maintenance of user manuals and guidelines, to include documenting current and future state changes.
* Work with network administrators, systems analysts and software engineers to assist in resolving problems with software products or company software systems.
* Work with the project team to facilitate unit, interface, integration, and user acceptance tests.
* Attend and contribute to all requisite project ceremonies.
* Modify existing Oracle Forms to reflect changes in the underlying database including adding new fields, modifying existing ones, and removing obsolete elements.
* Ensure Oracle Forms UI remains user-friendly and meets agency business requirements.
* Revise existing PHP reports or develop new ones as required by the new system.

Education

* Bachelor s Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience.

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 2 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. for more information.

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.