As a Database Architect with commercial experience of OOA, design and development, TDD, RDBMS and high performance systems, coupled with experience of diagnosing and fixing problems with highly available, high-volume, resilient MySQL instances as well as experience of providing technical leadership, you will be in your element in our Publishing Services team, a world-class team responsible for delivering the next-generation of online services. Publishing Services is part of our Programmes and On Demand (POD) department, which is in turn part of our Future Media (FM) division.
In your role you will offer analysis, design and system performance tuning to support the range of databases (particularly MySQL) that drive the Metadata Publishing and Serving systems of Publishing Services. You will have technical design and development responsibilities for the Publishing Services Databases underpinning the provision of metadata to the iPlayer website as well as a portfolio of online media outlets across bbc.co.uk.
In return we offer you the opportunity to inform the technical direction of projects that push the boundaries of the BBC’s online presence and be directly involved in introducing innovation and excellence into the BBC.
The role requires an excellent knowledge of relational database theory and design applied to a high-volume real-world context. Particular knowledge of MySQL is required, and you will work closely with Software Engineers (Java, Perl) to design high-performing MySQL schemas and queries. You will also work with operational DBAs and Technical Architects to provide solutions to the architectural issues inherent in any highly available, resilient MySQL installation. Finally, you will be expected to contribute to Java and/or Perl code bases, implementing database driven features and improvements to a range of products. You will deliver relational and non-relational database best-practice and innovation. To provide technical leadership to the Software Engineering team within Publishing Services, the wider FM department and key external suppliers
Essential Experience
1. Commercial experience of: Object-oriented analysis, design and development, test driven development, relational database systems, high performance systems.
2. Experience of diagnosing and fixing problems with highly available, high-volume, resilient MySQL instances.
3. Experience of working closely with Software Engineering teams throughout the development timeline.
4. Experience of one or more ORMs (e.g. Hibernate, DBix::Class, MyBatis).
5. Application of principles of Normalisation and DeNormalisation to commercial database design.
6. Experience of using Tomcat, Spring Framework, Hibernate and Maven2.
7. Significant and demonstrable Java development experience, including using a JPA and JTA.
8. Demonstrable experience of implementing Java best practice – especially around scalability and performance of web-services.
9. Must have an enquiring mind with well-developed analytical and investigative skills.
10. Be self-motivated with drive and good organisational skills to work to challenging deadlines.
11. An ability to rapidly and effectively understand and translate product and business requirements into technical solutions.
12. Experience of working with 3rd party vendors and development teams.
13. Proven experience of project working and commercial development processes - particularly Agile methodologies.
14. Experience of working in an environment where products have to be delivered to specific time-scales.
15. Experience of supporting, modifying and maintaining systems and code developed by teams other than your own.
16. Experience of working with code repositories (e.g. Git, SVN), bug tracking tools (e.g. Jira, Bugzilla) and Wikis (e.g. Confluence).
To apply, please click on the Apply button to be redirected to the BBC website.
Closing date: 23 October 2011.