Oracle Developer

Oracle DeveloperLocation: Tallahassee, FL (On-site)Duration: Through June + annual extensionThis position will be working with technical and program area staff to help with analysis, design, communication, facilitation, and code remediation, towards integrating in-house applications with the statewide PALM (Planning, Account, and Ledger Management) solution. “The Florida Planning, Accounting, and Ledger Management (PALM) Project is replacing the State of Florida’s current accounting and cash management systems with an integrated, enterprise financial management solution (FMS) that will allow the State to organize, define, and standardize its financial management processes.”Education: Bachelor’s Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience.Required tasks to be performed:Provide maintenance, enhancement and support for a variety of the agency’s business applications.Assisting in the preparation and documentation of program requirements and specifications.Research and document requirements of program users.Writing, translating and coding software programs and applications per specifications.Assisting in the development and maintenance of user manuals and guidelines.Working with network administrators, systems analysts and software engineers to assist in resolving problems with software products or company software systems.Providing mentoring and guidance to junior programmers.Required knowledge, skills & abilities: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 database and/or SQL performance tuning3+ years’ experience with financial data, preferably those that deal with accounting processes, procedures, and internal controlsKnowledge of relational database designsKnowledge 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 securityKnowledge 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 systemsAbility to establish and maintain effective working relationships with othersAbility to work independentlyAbility to determine work priorities and ensure proper completion of work assignmentsAbility to work well under pressure and meet deadlines without sacrificing qualityExcellent interpersonal, collaborative, oral and written communication skillsPreferred knowledge, skills & abilities:Oracle certification(s)Experience with standard principles of accounting, such as GAAP or International Financial Reporting StandardsExperience developing PHP applications and/or reportsExperience in web development leveraging XML and CSSExperience with JQuery (Javascript library) or other Javascript frameworks (such as AngularJS, NodeJS, and React)Experience using code repositories, preferably GitExperience using continuous integration tools, preferably JenkinsExperience with environmental regulatory business processes and practicesFamiliarity with Agile development, specifically Scrum, Extreme Programming (XP) and Kanban.