Job Summary:

Serve as an Application Developer focusing on the following technologies: Oracle Forms, Oracle PL/SQL, PHP, and Classic Microsoft ASP (3.0). This role supports ongoing maintenance to ensure the stability of applications residing in the client’s portfolio. 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 client’s application portfolio, as specified by management.

Primary Responsibility:

• Provide maintenance, enhancement, and support for agency business applications
• Assist in preparing and documenting program requirements and specifications
• Research and document program user requirements
• Write, translate, and code software programs per specifications
• Assist in developing and maintaining user manuals and guidelines
• Collaborate with network admins, systems analysts, and software engineers to resolve software issues
• Provide mentoring and guidance to junior programmers

Required Knowledge, Skills & Abilities (KSAs):

• 7+ years of experience with Oracle databases; skilled in writing complex queries and developing PL/SQL objects (DML & DDL)
• 5+ years of experience developing Oracle Forms
• 3+ years of experience in SQL/database performance tuning
• 3+ years of experience as a full-stack developer
• Experience developing application reporting using PHP and/or Classic ASP 3.0
• Experience with code repositories (preferably Git)
• Experience using continuous integration tools (preferably Jenkins)
• Knowledge of relational database design
• Familiarity with Information Systems Development Methodology (ISDM)
• Experience with database query tools (e.g., TOAD, SQL Developer, SQL Navigator)
• Knowledge of role-based database security
• Proficiency in Unified Modeling Language (UML)
• Creative problem-solving and ability to identify design/specification issues
• Strong ability to work independently and prioritize tasks
• Effective under pressure with the ability to meet deadlines without compromising quality
• Excellent interpersonal, collaborative, oral, and written communication skills

Preferred Knowledge, Skills & Abilities (KSAs):

• Oracle certification(s)
• Familiarity with Agile development methodologies, including Scrum, Extreme Programming (XP), and Kanban
• Experience in web development using XML and CSS
• Experience with JavaScript libraries/frameworks such as jQuery, AngularJS, NodeJS, and React
• Experience with environmental regulatory business processes and practices

Education:

• Bachelor’s Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience.