Oracle Developer - 12 month FTC

Overview

Music wouldn't exist without the work of songwriters, composers and publishers.

We're here to represent them and ensure that they are rewarded for their creations.

Over a century in the making, we are a global leader in the industry and always take centre stage.

The Role

PRS is looking for an enthusiastic and experienced developer to join the Distribution Services Delivery Domain.

Our Distribution Services products are Oracle cloud-based applications that support the royalty distribution value stream, helping to ensure our members are paid accurately.

In this role, you will work within a dynamic, multi-disciplinary squad, delivering change and supporting applications built on Enterprise Edition Oracle Databases, Oracle Fusion Middleware, and PL/SQL.

You should be an experienced Oracle PL/SQL engineer with strong analytical and problem-solving skills, as well as proven experience working with complex PL/SQL data processes for large-scale custom applications.

Responsibilities

• Develop an understanding of business processes, objectives, solution requirements, application processes, and performance needs.
• Participate in project, enhancement, and BAU initiatives, working with subject‑matter experts to understand specific requirements.
• Work within an Agile Scrum sprint team and collaborate closely with Technical Leads, Senior Engineers, QA, and Business Systems Analysts, contributing to effort estimation activities.
• Focus on product backend development, implementing new features and enhancing existing functionality.
• Collaborate with stakeholders to support development and testing activities.
• Support production applications by investigating and resolving production issues and inquiries.
• Use your development skills to improve the efficiency, scalability, stability, and maintainability of systems and their components.
• Promote and continuously improve technical standards and development best practices.
• Provide occasional support outside of standard business hours when required.

About you

At PRS for Music, we want you to bring the best version of yourself to work every day. Along with being whoever you want to be, you will also have…

Essential

• Several years’ experience with high volume Oracle RDBMS Databases and Fusion Middleware
• You are an expert Oracle PL/SQL developer able to implement complex database programs including packages, procedures, functions, triggers, cursors, views, materialized views, collections, bulk processing, dynamic SQL, parallel processing.
• Demonstrable software development experience.
• You can develop complex PL/SQL data processes for large scale custom applications with robust error handling.
• Experience writing complex & optimal SQL Queries.
• Excellent problem diagnosis and analytical skills.

Desirable

• Knowledge of Oracle RDMS database architecture on the Cloud
• You have a solid experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables as well as SQL tuning and optimization of newly developed and existing applications.
• Oracle 19c Enterprise Edition on Exadata Platform
• Performance Tuning & Data Warehousing
• Multi-Terabyte Databases (VLDBs)
• You have BSc degree in Computer Science or Engineering or a equivalent qualification.

What’s in it for you?

• We trust, value, and support our people to make the difference
• We believe that diversity of thought and experience provides the platform for innovation and creativity
• We are consciously inclusive and have 7 Affinity Groups which you can join and make an impact – LGBTQ+, Mental Health, Parents & Carers, Ethnicity, Gender, Disability (including neurodiversity) and Social Economic.
• Our Benefits
• We invest in the development of our people to drive our ambitions forward
• Our Rhythm allows for flexibility at the start, middle and end of your working day
• We offer hybrid working, allowing you to work remotely and from our London Bridge Hub
• We know time to rest and recharge is important therefore we offer 25 days holiday entitlement with the option to top up twice annually up to a maximum of 30 days
• Work from anywhere in the world, for up to 8 weeks of the year
• We offer a range of family friendly leave including enhanced maternity & paternity, grandparent, fertility, reproductive and menopause support.
• A whole range of other benefits, including retail discounts, time off to volunteer with our charity partners, gym discounts and the option to spread the cost of your travel into the office via a season ticket loan or bicycle loan.
• Location

Our London Bridge Hub is based within Hays Galleria and overlooks the River Thames.

When you see the view, we are sure you will want to join us in our collaborative working space!

We offer a hybrid working model, allowing employees to work from home for up to 3 days per week.

To ensure the health & safety of all our employees, if you wish to work from home for more than 2.5 days per week, we will conduct a quick and easy remote-working assessment.

Equal Opportunity Statement

At PRS we are committed to equity, diversity, inclusion and belonging for all.

We have taken a holistic approach to ensure that no one feels excluded regardless of age, class, sexuality, gender, race, religion, or ability.

We value the needs of everyone in our organisation and strive to build an environment where our employee’s contributions are recognised in order that everyone may thrive.

#J-18808-Ljbffr