Oracle Database Engineer

Who We Are We're Future, a global leader in specialist media. Our people bring our trusted brands to life, helping millions of people discover expert content that informs, inspires, and drives action. As a pioneering multiplatform media powerhouse, we provide expert content and technology that build valuable communities across all channels. The Circulation Tech team of 9 consists of Project Managers, Business Analysts, BI and ORACLE and Software Engineers. Additionally, the team is the conduit for Infrastructure/ Networks based projects, working closely with an extended team to manage and deliver change through to Marketforce and its applications. The team works closely with other partners: Future colleagues such as the Finance (NetSuite) team, Editorial, Production, Tech & Engineering teams Marketforce partners such as 3rd party (non-Future) publishers, wholesalers, retailers, carriers, International distributors What You'll Do Within Future, Marketforce is the business unit focused on Circulation Newsstand in the UK and globally. With more than 30 years of experience, Marketforce leads the way in magazine distribution, global sales and marketing for a wide range of publishing partners, which includes the Future portfolio. It is the #1 magazine distributor, distributing over 200 million copies worldwide each year. The Marketforce applications are bespoke and purpose-built, on the foundations of Oracle (19c)/ ORACLE Forms, ORACLE APEX 24.2, and WebLogic 12.2.1.3.0 and Microsoft .NET technologies, using both waterfall and agile methodologies. The exception is our BI reporting tool, Business Objects XI (BOXI) , a proprietary SAP product. Developer tools and supporting products exist which are used to aid the ongoing development of the applications. Underpinning the applications is a suite of ORACLE distributed 19c databases, hosted on multiple ORACLE Data Appliance hardware. Reporting to Database Manager, this position requires the individual to become the ORACLE PL/SQL and ORACLE APEX 24.2 technical expert for applications, BAU delivery, enhancements, developments and the primary contact for the business. Each engineer also has to provide secondary cover for other applications based on their technology experience What You'll Bring Shown experience in database development using Oracle PL/SQL Strong SQL writing skills and data analysis using SQLPlus/ Toad/ SQL developerExperience writing complex and optimal SQL queriesExperience in debugging and performance tuning PL/SQL code Experience in Oracle Forms 12c (Oracle Fusion Middleware) Experience with ETL processing, data extraction, transform and load Working knowledge of partitioning and materialised viewsMust have experience of working in support environment with good problem solving and analytical skillsMust show fluency in working within standard procedures and within a project life cycleMust have knowledge of database best practicesKeen interest of database development using OracleKeen in understanding the workings of an application What We Offer Uncapped leaveEnhanced parental leaveDiscounted rates with Dental care and Private Medical careWhen we hit our targets, enjoy a share of our profits with a bonusRefer a friend scheme - with payment following the successful hireWell-being support with access to our Colleague Assistant ProgrammesOpportunity to purchase shares in Future, with our Share Incentive PlanSalary sacrifice Pension scheme up to 5% matchFree drinks and snacks in our offices The expected range for this role is £50,000 - £55,000 This is a hybrid role, working two days per week from our London Paddington office on Mondays and Wednesday Internal job family level Technology 6 Inclusion and Diversity at Future At Future, we're working to attract, retain and foster diverse talent, educating our colleagues in the importance of diversity, and review our internal processes so that they remain as free from bias as possible. We recognise that, in order to reach diverse communities through our content, we must first ensure ours is a culture in which diversity can thrive. Find out more about Our Future, Our Responsibility on our website. If you need any reasonable adjustments, please let us know and we'll be happy to support you.