Barry Smallman's Email Addresses & Phone Numbers

📖 Summary

An experienced and conscientious Database Administrator working primarily with SQL Server (versions 6.5 to 2012). I am a reliable individual and an excellent team worker, who is also proactive at managing my own workload. I am competent at communicating with staff at all levels, and often called upon to communicate technical matters in a clear and concise fashion. I am an approachable team member, quick to respond and resolve issues and provide seamless customer service MCITP SQL Server 2008 Database Administrator (70-450). MCTS SQL Server 2008 Implementation and Maintenance (70-432). Specialties: SQL Server 6.5 to 2012SQL Server Database Administrator @ Vanquis Bank is a UK based credit card company and is part of the Provident Financial Group. At Vanquis Bank I am one of 4 SQL Server Database Administrators, maintaining the bank's SQL Server 2008, 2008 r2 and 2012 instances. As a team our role involves: • Installation and upgrading of SQL Server instances. • Monitoring of all SQL Server instances to minimise outages. • Creation and alteration of databases and database objects. • Management of appropriate and secure instance and database access permissions to comply with PCI requirements. • Creation and ongoing support of all SQL Server Agent jobs, including problem determination, recovery and re-running of SSIS packages where necessary. • Working closely with the various development teams to ensure that system updates are released in an efficient and effective manner. • Ensuring that appropriate database backup strategies are in place. • Ensuring that appropriate and accurate documentation exists. From June 2013 to Present (2 years 7 months) SQL Server Database Administrator @ Celerity Information Services is one of the leading CRM data management companies in the UK As the only SQL Server DBA at Celerity I am responsible for all the SQL Server 2005, 2008, 2008 r2 and 2012 databases that we manage. My responsibilities include: • Installation of new SQL Server instances and upgrading existing instances. • Monitoring of all instances and databases to minimise outages. Monitoring is now performed using Redgate SQLMonitor, which was installed and configured by myself in February 2013. • Working closely with the Application Support Team, Developers and Infrastructure Support Team in problem determination, and implementation of appropriate recovery procedures. • Creation and alteration of databases and related database objects. • Management of appropriate and secure instance and database access permissions. • Creation and on-going support of all SQL Server Agent jobs. • Ensuring that appropriate database backup strategies are in place. • Ensuring that appropriate and accurate documentation exists. From January 2012 to June 2013 (1 year 6 months) SQL Server Database Administrator @ International SOS is the world’s leading international healthcare, medical assistance, and security services company. In this role I was the sole DBA based in the London office, responsible for the SQL Server 2000, 2005 and 2008 databases. Also responsible for supporting the London SharePoint site. • Monitoring of all databases to minimise outages. • Creation and alteration of databases and database objects. • Administration of database access permissions. • Creation and ongoing support of all SQL Server Agent jobs. • Ensuring that appropriate database backup strategies are in place. • Ensuring that appropriate and accurate documentation exists. • Supporting the local SharePoint site. • Supporting the company’s BI solution, using SSIS, SSAS and MOSS. • Supporting local reporting solutions which use SSRS. From September 2010 to January 2012 (1 year 5 months) Database Administrator @ Xchanging is a global business processing provider, servicing the London Insurance Market. This role involved working in a team of 3 DBA’s supporting SQL Server, DB2 for z/OS and Sybase, and included the following responsibilities: • Proactively monitoring Production and Non-Production databases to avoid outages wherever possible, and also promptly identifying and resolving issues whenever they arose. • Creation of new database objects and altering existing objects. • Creation and ongoing support of database maintenance plans. • Ensuring that appropriate database backup strategies were in place. • Administering SQL Server access permissions and privileges. • Participated in successful Disaster Recovery tests for DB2 and Sybase. • Coaching / training colleagues, as required, to enable them to gain a better understanding of any third party applications being used. • Maintaining the DBA documentation repository, which was used extensively by the whole team to store reference information and ‘how to’ documents. • Out of hours support of overnight batch suites. From October 2008 to July 2010 (1 year 10 months) Database Administrator @ Steria is an outsourcing provider, with clients from diverse sectors including financial institutions, local government, central government and defence. This role involved working in a team of 8 DBA’s. My role was primarily providing day-to-day support for SQL Server 2000 and 2005, and DB2 for z/OS. I also occasionally assisted with the support of Oracle 9i and Sybase 12.5. As this role involved providing database administration support for a number of local government and defence contracts it was necessary for me to have full security clearance and CRB checks. My role included the following responsibilities: • Proactively monitoring Production and Non-Production databases - avoiding outages wherever possible, and also promptly identifying and resolving issues whenever they arose. • Supporting systems which had SQL Server log-shipping, replication and clustering implemented on them. • Creation of new database objects and altering existing objects. • Creation and ongoing support on SQL Server database maintenance plans • Administering SQL Server access permissions and privileges. • Creation and support of SQL Server 2000 DTS packages. • Participated in Disaster Recovery tests for SQL Server, DB2 and Sybase, successfully recovering all systems and enabling users to test applications. • Installed default and named instances of SQL Server and applied service packs when necessary. • Instrumental in the creation and ongoing maintenance of the DBA documentation repository, which contained a wealth of information that enabled the team to access information relating to customers, and servers. It also contained tips to assist the team with performing database related tasks. • Out of hours support of overnight batch suites. In October 2008 I was TUPE'd to Xchanging. From September 1999 to October 2008 (9 years 2 months) Database Administrator @ Joined Lloyd's of London straight from school and during my time there I held a number of IT position including: 1996 – 1999 Database Administrator - Mainframe DB2, SQL Server and SYBASE. 1990 – 1996 Capacity Planning and Performance Reporting - IBM Mainframe. 1986 – 1990 Operations Analyst - JCL writing and support of batch suites. 1982 – 1986 Computer Operator - IBM MVS mainframe. In 1999 the IT department was TUPE'd to Steria. From August 1982 to August 1999 (17 years 1 month) Chatham Grammar School for Boys From 1975 to 1982 Chatham Technical High School From 1975 to 1982 Barry Smallman is skilled in: DB2, SSIS, Microsoft SQL Server, Databases, SQL, Access, SharePoint, Disaster Recovery, SSRS, ETL, Oracle, Database Administration, Servers, T-SQL, Business Intelligence, CRM, Data Modeling