SQL Server DBA/Dev (T-SQL, SQL Server and SSIS)

at 7digital in London

Our Data team is looking to add a smart, all-round Database Administrator to maintain and develop the databases that sit at the heart of 7digital’s entertainment empire. The successful candidate will support our team of developers, reporting/BI developers, and operations teams in finding and implementing solutions to keep 7digital at the cutting edge.

Your primary focus will be on the maintenance and development of B2B and B2C digital media services - including download, streaming and radio streaming models - within a fast-changing industry.


You

Problem-solving and helping to find durable, pragmatic ways forward - short-term and long-term - is key, so getting on well with people and displaying a positive attitude to tackling tasks is essential. You care about working hard, taking personal responsibility for your contributions, while also buying into a team ethos based around adherence to high standards, best practices, sharing knowledge and mutual support. Whether you’re approaching a new technology or performing a basic assignment you’ve encountered many times before, you apply yourself thoroughly and with integrity.

You will find working in a hectic industry invigorating (rather than infuriating!) and demonstrate a passion for music, video, digital media and a healthy knowledge of the entertainment business.


Us

• 7digital Ltd. is a leading digital media delivery company based in London and operating globally.
• We provide digital services to over 500 partners including Musical.ly, i.am.+, HMV, Technics, Universal Music, Warner Music, Sony and have delivered millions of digital products in over 37 countries.
• With the growth of popularity of streaming services, over 15 million customer now use our services each week. We’re logging millions of streams every day at a rapidly increasing rate. That’s plenty of data to be looking after.
• We have exceptional relationships within the music industry; we have a fully licensed catalogue of over 50 million tracks, giving us the broadest reach in the world.
• We have a culture that finds time for both hard work and creative expression and we care about the people we work with.



The Role

We’re looking for someone with a solid background in T-SQL and MS SQL Server - preferably SQL Server 2014 and/or 2016 - who is comfortable working across multiple databases, servers and environments.

You will demonstrate the ability to interpret and enhance monitoring, identifying server and database performance issues. You will head-off potential issues before they become problems, and deal with unanticipated situations in a timely and apposite fashion, calling on a cool poise when under pressure.

You will be able to write T-SQL code that is clean, efficient and rigorously tested to function accurately and optimally. You will be proficient in interpreting existing SQL code and SSIS packages and diagnosing any problems contained therein. You will be capable of working with stakeholders to create business requirements that are concise and unambiguous, and deliver robust solutions to meet them.

Key requirements for the role include:

• Database and server maintenance, including security, backups, upgrades, monitoring and High Availability.
• Superior SQL Developer skills
• Performance tuning and query optimisation with a comprehensive understanding of indexes and query plans.
• Understanding of best practices in database architecture, including appropriate deployment of data types, keys and constraints.
• Managing transactional replication
• Troubleshooting and creating SSIS packages, notably to support ETL processes.

There is scope to participate in the team’s engagement with progressive and complementary technologies - e.g., cloud computing, other SQL languages (e.g. Postgres), the Apache Kafka platform - and delivering BI objectives. Exposure to these areas would be welcome, though the core of this role will be working with Microsoft SQL Server and T-SQL.

7digital is a global enterprise, and digital entertainment never sleeps, so you will be expected to provide support outside of UK business hours as necessary.

We are a very collaborative organisation that utilises Agile methodologies in our day-to-day working environment. Familiarity with this kind of working environment and being happy to work in this manner is highly beneficial.
Skills
• MS SQL Server
• T-SQL
• SQL Server Integration Services (SSIS)

You MUST be eligible to live and work in the UK to be considered for this role

NO AGENCIES PLEASE

« Go back to category
Is this job ad fake? Report it!   
Published at 22 Dec 2016
Expires on 22 Feb 2017
Viewed: 331 times