Oracle PLSQL Developer - Dublin

Dublin  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

System Dynamics have an urgent requirement for an Oracle PL/SQL Developer to join client team

Oracle PL/SQL coding in a technical environment including

  • Dynamic SQL -literal and bind variables,
  • Ref Cursors,
  • Oracle Built-in Packages,
  • Application Tuning,
  • Views, Procedures, Functions and Triggers
  • Creation of Index/Trigger/Constraint scripts

Skills Required:

  • SQL tuning and Oracle query optimisation using cost based optimiser and other query optimisation tools
  • Running and interpreting explain plans
  • Building of and maintaining a large scale database in a technical environment
  • Building Context and composite indices
  • Understanding of how Service Requests are raised/resolved with Oracle via Metalink/My Oracle Support
  • SQL tuning and Oracle query optimisation using cost based optimiser and other query optimisation tools
  • Oracle database design & implementation of logical and physical data model
  • Data model creation and maintenance in Oracle Designer
  • DBA routine tasks eg roles, privileges, synonyms, schemas objects, tablespaces across multiple environments
  • Working with Discoverer Reports
  • Working with Oracle Reports
  • Writing complex PL/SQL for Oracle Databases using the following features: XML, materialised views, advanced queuing, dbms_scheduler, UNIX Crontab, database links, blobs, clobs, and Oracle Spatial queries.
  • Writing and execution of unit tests
Start date
Immediate
Duration
6-12 months
From
System Dynamics Ltd
Published at
31.07.2014
Project ID:
751036
Contract type
Freelance
To apply to this project you must log in.
Register