What I bring with me: • A solid background working with databases since the nineties, in a variety of different sectors • Both Production & Development experience with SQL Server 7 onwards • A keen interest in mentoring & developing talent, advocating Best Practises & ways to remove RBAR (Row-By-Agonizing Row) at each opportunity • Experience leading a team & motivating a team • Being able to explain in Plain English technical terms, to help communicate with individuals & sections outside of IT Clifton Strengths Finder Top Five Strengths Learner – Responsibility – Achiever – Intellection – Ideation

Database Manager @ From January 2015 to Present (1 year) Database Team Lead @ From June 2014 to January 2015 (8 months) BI DBA @ From February 2014 to June 2014 (5 months) SQL Server DBA @ From November 2013 to December 2013 (2 months) London, United KingdomDBA @ • Experience with SQL Server versions 2000, 2005, 2008, 2008R2 & 2012, using different versions of Enterprise Manager / Query Analyser / SSMS as appropriate • Supporting various critical database underpinning the DMS & Fiscal systems • Supporting the day to day running, maintenance & projects related to hundreds of smaller databases globally • Supporting 60 distinct Log Ships globally across various versions of SQL • Migrating databases 2000 to 2005 & 2005 to 2008R2 • Responsible for ensuring instances are licensed & the introduction of the Microsoft’s EAP • Consolidating instances, along with migrating instances following acquisitions of smaller law firms • OS patching & SQL Server service packs for all dedicated SQL boxes • Maintaining, implementing & upgrading SQL Server Clusters, across Server 2003 R2 & 2008 R2 host nodes, with SQL 2005 & 2008 R2 clusters • Implemented a new maintenance suite across all instances, ensuring regular full backups, transaction log backups, re-indexing, database checks, alerts when instances are restarted & tracking where Log Shipping is falling behind or connectivity to instances has been compromised • Responsible for mentoring & training database administration & development in T-SQL as well SSIS, for improve the skill base of other staff, both directly within the team & other sister teams • Introducing & expanding the usage of both SSIS & SSRS • Establishing a strong rapport with key-users. Enabling major projects with other departments for example Finance, to achieve their goals with the active support from IT • Working with 3rd parties. Ensuring that a strong grounding in security, integrity & availability are all adhered too; flagging where appropriate concerns • Performance tuning within the constraints of various third party applications • Becoming the technical lead for SupportWorks during a significant upgrade project. Championing processes to better fit an ITIL approach, ensuring the buy-in from rest of IT From December 2010 to October 2013 (2 years 11 months) London, United KingdomEuropean DBA @ • Experience with SQL Server versions 7, 2000 & 2005. Utilising the different versions of • Supporting multiple distinct couple terabyte databases which underpin various SAP instances. • Supporting the day to day running, maintenance & associated projects related to hundreds of smaller databases & differing collations, globally • Supporting a number of large SAP Projects from the database layer, working with the BASIS & ABAP staff; performing data refreshes of the various Development, Quality Assurance & Sandbox environments • Supporting Log-Shipping of same multiple distinct couple terabyte databases • Conducting Technical Interviews for DBA applicants • Migrating databases from SQL Server 7 & 2000 to SQL Server 2005 • Upgrading & rewriting SQL Server 7 & 2000 DTS into SQL Server 2005 SSIS • Creating new SSIS packages, including one which is run against a 5 second repeating schedule. • Performing code reviews of developer written database scripts. Where appropriate, using the feedback as opportunities to train & teach best practices. • Providing training in the theory & principles of database development. • Database Performance tuning within the constraints of the SAP environment. • Overhauling, enhancing & standardising the various out of hours maintenance routines & processes. • Advising, designing & performing the data migration associated with sever hardware upgrades. • Working with the Desktop & Web developers to both tune internally created & third party databases. As well as both creating new data interfaces between these & the various primary SAP databases. • Consulting & liaising on matters of data security & integrity, both internally & with third parties. • Acting as a change manager representing the Database interests within the CAB process. • When required performing assistance with various other non SQL Server RDBMS, for example SYSBASE, MySql & Oracle. From December 2008 to December 2010 (2 years 1 month) Senior DBA @ • Experience with SQL Server versions 2000 & 2005 • Providing Training in Database Theory & Best Practise in the Context of SQL Server 2000 • Managing & monitoring fifteen live Customer facing Databases. • Designing a custom Blocked connections monitor which generates email warning. Required due to poor connection handling within the Java / ORM Layer. • Backward-engineering SQL Statements generated within the ORM layer, capturing them via SQL Profiler, then enhancing or revising the table & column design, along with implementing & improving Indexes, both Clustered & Non-Clustered. • Experience SQL Performance Optimising, via database statistics, log truncating, configuration / design of file groups, efficient use of indexes, minimising usage of joins across more than three tables, maintenance plans updating as required. • Creating & maintaining dedicated Stored Procedures & Functions to facilitate migrating processes away from the Java / ORM layer into the database where appropriate. • Experience with both creating, maintaining & debugging Jobs Scheduling via SQLAgent. • Migrating databases from SQL Server 2000 to SQL Server 2005 • Consulting & acting as a point of referral with regards to SQL Server, especially in regards to interacting with the Java Web Developers. • Advocating the advantages of Stored Procedures, as well how using it to replace dynamic SQL from the Web layer can not only improve performance. As well as allowing for more tasks to be performed at the same time & adding protection against SQL Injection attacks. • During Performance / Stress tests via Perfmon & SQL Profiler. From September 2007 to November 2008 (1 year 3 months) Various Roles Including Database / Application Developer / DBA @ From May 1997 to August 2007 (10 years 4 months)

Experienced Manager Program @ Inspirational Development Group From 2007 to 2007 University of Kent From 1995 to 1996 Brighton College of Technology From 1994 to 1995 Cardinal Newman From 1985 to 1991 Richard Gilbert is skilled in: Microsoft SQL Server, SQL, Databases, Oracle, Database Administration, T-SQL, SSIS, Performance Tuning, SQL Tuning, Stored Procedures, Data Migration, ITIL, Mentoring, SSRS, Windows Server