Oracle PLSQL Developer

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 Forms
• 3 years' experience with database and / or SQL performance tuning
• 3 years' experience performing in the capacity as a full-stack developer
• Experience developing application reporting, preferably with PHP and / or Classic ASP 3.0
• Experience using code repositories, preferably Git
• 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 Knowledge, Skills & Abilities (KSAs) :

• Oracle certification(s)
• Familiarity with Agile development, specifically Scrum,Extreme Programming (XP) and Kanban.
• Experience in web development leveraging XML and CSS
• Experience with JQuery (Javascript library) or other Javascript frameworks (such as AngularJS, NodeJS, and React)
• Experience with environmental regulatory business processes and practices
• Knowledge and understanding of DEP's technical environment