Oracle Developer - 12 month FTC

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., 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., * 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.

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., * 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.

Pulled from the full job description

• Employee discount
• Paid volunteer time
• Season ticket loan
• Work from home
• Discounted gym membership

We know that the world isn't always ideal, so please don't rule yourself out if you have other qualities to bring to the party. What's in it for you? Joining the band here at PRS for Music is so much more than just a day job! Below are just a few notes that set us apart from the crowd. * 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. The Process Our interview process for this role is simple and as follows: * First stage interview virtually on MS Teams. * Second stage interview in person at our London Bridge Hub. We use competency-based questions within our interviews. This allows you to provide examples of situations where you have had to demonstrate the required skills relevant to the role you are applying for. To assist your preparation for interview, research the STAR method to aid bringing your examples to life. 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.