Web Developer

JYG Innovations•Fairborn, OH

6d•Hybrid

About The Position

As the Web Developer you will support the Technical Operations Division of USAFSAM Occupational and Environmental Health Department (OE) by providing design, build, test, enhancement and sustainment services for the OE Laboratory Information Management System (LIMS) and other OE modules hosted within the Human Performance Wing Support System (HPWS). HPWS is a web application built using Adobe ColdFusion 2023 Enterprise, Oracle 19c, Microsoft SQL Server 2019, and is hosted at Wright-Patterson AFB in Dayton, OH. The project includes remote development services (for HPWS) as well as occasional, on-site work within the USAFSAM/OE enclave located at Wright-Patterson AFB in Dayton, OH.

Requirements

Must be a US Citizen and be able to pass a security background check
Minimum Education and Work Experience (one of the following): Computer Science and/or CIS and 4 years Web development experience working with Adobe ColdFusion web applications and Oracle relational databases.
Any bachelor's degree and 6 years' Web development experience working with Adobe ColdFusion web applications and Oracle relational databases.
Any post-secondary education and 8 years of Web development experience working with Adobe ColdFusion web applications and Oracle relational databases.
Proven experience creating and updating Web applications using Adobe ColdFusion, HTML, CSS, JavaScript, and jQuery.
Experience creating, reading, and understanding Oracle and Microsoft SQL Server procedural language (PL/SQL and T-SQL).
Demonstrated experience designing, building, and working with relational databases, both Oracle and Microsoft SQL Server.
Verified experience designing, building, and modifying relational database objects, including tables, views, sequences, triggers, procedures, and functions
Displayed experience creating, reading, and understanding complex SQL queries.
Proven experience working with JavaScript and jQuery within Web applications, especially using jQuery AJAX transactions.
Showen experience performing system analysis and reverse engineering of existing systems.
Verified experience working throughout the entire software development lifecycle; from collecting and documenting requirements, to designing, building, testing, and deploying a complete web application.
Exhibited ability to communicate clearly and effectively in both written and spoken English. This includes being able to convey technical or complex information concisely and accurately through written reports, emails, and verbal presentation.

Responsibilities

Write web application code using Adobe ColdFusion, Oracle PL/SQL, HTML, CSS, JavaScript, and jQuery, to create new modules or to enhance existing modules within HPWS. This code shall be clean, understandable, and shall conform to standards established by the HPWS Program Office.
Web developers who are new to HPWS shall be required to complete a two to four-week orientation period to introduce and acclimate them to the HPWS application framework. This period will include a small project where the Web developer shall be required to demonstrate their technical ability writing ColdFusion, JavaScript, jQuery, and Oracle SQL directly within the HPWS development environment.
Participate in the creation of technical documentation for new projects within HPWS. This includes writing requirements, creating system design documents, relational database diagrams (ERDs), test plans, deployment plans, training material, and other project management artifacts.
Produce new capabilities within HPWS modules, based upon information contained within functional requirement specifications provided by USAFSAM/OE and the HPWS Program Office.
Design, build, and assist with maintenance of Microsoft SQL Server databases and database code. This includes remote work connected by VPN and also in-person work within the USAFSAM/OE enclave.
Develop projects in HPWS modules that comply with HPWS Program Office coding standards, design styles, and project management methodologies for all projects.
Implement secure Web development and coding practices that are aligned with the Risk Management Framework (RMF) certification of the HPWS web application.
Implement secure Web development and coding practices that are in alignment with DoW, USAF, and/or HIPAA information assurance controls.
Produce training content for HPWS web application screens and processes.
Communicate project status weekly to USAFSAM/OE stakeholders and the HPWS Program Office using government-specified tools and documentation.