Oracle PL/SQL Developer-Application Development Analyst

Thestaffinghub - Tallahassee, FL

Full-time

Tallahassee, FL

Administrative and Support Services

About the position

The Oracle PL/SQL Developer-Application Development Analyst serves as an Application Developer with a focus on Oracle Forms, Oracle PL/SQL, PHP, and Classic Microsoft ASP (3.0). This role is essential for maintaining the stability of applications within the DEP portfolio, with responsibilities that may extend to various projects as directed by FDEP management.

Responsibilities

• Provide maintenance, enhancement, and support for a variety of the agency's business applications.
• Assist in the preparation and documentation of program requirements and specifications.
• Research and document requirements of program users.
• Write, translate, and code software programs and applications per specifications.
• Assist in the development and maintenance of user manuals and guidelines.
• Work with network administrators, systems analysts, and software engineers to resolve problems with software products or company software systems.
• Provide mentoring and guidance to junior programmers.

Requirements

• 7+ years experience with Oracle databases, capable of writing complex queries and developing 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 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, use sound judgment, and display foresight to identify potential problems in design/specifications and assigned application software systems.
• Ability to establish and maintain effective working relationships with others.
• Ability to work independently and determine work priorities to 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.

Nice-to-haves

• 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.