Data Engineer (Applications DBA)
In January 2018 the BBC went live with WhatsOn, the BBC's Broadcast Management System (BMS), this system sits at the heart of how we commission and broadcast most of our TV content. The system allows us to plan, commission, schedule and transmit our television content.
WhatsOn makes the connection between the BBC and our audiences so that we can understand, even better, the relationship between our content and audience.
Our newly created Applications DBA role is to work with the various BMSS delivery project, data architect and TV Business Systems Support (including the NI Support) teams to act as the central hub for managing and supporting the core production / development Oracle databases and environments.
*Please note Applications DBA within the BBC falls within the Data Engineer Job family.
Reporting to the Principle Systems Engineer, this role will work closely with the delivery project technical delivery and TV Business Systems Support teams.
- SQL performance tuning. Create and run repeatable tests. Produce testing summary results
- Recommend Indexing and Statistics based upon performance test results.
- Research, recommend and implement Oracle database recommendations after thorough testing.
- Produce database maintenance scripts, procedures and functions e.g. clear down procs.
- Identify, introduce and improve processes with automation.
- Implement and test database changes in the various Development Database Environments.
- Liaise with Production DBA team to push the changes through the development and Production environments.
- Maintain documentation (via Confluence) and create electronic change controls when required.
- Support environment refreshes, trouble shoot any errors raised by Data Pump imports or exports.
- Raise and maintain Oracle tickets when required.
- Experience of working in a team that delivers an important service
- Work with other team members to build database knowledge
- Develop and implement routine updates
- Evaluate change requests
Are you the right candidate?
To be successful in this role you must have experience of managing Oracle environment instances that support development, testing and training. You should have excellent working knowledge of the functionality and capabilities of Oracle 12c databases. You must have excellent working knowledge of database administration, database management and data manipulation.
Finally you should have experience of creating technical documentation and document version control.
Experience with products below will be advantageous:
Oracle RDBMS 11g/12c, QL, PL/SQL, Oracle Enterprise Manager, Data Guard, Microsoft Windows Server,Database design and performance tuning
Contract type: Continuing
We’re happy to discuss flexible working. Please indicate your choice under the flexible working question in the application. There is no obligation to raise this at the application stage but if you wish to do so, you are welcome to. Flexible working will be part of the discussion at offer stage.
- Excellent career progression – the BBC offers great opportunities for employees to seek new challenges and work in different areas of the organisation.
- Unrivalled training and development opportunities – our in-house Academy hosts a wide range of internal and external courses and certification.
- Benefits- We offer a competitive salary package, a flexible 35-hour working week for work-life balance and 26 days holiday with the option to buy an extra 5 days, a defined pension scheme and discounted dental, health care, gym and much more.
About the BBC
We don’t focus simply on what we do – we also care how we do it. Our values and the way we behave are important to us. Please make sure you’ve read about our values and behaviours in the document attached below.
Diversity matters at the BBC. We have a working environment where we value and respect every individual's unique contribution, enabling all of our employees to thrive and achieve their full potential.
We want to attract the broadest range of talented people to be part of the BBC – whether that’s to contribute to our programming or our wide range of non-production roles. The more diverse our workforce, the better able we are to respond to and reflect our audiences in all their diversity.
We are committed to equality of opportunity and welcome applications from individuals, regardless of age, gender, ethnicity, disability, sexuality, social background, religion and/or belief. We will consider flexible working requests for all roles, unless operational requirements prevent otherwise.
To find out more about Diversity and Inclusion at the BBC, please click here