I am looking for a Senior Oracle Database Systems Developer to join a great organisation on a 12 Month fixed term Contract. Ideally looking for someone with over 7 years experience who can bring good knowledge and value to this organisation.12 Month ContractStart Date: 4TH May 2025Blended role: Onsite/OffsiteResponsible 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.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 lifecycle, from concept and design to testing.Advise on Oracle features and on best practices in the use of PL/SQL.Responsible for the performance, integrity, and security of a re-architecture and refactoring of legacy systems.Ensure 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.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 CursorsDynamic SQL —literal and bind variablesApplication TuningCreation of scripts to generate views, procedures, functions, triggers, indexes, constraints, and packagesData Definition and Transaction Control Language, SQL tuning and Oracle query optimisationOracle database design & implementation of logical and physical data model.Build and maintain large-scale databases in a development environment.Other Requirements: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.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 levelEmployment type: ContractJob function: Information TechnologyIndustries: IT Services and IT Consulting
#J-18808-Ljbffr