Role Bluecrest Capital

Bluecrest contract from 1st November 2011 to 31st August 2012

SQL Server DBA

Introduction

************

Wrote backup and restore scripts

In more detail

**************

Wrote backup scripts to run weekly full and daily differential backups.

Wrote restore scripts to restore the most recent backups generated by the backup scripts, to databases of different names on other servers.

This involved reading from file paths to detect the most recent backup files, and accommodating changes in the database file names for restore (the WITH MOVE option).

Scripts to back up and restore database permissions in the database being restored.

Transactional Replication of the Nemo database

Powershell for SQL Server

server-side traces. SQL Agent jobs to run

SSRS - SQL Server Reporting Services. Created a report based on an existing report template, to read from a different database table.

SQL Profiler diagnosis of slow row-by-row cursor-based data load processes, and development of faster bulk loading code.

Clear release and problem descrption documentation, including "before" and "after" configuration for ease of rollbacks.

creation of linked servers

Creation of and assignment of permissions to new accounts

temp table workarounds for unexplained bad query results

Use of OPTION (FORCE ORDER) to change the query plan to be inline with the query definition.

Added database to permissions stored procedure

Parameterisation of dynamic sql to allow optimal query plans to be found and retained.

Moved backup and restore scripts from master to new "msdba" database.

Auditing of failed logins to sensitive servers. Configuration of SSRS report for these.

Diagnosis of a view trigger preventing update to a critical view.

Creation of SSRS database status report showing recent failed SQL Agent jobs, and backups that are not sufficiently current for business requirements.

Resolved critical problem with missing indexes (on Protea) causing a partition switch to fail. This was to switch a table of newly loaded data into a main table.

Specified and documented a SQL Server standard build, including step by step instructions how to install it using the SQL Server installer.

Created database mirroring failure monitoring, using SQL Agent jobs to insert datetimestamp values into tables, and track their progress across the mirror, raising an error if there is a delay.

MySQL backups. Use of mysqldump utility to backup a MySQL database, and take archive copies.

SQL Server performance dashboard reports installation & configuration.

Batch file to run SQL code on several SQL Servers using OSQL.

SQL code redesign for performance optimization.

Up to: 120502_Slow_Q_database_2

SQL Server DBA/Developer, Bluecrest Capital LLC

Development of automated database backup and restore processes.

Design of SSRS (SQL Server Reporting Services) reports and monitoring, for failed SQL Agent jobs, backups out of currency, and unauthorised server logon attempts.

SQL code redesign and development for performance optimization, using server-side SQL traces for investigation.

Planning of database and server infrastructure migration, implementation, and disaster recovery (DR) testing.

SSRS tablix