Location: Harrisburg, PA Position Type: Contract Position Term: 3+ Month The candidate must possess strong software engineering skills, and a strong development background in Oracle PL/SQL, Oracle Forms and strong knowledge of an Oracle RDBMS. This individual will be utilized to support the existing system, implement enhancements for the various program areas, assist in upgrades and architectural changes, and provide mentoring and support to agency staff. This position may be involved in any or all facets of developing application system such as defining user requirements, system impacts, analysis, coding, testing, deployments, documentation, etc. Initial Tasks to be accomplished: Understand the inner workings of the DEP’s eFACTS Application and another Oracle system. Understand the roles, security and authorization within the eFACTS and integrated systems. Provide maintenance and support to eFACTS and other Oracle, integrated systems Review selected documentation of the existing systems to become familiar with the system requirements, functionality, and architecture, reporting, etc. Generate, Technical and Business Functional documents, system documents. Profile and tune selected pieces of the system for better maintainability and performance as necessary. Provide mentoring and assistance as required for the transfer of knowledge to other developers and Commonwealth IT staff. Aid in production deployments of systems as needed. Provide weekly status updates to team manager or other DEP managers as requested. Generate reports as needed for executive management, end-users, and BIT staff Skills 4 year college degree or equivalent technical study 5 Years Oracle PL/SQL writing stored procedures, functions and advanced queries 5 Years experience developing in Oracle Forms 3 Years experience utilizing Oracle Reports Sound Knowledge of Oracle DBMS Strong experience using SQL Developer/TOAD Understanding of Data Modeling Understanding of Web services integration Performance Tuning, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server Strong Communication skills Strong Analytical skills