Oracle Database Developer 5yrs+

3 days ago


Dublin, Dublin City, Ireland PFH Technology Group Full time

I am looking for an Intermediate Oracle Database Systems Developer with 5+ years experience to join a project for a 12-month fixed term contract. We are looking for someone who can add value to the project and can start in May 2025.

  • 12 Month Contract
  • Start Date: 4TH May 2025
  • Blended role: Onsite/Offsite
  • Responsible for designing databases and ensuring their stability, reliability, and performance.
  • Responsible for optimisation of in-application PL/SQL statements as necessary and establishing best practices.
  • Develops new database-centric functionality on existing software products.
  • Create technical and architectural documentation and create technical instructions throughout programme development.
  • Provide expertise in the full development lifecycle, from concept and design to testing.
  • Advising on Oracle features and on best practice and optimal approach in the use of PL/SQL.
  • Responsible for the performance, integrity and security of a re-architecture and refactoring of legacy systems.
  • Ensures that data remains consistent across the database, is clearly defined, users can access data concurrently, in a form that suits their needs and that there is provision for data security and recovery control (all data is retrievable in an emergency).
  • Design schemes, tables, and servers and set permissions for users to access them.
  • Create shell scripts and perform timely backups of all key database systems.
  • Designing and building Oracle database schemas and ensuring their stability, reliability, and performance.
  • Oracle PL/SQL coding including but not limited to:
    • Oracle Built-in Packages/Bulk Collect/Insert/Array Processing/Ref Cursors
    • Dynamic SQL — literal and bind variables
    • Application Tuning
  • Creation of scripts to generate views, procedures, functions, triggers, indexes, constraints and packages.
  • Data Definition and Transaction Control Language, 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.
  • Build and maintenance of large-scale databases in a development environment.

Other

  • Understand Excel spreadsheets manipulation using only PL/SQL (read and write).
  • Ability to manipulate binary files (BLOB) in PL/SQL.
  • Programmatically read and write JSON and XML using only custom PL/SQL (and explicitly not using the built-in Oracle packages/objects).
  • Understanding of Apex Themes, CSS, and UI customisation.
  • Toolset Experience: Oracle 19c, Oracle ORDS, Oracle APEX, Linux, Jira, Confluence, BI Publisher and reports.
Seniority level
  • Mid-Senior level
Employment type
  • Contract
Job function
  • Information Technology
  • Industries: IT Services and IT Consulting
#J-18808-Ljbffr
  • Oracle Database Expert

    17 hours ago


    Dublin, Dublin City, Ireland Expleo Full time

    Oracle Database Expert Wanted:We are seeking a highly skilled Oracle Database Expert to join our team. As a key member of our technology division, you will play a lead role in designing, developing, and maintaining our database systems.Key Responsibilities:Design and develop high-performance database schemas using Oracle (19c)Optimize PL/SQL code for maximum...


  • Dublin, Dublin City, Ireland PFH Technology Group Full time

    PFH Technology Group seeks an experienced Oracle Database Engineer to join our project for a 12-month fixed term contract. As a key member of our team, you will contribute to the design, implementation, and maintenance of databases that support business operations.Key ResponsibilitiesDevelop and maintain database systems to meet business needsCollaborate...


  • Dublin, Dublin City, Ireland Cpl Healthcare Full time

    Job Title: Senior Database Systems DeveloperLocation: IE-D-DublinOverview:We are looking for a Senior Database Systems Developer to play a lead role in software design, architecture, requirements analysis, and software development to deliver support and maintenance of existing applications as well as the development of new...


  • Dublin, Dublin City, Ireland CPL Full time

    Job SummaryWe are looking for a talented Senior Oracle Database Systems Developer to play a key role in the design, architecture, and development of our software applications.Responsibilities:Design and implement databases to ensure stability, reliability, and performanceOrient PL/SQL statements for optimal execution and establish best practicesDevelop new...


  • Dublin, Dublin City, Ireland Vantage Full time

    Job OverviewWe are looking for an Oracle database design expert to join our team. As a senior member of our team, you will be responsible for designing and developing large-scale databases in a development environment.About the CompanyVantage Resources is a leading IT consulting firm that provides innovative solutions to its clients. We are committed to...

  • Oracle SOA Developer

    3 weeks ago


    Dublin, Dublin City, Ireland Oracle Contractors Full time

    Description: Our client is a leading global Oracle Cloud Applications Partner, and they have an excellent opportunity for an experienced Oracle Cloud Developer.The purpose of this role is to provide professional, cost-effective expertise in the delivery of Cloud ERP projects. You will be responsible for the reporting and integration throughout a full life...


  • Dublin, Dublin City, Ireland CPL Full time

    Job Title: Senior Database Systems DeveloperLocation: IE-D-DublinOverview:We are looking for a Senior Database Systems Developer to play a lead role in software design,architecture, requirements analysis, and software development to deliver support andmaintenance of existing applications as well as development of new applications.Responsibilities:•...


  • Dublin, Dublin City, Ireland Oracle Contractors Full time

    Oracle r12 Project Accounting (PA) Functional ConsultantReference: 021077Start Date: ImmediatelyDuration: 26 weeksLocation: Dublin, IrelandJob Type: ContractEngagement Type: Global r12 Project Accounting (PA) implementation.Description: Experienced Oracle Functional Oracle Project Accounting (PA) consultant required to lead key areas of global...


  • Dublin, Dublin City, Ireland Wipro Technologies Full time

    About the Role:We are looking for a highly skilled Oracle Database Admin to join our team. The successful candidate will be responsible for planning, implementing, and managing high availability solutions, including RAC, Golden Gate, and Dataguard setups.The ideal candidate will have extensive experience in Oracle database administration, with a strong focus...


  • Dublin, Dublin City, Ireland Tn Ireland Full time

    About the Role: We are seeking experienced Oracle PLSQL developers to join our team. As a mid-level developer, you will be responsible for working on multiple projects under the guidance of senior developers. Your primary focus will be on developing and maintaining Oracle databases, with an emphasis on ensuring data integrity and security. The ideal...

  • Oracle Developer

    1 week ago


    Dublin, Dublin City, Ireland Nicoll Curtin Full time

    Direct message the job poster from Nicoll CurtinAssociate Director - Technology RecruiterOracle Developer12 month contractOur client, a leading financial services company located in Dublin, is looking for an Oracle Developer to join their team.You will contribute to a variety of projects, with a primary focus on data engineering, including extensive Oracle...


  • Dublin, Dublin City, Ireland Wipro Technologies Full time

    Job Description:The Oracle Database Admin will be responsible for designing, implementing, and managing high availability solutions, including RAC, Golden Gate, and Dataguard setups.Key Responsibilities:Manage large database estatesInstall and administer multiple versions of databases on various platformsDesign high availability solutionsConfigure and manage...


  • Dublin, Dublin City, Ireland IT Search Full time

    Job DescriptionAs a Senior Oracle Developer, you will be responsible for developing and optimizing large-scale Oracle databases using PL/SQL.You will implement indexing, partitioning, and performance tuning strategies to ensure robust solutions.We use CI/CD tools like Git, Jenkins, and Ansible.Key requirements include extensive Oracle PL/SQL experience,...

  • Software Developer 3

    2 weeks ago


    Dublin, Dublin City, Ireland Oracle Full time

    The MySQL HeatWave and Advanced Development team is responsible for the massively parallel, high performance, in-memory query accelerator for Oracle MySQL Database Service that accelerates MySQL performance by orders of magnitude for analytics and mixed workloads. HeatWave is faster than Amazon Redshift at half the cost, 7X faster than Snowflake at...

  • Oracle Developer

    3 weeks ago


    Dublin, Dublin City, Ireland Reperio Human Capital Full time

    Oracle Developer 97972 Desired skills: Oracle, Database Developer, Contract A new opportunity has opened up for an Oracle Developer to join my client, based in Dublin, Ireland. This is an initial 6-month contract with great potential to extend beyond. This role is hybrid , and you must be based in Ireland. Oracle Developer Required...


  • Dublin, Dublin City, Ireland Vantage Full time

    Direct message the job poster from Vantage12 month contract, extended up to 3 yearsHybrid – 2x a week on client site in DublinThe following non-exhaustive list of Key Deliverables applies to this Role:Design, develop, and maintain databases ensuring stability, reliability, and performance.Optimize in-application PL/SQL statements as needed and establish...


  • Dublin, Dublin City, Ireland PFH Technology Group Full time

    The successful candidate will have a deep understanding of Oracle Database architecture and a proven track record of delivering high-quality database solutions. You will work closely with our development team to design and implement databases that meet business requirements.Key ResponsibilitiesDesign and implement database schema changes to support business...


  • Dublin, Dublin City, Ireland Sigmar Recruitment Full time

    About Your New Employer Join a leading consultancy working onsite with public sector body as a Senior Data Base Developer to be a part of a high-performance team working on key business deliverables coordinating the efforts and releases of multiple systems teams with interdependencies to deliver a seamlessly integrated solution to our customer About Your New...


  • Dublin, Dublin City, Ireland Tn Ireland Full time

    Job DescriptionWe are seeking a highly skilled Development DBA to join our team at Tn Ireland. As a Development DBA, you will be responsible for designing and building database schemas, developing and optimizing PL/SQL statements, and assisting in DevOps and continuous integration.Responsibilities:Design and develop database solutions that meet business...


  • Dublin, Dublin City, Ireland Cpl Healthcare Full time

    Cpl Healthcare is looking for an experienced Oracle Development Expert to lead the development of our database-centric software products.The successful candidate will be responsible for designing databases, optimizing PL/SQL statements, developing new database functionality, creating technical documentation, and providing expertise throughout the development...