- Sr Oracle Dev
RCSOB, 400 Market St, Harrisburg, PA
12 months+
Either Go To Meeting Web Cam or In Person interview
DEP's enterprise system is called eFACTS (Environmental Facility Application Compliance Tracking System). It is an Oracle web form based application that uses an Oracle 11G DB as the back end. It provides a holistic view of the clients and sites (including facilities) that DEP regulates. In addition it tracks the various functions that support DEP regulations such as compliance activities, bonding, fees, certifications, authorizations/licenses/permits, etc. eFACTS is a complex system encompassing thousands of business rules. There are over 2000 users from all facets of the department, plus several external users. It provides for basic data entry roles, application processors, compliance specialist, bonding, certification, etc. The eFACTS system has over 140 Oracle Forms, over 2500 tables in its main schema, and over a thousand other tables, views indexes for interfacing with integrated systems.
These individuals 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 DEP staff. These positions 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.
Tasks to be accomplished:
- Understand the inner workings of the DEP's eFACTS Application and other 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.
- Meet with end-users on new system requirements
- Generate Requirements, Technical and Business Functional documents, system documents, and assist in creating training and testing 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.
- Provide weekly status updates to BIT team manager or other DEP managers as requested.
- Generate reports as needed for executive management, end-users, and BIT staff
Skill Matrix Form :
| Requirement | Description | Min Requirement/Field of Study |
| 10+ years of relevant experience | Required | 10 Years |
| 4 yr degree or equivalent tech study or adv degree | Required | 4 Years |
| Project Mgmt/Project Lead experience | Required | 5 Years |
| Oracle Database (11G and prior) | Required | 5 Years |
| SQL*Plus | Required | 7 Years |
| PL/SQL | Required | 5 Years |
| Oracle Developer Suite (or previous) | Required | 5 Years |
| TOAD or SQL Developer (or equivalent) | Required | 5 Years |
| Entity Relationship Modeling | Required | 5 Years |
| Experience creating web services | Required | 2 Years |
| Oracle Forms (10G or greater) | Required | 5 Years |
| Strong Communication skills | Required |
|
| Oracle Reports (9i or greater) | Desired | 3 Years |
| Microsoft Team Foundation Server | Desired | 2 Years |
| DEP eFACTS Application Experience | Required | 1 Years |
| Skill | Years Used | Last Used |
| 10+ years of relevant experience |
|
|
| 4 yr degree or equivalent tech study or adv degree |
|
|
| Project Mgmt/Project Lead experience |
|
|
| Oracle Database (11G and prior) |
|
|
| SQL*Plus |
|
|
| PL/SQL |
|
|
| Oracle Developer Suite (or previous) |
|
|
| TOAD or SQL Developer (or equivalent) |
|
|
| Entity Relationship Modeling |
|
|
| Experience creating web services |
|
|
| Oracle Forms (10G or greater) |
|
|
| Strong Communication skills |
|
|
| Oracle Reports (9i or greater) |
|
|
| Microsoft Team Foundation Server |
|
|
| DEP eFACTS Application Experience |
|
|
| Description |
|
| Question 1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? |
| Question 3 | The client is open to in person or web cam interviews for these positions. |
| Question 4 | The position is located in downtown Harrisburg. The selected resource will be responsible for own parking costs. |
| Question 5 | Please provide the candidate email address here. |
| Question 6 | Please ensure the candidate submits the E-RTR following the new process. |
| Question 7 | Three professional references must be provided. Please include name, title, email and phone number. |
| Question 8 | Position is 37.5 hours per week. Please confirm the resource is comfortable with this. |
| Question 9 | This position will extend to 6/30/15. Please confirm the resource is comfortable with the duration. |
------------------------
Thanks & Regards,
Tarun Vohra
Sr. Team Lead
Sage Group Consulting, Inc.
3400 Highway 35, Suite # 9, Hazlet, NJ 07730
Direct Phone: 732-479-1329
Office: 732-767-0010 EXT:210
Fax: 732-479-1329
Email : tvohra@sagetl.com
Website : www.sageci.com
Yahoo IM : tarun.vohra
Gtalk IM : tarun.vohra84
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment