Curriculum Vitae

 

Name:                    Paul Richardson                                                   Date of Birth:       10.11.1970

Address:                20, Branby Avenue,                                             Marital Status:    married

East Morton, Keighley,

West Yorkshire, BD20 5WG              

Tel:                         07778 679537                                                         Email:    pgr_consulting@yahoo.com            

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

Details

Database 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 UK

·         Deployment of SSIS packages and SSRS reports

 

 

Duration: March 2010 – May 2010

Company: Barclays Mortgage Services, Leeds

Role: SQL Server  Database Administrator

Contract

Details

Database 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, Bradford

Role: SQL Server/Sybase Database Administrator

Contract

Details

Database 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, Leeds

Role: Sybase Database Administrator

Contract

Details

Working through SSS worldwide on a project for Deutsche Bank in London. This was a wide-ranging project to assess 10 key systems that used Sybase and make recommendations on improvements. This lead to a best practice document that will be followed for all future Sybase based systems

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, Bradford

Role: SQL Server Database Administrator

Contract

Details

Short 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, Bradford

Role: SQL Server/Sybase Database Administrator

Contract

Details

Database 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, Leeds

Role: SQL Server Database Administrator

Permanent

Details

Database 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, London

Role: DBA Team Leader

Permanent

Details

Managing 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, London

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, Peterborough

Role: Sybase Analyst/Programmer

Permanent

Details

Employed 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:

 

DeMontfort University, Leicester

BSc (Hons) Computer Science (2:1). Included a 13 month industrial placement.

Wigan College of Technology

Computer Science (B), Pure & Applied Maths (D)

St. John Fisher High School, Wigan

10 ‘0’ levels, grades A-C including English Language (A) and Maths (B)

 

 

 

References available on request