PL/SQL Developer
ASAP Start
12 months
Dublin - 1- 2 days onsite
€400 - €450
My client is looking to hire a highly skilled PL/SQL Developer to join their project team.
The successful candidate must have previous hands-on reporting experience with BI Publisher.
Key Responsibilities:
- Design and build complex SQL queries for business reporting and data analysis.
- Conduct source system analysis to link and join tables for report generation.
- Develop and maintain large-scale databases in a development environment.
- Leverage Oracle Built-in Packages, Bulk Collect, Insert, Array Processing, and Ref Cursors.
- Utilise Dynamic SQL with literal and bind variables for optimisation and flexibility.
- Create scripts for views, procedures, functions, triggers, indexes, constraints, and packages.
- Generate reports using Oracle Forms, Oracle Reports, Discoverer, and BI Publisher.
- Handle Data Definition and Transaction Control for efficient database operations.
- Perform SQL tuning and query optimisation using Oracle's cost-based optimiser and other tools.
- Oversee Oracle database design, implementing both logical and physical data models.
Skills Required:
- Strong hands-on experience with PL/SQL, including writing complex queries and optimising SQL code.
- Proficiency in Oracle database design and data modeling.
- Experience with BI Publisher and generating business intelligence reports.
- Knowledge of Dynamic SQL, transaction management, and SQL tuning.
- Ability to manage stakeholder relationships and effectively translate technical requirements into deliverables.
- Comfortable with source code management tools like SVN.