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 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.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 CursorsDynamic SQL — literal and bind variablesApplication TuningCreation 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.OtherUnderstand 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 levelMid-Senior levelEmployment typeContractJob functionInformation TechnologyIndustries: IT Services and IT Consulting
#J-18808-Ljbffr