Job Title: Oracle Developer (Senior)

Location: Athlone Will require to attend the office on the days that there will be IT Team/Business Units meetings/workshops. The first 2 months on boarding will require more frequent days on site. Thereafter 1 day per week minimum on site is required.)

Contract / Permanent: 12 Months with further extension.

Role:

The client seeks the provision of a Senior Oracle Developer specialist to work on the client Payroll Oracle applications and Pensions applications. The Oracle Developer will be responsible for the support and maintenance of these applications along with smaller oracle applications.

Experience Level Required:

It is a mandatory requirement that the Resource proposed has the equivalent of Senior i.e. >7 years experience as an Oracle Developer including experience in the following:

Advanced PL/SQL (7 years experience)

Oracle Development Toolkit

Oracle Forms and Reports

Key Deliverable:

The following nonexhaustive list of Key Deliverables are applicable to this Role.

Facilitating the achievement of goals established for the projects to which assigned.

Lead on ensuring robust documentation is in place and updated for key business critical customized database routines including clear data lineage for origins of data inputs and also clear code commentary where customized logic has been applied.

Assisting with database design and implementation.

Development and maintenance of PLSQL database objects employing local standards on an ongoing basis to support development teams across the Department.

Troubleshooting and resolving database problems including database tuning.

Determination of any shortcomings of database system and recommend improvements.

Advising developers on best practice and optimal approach in the use of PL/SQL.

Provision of support for data analysis and datadriven decisionmaking.

Completing assigned tasks related to phases of development lifecycle of enterprise applications within given scope and timeframe requirements.

Developing customized reports.

Mentoring and facilitating skills transfer to Department staff.

Any other tasks which are considered by the Department to be appropriate to their role.

Key Experience/Competencies/Skillsets:

The following Experience/Competencies/Skillsets are applicable to this Role.

TOTAL 650 MARKS

1. Experience in the development and maintenance of PL/SQL packages making full use of the latest features of PL/SQL with specific emphasis on advanced PL/SQL. As part of the response Tenderers must include a minimum of one example. (200 Marks available Minimum 120 marks required)

2. Demonstrate indepth knowledge of Oracle Forms/Reports including the creation/modification of forms and also the management of forms server configuration files and the installation of forms. As part of the response Tenderers must include a minimum of one example. (200 Marks available Minimum 120 marks required)

3. Demonstrate knowledge of Linux & Windows Operating Systems including batch scripting as part of the response Tenderers must include a minimum of one example. (100 Marks available Minimum 60 marks required)

4. Demonstrate knowledge with SQL Developer. As part of the response Tenderers must include a minimum of one example. (50 Marks available Minimum 30 marks required)

5. Demonstrate experience in skills transfer in relation to Oracle forms reports and PL/SQL. As part of the response Tenderers must include a minimum of one example. (50 Marks available Minimum 30 marks required)

6. Demonstrate approach to effectively documenting code to ensure code maintainability readability and overall risk reduction on single resource reliance. As part of the response Tenderers must include a minimum of one example (50 Marks available Minimum 30 marks required)