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 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
A Bachelors 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 - preferred
Web Services
JAVA
PL/SQL API
SOA
Agile /Scrum Development methodologies
Installation of Oracle software like Oracle forms and reports