Oracle Database Engineer

United States Digital Space LLC; Greater London; On-site; GBP 50,000 - 55,000; Full time

Benefits offered by this job

Uncapped leave

Enhanced parental leave

Share of profits when targets hit

Private medical care

Job summary

Future, Marketforce division, seeks an experienced Oracle PL/SQL developer to join the Circulation Newsstand team in the UK. You will develop database code, write complex SQL, optimize performance and support BI reporting on an Oracle-based stack (Forms 12c, APEX 24.2, WebLogic).

Reporting to the Database Manager, this hybrid London role requires collaboration with Finance, Editorial and Tech, and offers uncapped leave and a generous benefits package.

Qualifications

• Strong SQL and PL/SQL skills required.
• Experience with Oracle Forms/ APEX is a plus.
• Experience in debugging and performance tuning PL/SQL.
• Experience with BI reporting (BOXI) is advantageous.

Responsibilities

• Develop database code using Oracle PL/SQL.
• Write complex SQL queries and optimize performance.
• Support ETL and data extraction/transform/load processes.
• Collaborate with BAU delivery and roadmap enhancements.

Skills

SQL querying

Data analysis

PL/SQL debugging

Performance tuning

Project lifecycle

Tools

Oracle Forms 12c

Oracle APEX 24.2

WebLogic 12.2.1.3.0

BOXI / Business Objects

Toad

SQL Developer

Job description

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 developer
• Experience writing complex and optimal SQL queries
• Experience 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 views
• Must have experience of working in support environment with good problem solving and analytical skills
• Must show fluency in working within standard procedures and within a project life cycle
• Must have knowledge of database best practices
• Keen interest of database development using Oracle
• Keen in understanding the workings of an application

What we offer

• Uncapped leave
• Enhanced parental leave
• Discounted rates with Dental care and Private Medical care
• When we hit our targets, enjoy a share of our profits with a bonus
• Refer a friend scheme - with payment following the successful hire.
• Well-being support with access to our Colleague Assistant Programmes
• Opportunity to purchase shares in Future, with our Share Incentive Plan
• Salary sacrifice Pension scheme up to 5% match
• Free 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.

#LI-Hybrid

#LI-HLK1