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 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.
* 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:
o Oracle Built-in Packages/Bulk Collect/Insert/Array Processing/Ref Cursors
o Dynamic SQL —literal and bind variables
o Application Tuning
o Creation of scripts to generate views, procedures, functions, triggers, indexes, constraints, and packages
o Data Definition and Transaction Control Language, SQL tuning and Oracle query optimisation
* Oracle 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 level
Employment type: Contract
Job function: Information Technology
Industries: IT Services and IT Consulting
#J-18808-Ljbffr