Senior Database Developer

Recruiter
Martin & Conley Limited
Location
London (Greater)
Posted
16 May 2018
Closes
23 May 2018
Contract Type
Permanent
Hours
Full Time

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.


This job was originally posted as www.totaljobs.com/job/81428975

Similar jobs

Similar jobs