Vacancy expired!
Our government client is looking for experienced
Oracle Reports Developer on a 9+ months renewable contract role in Harrisburg, PA.Position – Oracle Reports DeveloperRemote work allowed but need to report onsite as directed by the managerThe 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. Prior Commonwealth and Environmental experience not required but preferred.The agency is actively modernizing the way it does business and meets the public and client needs. Part of this modernization includes efforts to improve the user interface and some backend processes for the enterprise system, EFACTS. Any agency issued permits, licenses, etc are tracked and stored in EFACTS. Compliance information as well as inspection data, violations and enforcements are also included. Additionally, other systems, such as, the Water Use Data System (WUDS), the Samples Information System (SIS), the Air Information Management System (AIMS), and some ancillary systems are included in this modernization. This effort is expected to take multiple years to complete. In the meantime, there is a need to support the existing systems, address any enhancements, bugs, reporting needs, etc. In order to support the existing systems, agency is seeking an individual to join our team who has experience with Oracle Forms 11G. Strong PL/SQL skills are also required, for writing scripts, perform data pulls and overall data analysis. Ability to write solid documentation is also desired A solid understanding of the features within Oracle’s 12C & 19c database is preferred. Strong communications and knowledge of Environmental systems is preferred.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 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 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 system.
- 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 managers as requested.
- Generate reports as needed for executive management, end-users, and BIT staff
- A Bachelor’s degree in Computer Science or a related field.
- 5-7 years of Oracle PL/SQL writing stored procedures, functions and advanced queries
- 5-7 years’ experience developing in Oracle Forms
- 3-5 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
- Understating and have exposure of the following technologies:
- XML,
- HTML,
- APEX,
- Web Services
- JAVA
- PL/SQL API
- SOA
- Agile /Scrum Development methodologies
- Installation of Oracle software like Oracle forms and reports
- 4 year college degree or equivalent technical study Required
- 5 years of Oracle PL/SQL writing stored procedures, functions and advanced queries Required
- 5 years of experience developing in Oracle Forms Required
- 3 years of experience utilizing Oracle Reports Required
- Sound Knowledge of Oracle DBMS Required
- Strong experience using SQL Developer/TOAD Required
- Understanding of Data Modeling Required
- Understanding of Web services integration Required
- Performance Tuning, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server Required
- Strong Communication skills Required
- Strong Analytical skills Required
Vacancy expired!