Oracle PLSQL Developer

Job Description:
Required Tasks to be performed:
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
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 Forms
3+ years’ experience with database and/or SQL performance tuning
3+ years’ experience performing in the capacity as a
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