Paul Anderton Email & Phone Number

Bolton, Gb

London, Gb

Working as a sole DBA within a large IT Department. Provide advice and support to Developers on Design and Performance, Support and Maintain current SQL Servers. Projects currently working on include Consolidating SQL Servers to reduce cost and improve performance, upgrading various systems from 2005 to 2008R2 and 2008R2 to 2012, implementing HA technologies and improving DR technologies used. Responsibilities: Provide support, maintenance and troubleshooting for over 1500 OLTP/OLAP databases across 70+ servers running SQL Server 2000, 2005, 2008R2 and 2012 on EqualLogic, Compellent and NetApp SAN's spanning over 10TB of disk space. Reporting technologies include SSRS, SSIS, SSAS.

Manchester, Gb

Work within a team of 4 DBA's, of which 2 are Senior DBA's and 2 are DBA's. Provide advice and support to over 45 Developers on topics such as DB Design and Performance Tuning. Projects currently working on include a Data Centre migration working alongside the Operations Team and a 2008 upgrade to 2012 utilising Availability Groups, Replication and San Snapshots.Responsibilities: We provide 24/7 support for over 400 highly transactional databases across 30+ servers running SQL Server 2000/2005(x86) and 2008(x64) on a NetApp SAN spanning over 7TB of disk space. HA and DR technologies include Clustering, Mirroring, Replication, San Snaphots. Reporting technologies include SSRS, SSIS, SSAS.

Manchester, Gb

MSSQL DBA Role includes SQL Server 2000, 2005, 2008 Database Administration and Support, Performance Tuning, Installation and Design. Working as part of a team of 3 Production DBA’s . Responsibilities: We provide 24/7 support for over 400 highly transactional databases across 30+ servers running SQL Server 2000/2005(x86) and 2008(x64) on a NetApp SAN and other Direct Attached Storage spanning over 5TB of disk space. HA and DR technologies include Clustering, Mirroring, Replication, San Snaphots. Reporting technologies include SSRS, SSIS, SSAS.

Senior Professional Services EngineerRole includes SQL Server 7, 2000, 2005 Database Design, Administration and Support, Installation, Testing and Troubleshooting of Company’s own proprietary Software across multiple worldwide Customer sites.Responsibilities: Administration of Customer databases up to 70GB in size including Installation, Configuration, Troubleshooting and Support of SQL Server 7, 2000, 2005, Replicated Systems and Reporting Services. Development and testing of bespoke Stored Procedures and Triggers. Troubleshooting VB6 code. 24/7 Support and Installation of Company software. Training junior members of staff. Test and implement new technologies such as RFID, document and report findings to management.

Headhunted by Luminar to continue previous role as a Database Administrator. Responsibilities: Smooth running and support of all systems and to ensure every system is disaster recoverable. Monitor and Maintain Server Availability. Administered SQL Server 2000, setting up security improving database performance, maintaining backup jobs, restoring databases and setting up alerts. Support and Administer several systems including Lotus Notes, NT4 Domain, 2000 Domain, Acorde EDM and Office.

Develop, Implement, Monitor, Maintain, Support and Improve performance of bespoke in-house systems. Responsibilities: Administered SQL Server 2000, in particular set up and maintained Security, set up maintenance jobs including backups to make sure that all data is recoverable in the event of any data loss. Restored databases when necessary, used DTS to import/export data into SQL and between SQL Server 2000 Databases. Tuned Databases to increase performance, these databases ranged from 50MB to 6GB. Maintaining System Availability, Developing new VB6 programs to aid in day to day administration. Monitor, Administer and support all systems including NT4 Domain, 2000 Domain, Exchange and BEA Weblogic.

Monitor and Maintain Server Availability, provide necessary backups for all systems in the event of hardware failure and user error and to support all users in all systems.Responsibilities: Set up Security and backups jobs on SQL Server 7 and SQL Server 2000. Maintaining Server Availability and providing Necessary backups of systems, also to provide Support in all areas of the Business. Good all round knowledge of all systems used on site and remotely.