Senior Database Developer

Posted 26 February by Martin & Conley Easy Apply

Senior Database Developer

We are looking for a Senior Database Developer to join and exciting media agency on a permanent basis in central London.

As the Senior Database Developer you will own and develop 2 large MS SQL database servers as well as create, maintain and enhancements dataflow processes and system integrations. For this you will need to have excellent Transact-SQL, proven DB optimisation proficiency and effective DB security implementation experience.

Senior Database Developer Main Job Functions:
* Create, maintain, improve and monitor various ETL processes through T-SQL
* Create and maintain database objects (incl. databases, tables, indexes, stored procedures, triggers, SQL Agent Jobs) using MS SQL Server 2014+ Enterprise Edition
* Performance Tuning and Optimization: interpreting query execution plans, indexing strategies, transaction management, locking and blocking, data compression, partitioning
* Ensure that T-SQL code meets company standards for readability, reliability, and performance
* Work with SolarWinds (or similar database monitoring software) to trace and monitor database performance issues
* Work with external development teams to ensure effective DB structure and query design
* Develop and enhance reports
* Create, monitor and manage server ACL and privileges for website, process and vendor integrations
* Maintain data security and recovery control (all data is retrievable in an emergency)
* Manage Linked Server integrations
* Train and assist data analysts on T-SQL best practice
* Monitor and assist with AWS cloud database infrastructure
* Maintain the company's database environment documentation
* Upgrade, install and configure new SQL Servers

Senior Database Developer Required Skills:
* MS SQL Enterprise 2014+
* Strong Transact SQL (SQL 2014+) (5 years+)
* Very strong trouble-shooting and insight abilities
* Experience using profiler to optimise SQL queries and processes
* DB Optimisation Experience and Confidence
* Familiarity with Business Intelligence Stack: SSIS, SSRS and data warehouse technologies
* MS SQL Server management experience
* MS SQL DB security assurance and credential manager experience
* Strong Communicator
* Strong Organisational Skills

Preferred Skills
* Media Advertising Industry Experience
* Experience with SolarWinds DB Performance Analyser (or similar)
* MS SQL experience with big datasets (3 billion records+ per table)
* MySQL experience (2 years+)
* Experience with Google Big Query or AWS Redshift

If you have the desired skills and experience and would be interested in finding out more please respond to this advert by following the link below and attaching a copy of your most recent CV. If successful I will be in touch to discuss the role in more detail.

Required skills

  • ETL
  • Performance Tuning
  • SSIS
  • Stored Procedures
  • SSRS
  • T-SQL
  • SQL Server
  • Triggers

Reference: 34555220

Bank or payment details should not be provided when applying for a job. is not responsible for any external website content. All applications should be made via the 'Apply now' button.

Report this job