| Location | Dauphin, PA (Remote) |
This position provides independent advanced analysis, design, development, enhancements, implementation, and support to ensure efficient and effective operation of complex software. This position acts as a subject matter expert for Oracle Commerce Cloud and the related subsystems to support the PLCB's (Pennsylvania Liquor Control Board) Fine Wine & Good Spirits (FWGS.com) website, Licensee Online Ordering Portal (LOOP) and Associate Portal (AP). They also provide daily operational support for the Oracle Commerce Cloud (OCC) and extranet environments. This includes configuration of the Oracle Integration Cloud (OIC). Development of other special projects is assigned as needed.
The primary responsibility of the employee in this position is development within the various Oracle systems utilized by the PLCB, this includes the Fine Wine and Good Spirits website (FWGS.com), the Licensee Online Ordering Portal (LOOP) and Associate Portal (AP). This development can be done individually or as part of a team, depending on the complexity of the project. Defects and requests from the business are taken by the team. The employee must analyze existing code, then plan and design solutions. They routinely develop and debug code. Testing is conducted by the developer or team before submitting to the business for UAT (User Acceptance Testing). Work done by the incumbent must be documented within the code and in the agency's change management system.
At times, new enhancements and integration into other systems are requested or mandated. The incumbent must research and evaluate the products and determine their viability. They must effectively communicate their observations to a variety of staff which differ in technical skill levels. In addition, they will need to integrate any new systems selected into the Oracle Suite, which may require programming changes.
Development is to be peer reviewed. Code changes from all positions in the team are to be reviewed by a second position from within the team. This position will review code when necessary.
The guidelines set forth by the agency regarding Change Management must be adhered to. The position will document and be able to speak about changes to the system during reviews. The person selected for the position will also have the responsibility to make level of effort estimations for request for service or enhancements from the business. The estimation activity is to be documented and presented to the heads of IT and the business for prioritization.
Testing of system changes from the team will be conducted within the team for accuracy before the code is moved to the next environment. Further testing is done by the business users after internal testing is complete. Defects found are documented and are the responsibility of the developer to fix and retest before progressing back to the business for additional user acceptance testing.
The position will support several nonproduction environments that are used for testing. They will progress the code and change through the environments. The environments are to be kept in a clean state so as not to cause confusion. This is the responsibility of all developers in the PLCB.
The position will serve as a subject matter expert for the various systems owned and integrated with, in addition to development tools, processes, policies, and the code base. When called upon they are to give information on any of the topics.
Business requests to change packaged and customized application software (ex: Oracle Commerce Cloud, Fine Wine and Good Spirits website, Licensee Online Ordering Portal, etc.) are evaluated by the incumbent. They also advise on functional management of the most efficient technical solution.
Status reports are to be provided to the group manager. These reports include individual status, project status, performance, and training. Status reports are for project management and identify progress and/or deviations from objectives.
The position assists in the assessment of software products and makes recommendations for purchase to meet organizational and Commonwealth objectives. This can be done as a team or individually depending on the business need.
This position will also serve in advanced troubleshooting, investigating, and debugging of problems and defects found in the supported systems. Problems are found and logged by internal staff. This position will research the problems found, log input and findings into the ticket and theorize a solution.
At times this position will perform maintenance activities as needed. Updates to the various systems require the stopping jobs and restarting of certain jobs. This function is typically conducted off hours (after 5:00 PM and before 8:00 AM). Other maintenance activities include restarting integration between the systems and system monitoring.
System performance is to be monitored and operational deficiencies relative to program execution are to be identified by the incumbent. Recommendations, implementation of solutions, and remedial actions to ensure acceptable performance are the responsibility of the Senior Application developer.
The position cooperates with other developers and IT staff to provide security and quality assurance measures. These activities include backup, recovery, data security, error handling, and system controls.
This position adheres to established bureau, commonwealth and industry standards, policies and procedures. These include proper testing documentation in all environments, security policies and procedures applied to development, PCI (Payment Card Industry) standards, and ecommerce team standards. These practices must be met to ensure the integrity and safety of the data and keep in compliance with the industry. The incumbent also assists in the establishment of standards, guidelines, and acceptable customer service levels relating to web applications for the PLCB.
Documentation of design decisions, requirements, level of effort estimations and similar are required by the incumbent. These documents are developed with other IT staff and the business end users.
Performs other related job duties as needed.
System Years Experience
HTML/CSS 2-5
SQL 2-5
XML/JSON 2-5
JavaScript 2-5
Java 2-5
Oracle SQL Developer 0-2
Open Storefront Framework 2-5
DevOps 0-2
Visual Studio 0-2
MongoDB. 2-5
Required/Desired Skills| Skill | Required /Desired | Amount | of Experience |
|---|---|---|---|
| HTML/CSS | Required | 2 | Years |
| SQL | Required | 2 | Years |
| XML/JSON | Required | 2 | Years |
| JavaScript | Required | 2 | Years |
| Java | Required | 2 | Years |
| Open Storefront Framework | Required | 2 | Years |
| MongoDB | Required | 2 | Years |
| Oracle SQL Developer | Required | 0 | |
| DevOps | Required | 0 | |
| Visual Studio | Required | 0 |