Curriculum Vitae
Name: Paul Richardson Date of Birth: 10.11.1970
Address: 20,
East Morton, Keighley,
West
Tel: 07778 679537 Email:
Principal IT skills |
Level
of experience |
Microsoft SQL Server (6.5, 7.0, 2000 & 2005) |
16
years |
Sybase (11.5, 12.0, 12.5 and 15.0) |
18
years |
Transact-SQL |
18
years |
Team Leading |
3
years |
UNIX shell scripts |
16
years |
Profile Summary: |
Experienced
production and development Microsoft SQL Server and Sybase DBA, with 16 years
of SQL Server and 18 years experience of Sybase and Unix, and excellent
communication skills. Wide
experience of both project related work and production support work, mainly
with financial institutions. Able
to work under pressure to tight deadlines and in both large and small teams,
and distributed across several locations. Extensive
experience of stored procedure development, trouble shooting, query
optimisation and backup and restore strategies. Can administer SSRS reports
and SSIS packages in SQL Server. Also extensive patching knowledge. |
|
Employment Details:
Duration: May 2010 – November 2012 |
Company: Lloyds Banking Group, Pudsey |
Role: SQL Server Database Administrator |
Contract |
DetailsDatabase
Administrator working on SQL Server 2000, 2005 and 2008. Initially working in
production support, before moving into the project delivery team |
|
Involvement· Initially involved in production support, managing changes , incidents and patching · Subsequently worked in the project delivery side of the DBA team, delivering projects from development to production, and also implementing smaller changes · Involved in various projects related to the HBOS/LTSB integration project. · Involved in various projects related to the ‘Verde’ Project for the divestment of assets to satisfy conditions imposed as part of the government bailout |
|
Skill summary·
Wide experience of SQL Server (Including SQL Server 2000, 2005 and
2008) ·
Experience of full route to live projects, from development to
failover/DR testing ·
Experience of Change Management process for implementing changes,
using SM7 ·
Experience of distributed teams as many colleagues are based at
various locations around the ·
Deployment of SSIS packages and SSRS reports |
Duration: March 2010 – May 2010 |
Company: Barclays Mortgage Services, |
Role: SQL Server Database Administrator |
Contract |
DetailsDatabase
Administrator responsible for support, on both SQL Server 2000 and SQL Server
2005. |
|
Involvement· Production performance issues resolution using SQL Profiler and DBCC commands · Responsible for defining indexes for applications · Analysing troublesome SQL. |
|
Skill summary·
Wide experience of SQL Server (including SQL Server 2000/2005) |
Duration: April 2009 – January 2010 |
Company: Provident Financial, |
Role: SQL Server/Sybase Database Administrator |
Contract |
DetailsDatabase
Administrator responsible for production support, on both SQL Server 2000 and
SQL Server 2005. Also support of Sybase ASE15.0 systems. |
|
Involvement· Used as a reference by the team and department for issues with SQL Server and Sybase · Production performance issues resolution using SQL Profiler and DBCC commands · Responsible for writing stored procedures to help with performance monitoring |
|
Skill summary·
Wide experience of SQL Server (including SQL Server 2000/2005) ·
Practical experience of SSMS and SQL profiler. ·
Experience of maintaining SSIS packages ·
Experience of deploying SSRS reports ·
Exposure to various software packages including Red-Gate SQL Backup
software, Maestro scheduling tools and DataProtector
Backup/Restore software ·
Exposure to Windows and Unix Administration ·
Part of the daytime support rota, using Service Desk Express |
Duration: January 2008 – September 2008 |
Company: SSS Worldwide, |
Role: Sybase Database Administrator |
Contract |
DetailsWorking through SSS
worldwide on a project for Deutsche Bank in |
|
Involvement· Review of key systems and recommendation of improvement · Definition of the process by which the systems would be reviewed. |
|
Skill summary·
Use of Sybase experience to look at all aspects of Sybase
Performance ·
Project management skills to plan and implement changes |
Duration: October 2007 – December 2007 |
Company: Yorkshire Water, |
Role: SQL Server Database Administrator |
Contract |
DetailsShort term contract
to performance tune a vital production SQL Server 2005 system |
|
Involvement· Solely Responsible for recommending and implementing performance changes |
|
Skill summary·
Extensive use of performance and tuning methods, including
rewriting stored procedures. ·
Use of profiler to spot server bottlenecks and recommended actions |
Duration: August 2006 – September 2007 |
Company: Provident Financial, |
Role: SQL Server/Sybase Database Administrator |
Contract |
DetailsDatabase
Administrator responsible for production support, on both SQL Server 2000 and
SQL Server 2005. Also support of Sybase ASE12.5 systems. Involved in some
work on Sybase ASE15.0 upgrade |
|
Involvement· Responsible for Support of weekly data transfer tasks, including DTS and SSIS packages · Responsible for writing stored procedures to help with performance monitoring |
|
Skill summary·
Wide experience of SQL Server (including SQL Server 2000/2005) ,
including installation, backups & restores to tape and disk, performance monitoring ·
Practical experience of SSMS and SQL profiler and maintaining SSIS
packages. ·
Use of DTS and SSIS to transfer data from Sybase to SQL Server and
from SQL Server to SQL Server |
Duration: March 2006 – August 2006 |
Company: EMIS, |
Role: SQL Server Database Administrator |
Permanent |
DetailsDatabase Administrator
responsible for production support, mainly on SQL Server 2000, but some SQL
Server 2005 also |
|
Involvement· Responsible for ensuring systems are backed up and for all weekly maintenance schedules · Responsible for automating monthly stats reports for all live systems and for writing stored procedures to help team members with troubleshooting · Production performance issues resolution using query analyser, SQL Profiler and use of DBCC commands |
|
Skill summary·
Wide experience of SQL Server (including SQL Server 2000/2005) ,
including installation, backups & restores, performance & tuning and
code promotions. Also, extensive Transact SQL knowledge, including stored
procedures and triggers |
Duration: Nov 2001 – June 2005 |
Company: Baring Asset Management, |
Role: DBA Team Leader |
Permanent |
DetailsManaging a team of DBA’s handling production and non-production support. This
included out-of-hours support and Business Continuity Planning. |
|
Involvement· Line manager responsibilities for 2 DBA’s · Implemented Business Continuity planning procedures for all SQL Server and Sybase databases. This included implementing log shipping for SQL Server. · Responsible for implementation of installation of 3rd party applications as well as in-house systems · Production performance issues resolution using query analyser, SQL Profiler and use of DBCC commands · As we were a small team, I continued to perform administration tasks daily, and also continued to be a part of the overnight support rota. |
|
Skill summary·
Wide experience of SQL Server (including SQL Server 2000) ,
including installation, backups & restores, performance & tuning and code
promotions ·
Wide experience of Sybase (including ASE12.5) and Unix shell
scripting |
Duration: Feb 1996 – Nov 2001 |
Company: Baring Asset Management, |
Role: Sybase and SQL Server Database
Administrator |
Permanent |
Details |
|
Involvement· Performed various tasks necessary to deliver systems into production including system code builds, system testing and user application support, including Y2K and Euro conversion projects. · Responsible for writing maintenance scripts in Unix · Out of hours production support · Extensive performance and tuning of production SQL Server systems · Installation of both Sybase and SQL Server · Extensive backups and restores, including installing log shipping for SQL Server |
Duration: July 1994 – Feb 1996 |
Company: Thomas Cook, |
Role: Sybase Analyst/Programmer |
Permanent |
DetailsEmployed as a Junior Analyst/Programmer by the company I had spent 13 months with previously on my placement year from university. Worked on development of Sybase stored procedures to support Thomas Cook’s traveller’s cheque systems. |
|
|
Education:
|
|
|
BSc (Hons) Computer Science (2:1). Included a 13 month industrial placement. |
|
Computer Science (B), Pure & Applied Maths (D) |
|
10 ‘0’ levels, grades A-C including English Language (A) and Maths (B) |