- 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
- Experience developing application reporting, preferably with PHP and/or Classic ASP
- 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
EDUCATION:
- Bachelor’s Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience.