SQL Server Development DBA

Wunderman Thompson

Department: Technology

Expertise: Technology

Location: England, United Kingdom

Who we are:

At Wunderman Thompson we exist to inspire growth for ambitious brands. Part creative agency, part consultancy and part technology company, our experts provide end-to-end capabilities at a global scale to deliver inspiration across the entire brand and customer experience.

We are 20,000 strong in 90 markets around the world; our people bring together creative storytelling, diverse perspectives, inclusive thinking, and highly specialized vertical capabilities to drive growth for our clients. We offer deep expertise across the entire customer journey, including communications, commerce, consultancy, CRM, CX, data, production, and technology.

Who we are

WPP is the global leader in marketing and communications services and one of the world’s largest creative transformation companies.

WPP has created a start-up in the end-to-end Commerce space, Everymile. We are building out a business with a ground-breaking offering that none of our Agency Network competitors have managed to launch into yet.

Within Everymile, we are leveraging WPP’s strength in consumer demand generation, best in class commerce technologies and leading external partnerships to deliver for clients a fully managed commerce service. The service will incorporate the design, build and operation of omni channel digital commerce; everything from website development to supply chain and fulfilment.

Want to find out more about us? www.everymilecommerce.com www.cloudcommercepro.com 

Role

We have a strong C#/.Net development team who’ve been administering our database on an
ad-hoc basis. Last year we engaged with a Managed Service Provider to provide out of
hours support and monitoring. We’re now looking for someone to join the development team
as a Development DBA to help us put some more rigour around our database procedures.
You will be working for the Software Engineering Manager, and working closely with the
development team, to achieve the following goals:


Short term:

● Identify and optimise expensive queries (CPU, IO, Waits)
● Introduce controls for schema changes
● Audit roles and users

Mid/Long term:

● Clean up a large number of questionable UDFs and SPROCs
● Support the developers in migrating from a monolithic application to discrete services
● Automated archiving and purging of data

Required skills:

● On-prem SQL Server 2016
● T-SQL
● Stored Procedures
● User Defined Functions
● Always On Availability Groups
● Query plan analysis
● Index optimisation
● Schema versioning/migration
● Large (>1 terabyte) databases

Desirable skills/Opportunity to learn:

● SentryOne SQL Server monitoring
● VMWare
● Linux
● MySQL
● Other technologies, e.g. redis, message queues

At Wunderman Thompson, we are committed to actively building a diverse, equitable and inclusive workplace where everyone feels welcomed, valued and heard, and is treated with dignity and respect.  As leaders and creative partners across industries, it is our responsibility to cultivate an environment reflective of our greatest asset; our people. We believe that this commitment inspires growth and delivers equitable outcomes for everyone as well as the clients and communities we serve.

Wunderman Thompson is a WPP agency.  For more informationplease visit our website and follow Wunderman Thompson on our social channels via Twitter, Facebook, LinkedIn, and Instagram.  

We rely on legitimate interest as a legal basis for processing personal information under the GDPR for purposes of recruitment and applications for employment. 
When you click the "Submit Application" button above, this will send all the information you have added above to Wunderman Thompson. Before you do this, we think it's a good idea to read through our Privacy Policy. This explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.