Job Description : (Onsite Position)
Position : Oracle PL / SQL Developer
Location : Tallahassee, FL
Duration : 12 Months
Primary Work :
Application developer focusing on the following technologies : Oracle Forms, Oracle PL / SQL, PHP, and Classic Microsoft ASP (3.0). This role supports ongoing maintenance needed to ensure the stability of applications residing in the DEP portfolio. The focus of this support work will focus on a specific Division’s application portfolio, however, the team member may also be assigned to work on other projects and / or applications in the DEP application portfolio, as specified by FDEP management.
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 (KSAs) :
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.5 years’ experience developing Oracle Forms3 years’ experience with database and / or SQL performance tuning3 years’ experience performing in the capacity as a full-stack developerExperience developing application reporting, preferably with PHP and / or Classic ASP 3.0Experience using code repositories, preferably GitExperience using continuous integration tools, preferably JenkinsKnowledge 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 (KSAs) :
Oracle certification(s)Familiarity with Agile development, specifically Scrum, Extreme Programming (XP) and KanbanExperience in web development leveraging XML and CSSExperience with JQuery (Javascript library) or other Javascript frameworks (such as AngularJS, NodeJS, and React)Experience with environmental regulatory business processes and practicesKnowledge and understanding of DEP’s technical environmentEducation :
Bachelor’s Degree in Computer Science, Information Systems, or other Information Technology major, or equivalent work experience.