Oracle Developer/DBA 12 month contract Dublin city centre/Hybrid Our high profile client based in Dublin city centre is actively seeking an experienced Oracle DBA with 4+ years of experience to join their team. Responsibilities: Responsible for implementing databases and ensuring their stability, reliability, and performance. Responsible for optimisation of in-application PL/SQL statements as necessary and establishing best practices. Develop 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 of lifecycle, from concept and design to testing Advising on Oracle features and on best practice and optimal approach in the use of PL/SQL 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. Skills required Designing and building Oracle database schemas and ensuring their stability, reliability, and performance. Oracle PL/SQL coding Oracle Built-in Packages/Bulk 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 largescale databases in a development environment Ability to manipulate binary files (BLOB) in PL/SQL Programmatically read and write Json and XML using only custom PL/SQL. Knowledge of JavaScript, application processes and Ajax Understanding of Apex Themes, CSS, and UI customisation Toolset Experience Oracle 19c Oracle ORDS Oracle APEX Development and Reporting Linux Jira BI Publisher and Reports Confluence Skills: Oracle DBA Oracle PL/SQL Oracle 19c Apex Oracle ORDS