PL/SQL Developer

Posted 02 September 2024
Salary €400 - €450 per day
LocationDublin
Job type Contract
Discipline Data
Reference109029
Contact NameKatie Southward

Job description

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.