Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 21st Sep 2021
- 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
Required Skills:
• 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
Desired Skills:
• Understating and have exposure of the following technologies:
o XML,
o HTML,
o APEX,
o Web Services
o JAVA
o PL/SQL API
o SOA
o Agile /Scrum Development methodologies
• Installation of Oracle software like Oracle forms and reports