Location: Athlone. Attendance at the office is required on days with IT Team/Business Units meetings/workshops. The first 2 months of onboarding will require more frequent on-site days. Thereafter, a minimum of 1 day per week on-site is required.
Contract / Permanent: 12 Months with further extension.
Role:
The client seeks a Senior Oracle Developer specialist to work on the Payroll and Pensions Oracle 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 mandatory that the proposed resource has the equivalent of Senior experience, i.e., >7 years as an Oracle Developer, including:
1. Advanced PL/SQL (7 years’ experience)
2. Oracle Forms and Reports
The following non-exhaustive list of Key Deliverables are applicable to this Role:
1. Facilitating the achievement of goals established for the projects to which assigned.
2. 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 clear code commentary for customized logic.
3. Assisting with database design and implementation.
4. Development and maintenance of PL/SQL database objects employing local standards on an ongoing basis to support development teams across the Department.
5. Troubleshooting and resolving database problems, including database tuning.
6. Determining any shortcomings of the database system and recommending improvements.
7. Advising developers on best practices and optimal approaches in the use of PL/SQL.
8. Providing support for data analysis and data-driven decision-making.
9. Completing assigned tasks related to phases of the development lifecycle of enterprise applications within given scope and timeframe requirements.
10. Mentoring and facilitating skills transfer to Department staff.
11. Any other tasks considered appropriate to their role.
The following Experience/Competencies/Skillsets are applicable to this Role:
TOTAL – 650 MARKS
1. Experience in the development and maintenance of PL/SQL packages, with emphasis on advanced PL/SQL. Tenderers must include a minimum of one example. (200 Marks available - Minimum 120 marks required)
2. In-depth knowledge of Oracle Forms/Reports, including creation/modification of forms and management of forms server configuration files. Tenderers must include a minimum of one example. (200 Marks available - Minimum 120 marks required)
3. Knowledge of Linux & Windows Operating Systems including batch scripting. Tenderers must include a minimum of one example. (100 Marks available - Minimum 60 marks required)
4. Knowledge with SQL Developer. Tenderers must include a minimum of one example. (50 Marks available - Minimum 30 marks required)
5. Experience in skills transfer related to Oracle forms, reports, and PL/SQL. Tenderers must include a minimum of one example. (50 Marks available - Minimum 30 marks required)
6. Approach to effectively documenting code to ensure maintainability, readability, and overall risk reduction on single resource reliance. Tenderers must include a minimum of one example. (50 Marks available - Minimum 30 marks required)
#J-18808-Ljbffr