Mark Blakey Email & Phone Number

• Providing Sql Server Consultancy Services to various clients including:
• RBI
• Calastone
• OCS
• Kinetic InsuranceWork entailed multiple Sql Server Consolidation projects, Performance tuning, Business Intelligence, Data Migration, System Scalability, Disaster Recovery, Sql Server Upgrades and on site training.

• Responsible for consolidation of distributed Sql Server environment onto Sql Server 2008
• Architecture of end to end Business Intelligence solution using SSIS, SSAS, SSRS and SharePoint, implementing scale out architecture on all service tiers.
• Implementation of Kerberos Security configuration across Sql Server & BI stack
• Design and implementation of robust Disaster Recovery (DR) and High Availability (HA) configuration across nationwide WAN.
• Documentation and Training of Permanent Sql Server Staff
• SharePoint development and administration

• Database Administration of multiple high availability databases predominantly in a web based environment.
• Configuration and maintenance of Magazine Jobs Advertising platform across multiple publications
• Implementation of first generation of Peer to Peer replication in a high revenue website environment.
• Troubleshooting replication (Merge, Transaction and Peer to Peer) and DTS\SSIS production issues
• System Performance tuning
• Database migrations and upgrades from Sql 2000 to Sql 2005. Consolidation on 64 bit Unisys platform

• Responsibile for the administration and development of MI systems. Ownership of Master Data Management System (MDMS) and overall data strategy within Virgin Holidays and Virgin Incoming Services (VIS).
• Database Administration of 25 Sql Servers running Virgin Holidays applications
• Support and development of Sql Server replication (Merge and Transaction)
• Support and development of all SSIS ETL packages used for nightly refresh of data warehouse
• Introduction of robust backup and recovery framework for all Sql server databases
• Creation of clear step by step Disaster Recovery plan for recovery of Business Critical Applications

• Design and development of Insurance Risk\Policy Database for QBE Insurance Group.
• Data modelling and systems design.
• Development of Stored procedures and triggers for database Auditing system
• Development of ETL processes to import data from ICC XML market data feeds into Sql 2000 database.Responsible for the design, development and support of databases used by Thales-ISF’ Credit Risk products within.
• 2nd and 3rd Level support of Oracle (7.3.4\8.1.7) production database environment at Deutsche Bank.
• Backup and recovery of over 50 production and development databases (Oracle and Sql Server)

Design, implementation and support of technical infrastructure used for online payment system.

Graduate Trainee responsible for maintaining MIS database.Development of KPI's and Business DashboardsSystems Administrations