Hey There! Welcome to my Site. Thanks for visiting :)

About

 

09/04/2010 to 13/04/2012 – British Petroleum (BP), Canary Wharf (Contract)

Job Title: SQL DBA

  • Project work on a great variety of systems. Releases and updates to everything ranging from Ship tracking to trading systems.
  • Other project work included, but not limited to: migration of databases to new hardware, clustered SQL 2000 to 2005 upgrades, Clustered 2005 to 2008 migrations, Service pack releases, DR testing, new SQL Builds (2005/2008, dedicated and clustered) etc.
  • Performance monitoring, troubleshooting and tweaking of production systems et al.
  • 3rd Line support for Business as usual work
  • SQL DB admin on Prod systems, mostly SQL 2005 and 2008 Clustered servers
  • Creating, setting up and automation of replication technologies such as mirroring and logshipping.
  • Maintaining documentation on said processes. Ensuring project teams adhere to our strict deployment procedures (by way of paper based reviews)
  • Project work- Housekeeping tasks including Index defrags, space management, log checking, providing secure backups to 3rd parties, performance tuning and capacity planning.
  • Best practice audits of SQL environments to ensure systems adhere to company policy and SOX compliance for passwords maintenance.
  • Design and implementation of new system requirements using T-SQL
  • Troubleshooting and resolution of live service issues
  • Setting up and maintaining Dev and Test environments, eventual handover to offshore capabilities.
  • ‘On-call’ and ‘out of hours’ support in addition to the core on-site daily cover.

 

19/01/2007 to 10/06/2009 – London Stock Exchange Group (Contract)

Job Title: SQL DBA

  • Day to day support responsibilities of the designated projects.
  • Day to day support of Production and Development database environments via a work queue as project time schedules
  • Providing regular updates of all project related activities.
  • Taking ownership of tasks and project deliverables
  • SQL Database administration and support on multiple mission critical clustered SQL 2000 and 2005 systems operating in an ITIL certified work environment
  • Setting up of replication technologies including mirroring and logshipping and provision of ongoing support
  • Adhering to the Stock Exchange’s rigorous Change Management process and supplementing all project work with clear and concise support documentation
  • Various project work: migration of databases to new hardware, clustered SQL 2000 to 2005 upgrades, integration between disparate systems of partner companies
  • Housekeeping tasks including Index defrags, space management, log checking, providing secure backups to 3rd parties, performance tuning and capacity planning.
  • Best practice audits of SQL environments to ensure systems adhere to company policy
  • Review of T-SQL code from 3rd parties and team members
  • Design and implementation of new system requirements using T-SQL
  • Design and implementation of backup strategies, utilizing Native SQL, Litespeed, Netbackup or a combination of technologies
  • Design and implementation of DTS and SSIS packages, including migration of DTS to SSIS packages
  • Design and implementation of SQL Reporting Services reports
  • Generating ADHOC reports for business users
  • Troubleshooting and resolution of live service issues
  • Setting up and maintaining UAT environments
  • Maintaining customer relations with the business
  • Review of third party applications and tools for suitability and making recommendations for their implementation
  • ‘On-call’ and ‘out of hours’ support in addition to the core on-site daily cover.

 

14/08/2006 to 31/12/2006 – Citigroup (Contract)

Job Title: SQL DBA

  • SQL Database administration support and services (Clustered SQL 2000 environment, EMC Storage)
  • Development of Recon database, involving data analysis, database design and stored proc development, DTS packages, interfacing with developers to facilitate a web front-end to drive the process, provide information and the mechanisms to track changes.
  • Various project work
  • Housekeeping tasks (Index defrags, space management, Log checking, providing backups to testers and UAT environments etc)
  • Audit of Production environments
  • Troubleshooting Production issues
  • Technical Documentation writing and Handover

 

05/06/2006 to 01/08/2006 – Brewin Dolphin Securities (Contract)

Job Title: SQL DBA and Application Support

  • SQL Database administration support and services (Clustered SQL 2000 environment, SAN Storage and Veritas Netbackup), VLDB (Very large Databases, 100 gig +)
  • Performance monitoring and housekeeping tasks (Index defrags, space management) using Quest Software’s Spotlight
  • Setting up business proposals for the implementation of Litespeed
  • Audit of Production environments
  • Troubleshooting Production issues
  • Technical Documentation writing and Handover
  • Provided consultation services around new Disaster Recovery solution

 

01/04/2006 to 03/06/06 – Dial-a-Phone Ltd (Contract)

Job Title: SQL DBA (2000)

  • SQL Database administration support and services (Clustered SQL 2000 environment, SAN Storage, LiteSpeed and Veritas Netbackup), VLDB (Very large Databases, 100 gig +)
  • Performance monitoring and housekeeping tasks (Index defrags, space management), using Idera’s SQL Diagnostics manager
  • Re-design and development of File upload processes
  • Audit of Production environments
  • Design and setup of Test and Dev environments, using SQL 2000 and Microsoft Virtual Machine / VM Ware
  • Deployment of scripts, DTS packages and other software and enhancements to production, ensuring daily report generation and distribution to business units
  • Troubleshooting Production issues
  • Various Project Work

 

 

Experience

Hobbies

Hey There! Welcome to my Site. Thanks for visiting :)

About

 

Self Paced training (2009)

  • Microsoft SQL Server 2005 Implementation and Maintenance
  • Microsoft e-Learning SQL Server 2008

 

Netscope Training (2005)

  • Updating your Database Development Skills to Microsoft SQL Server 2005

 

Bytes Technology (2005)

  • Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

 

Bytes Technology Ltd (2004)

  • Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

 

CS Holdings (2002)

  • Designing Windows 2000 Active Directory Services
  • 70-240 – Microsoft Accelerated exam (4 x Core Exams)

 

IT-IQ (2000)

  • Microsoft SQL 7 Administration.
  • 20twenty Financial Services (In-house training, 2000):
  • Fincentric Wealthview: Banking engine implementation and administration training.

 

Workgroup Institute (1999)

  • Microsoft Certified Systems Engineer + Internet (Windows NT4).

 

PROFESSIONAL QUALIFICATIONS

  • Microsoft Certified Database Administrator (SQL 2000).
  • Microsoft Certified Systems Engineer (Windows 2000 / Windows NT4)

 

SYSTEMS AND TECHNOLOGY EXPERIENCE

  • SQL Server 2008 / 2005 / 2000 / 7
  • Microsoft Windows Server 2008 R2 / 2003 / 2000 / NT4
  • Microsoft Windows 7 / XP / VISTA
  • Quest Software – Litespeed, Quest Central, Spotlight
  • Idera SQLSafe
  • BMC Remedy 6 / 7
  • CA Clarity
  • SAN Storage

 

Education

 

09/04/2010 to 13/04/2012 – British Petroleum (BP), Canary Wharf (Contract)

Job Title: SQL DBA

  • Project work on a great variety of systems. Releases and updates to everything ranging from Ship tracking to trading systems.
  • Other project work included, but not limited to: migration of databases to new hardware, clustered SQL 2000 to 2005 upgrades, Clustered 2005 to 2008 migrations, Service pack releases, DR testing, new SQL Builds (2005/2008, dedicated and clustered) etc.
  • Performance monitoring, troubleshooting and tweaking of production systems et al.
  • 3rd Line support for Business as usual work
  • SQL DB admin on Prod systems, mostly SQL 2005 and 2008 Clustered servers
  • Creating, setting up and automation of replication technologies such as mirroring and logshipping.
  • Maintaining documentation on said processes. Ensuring project teams adhere to our strict deployment procedures (by way of paper based reviews)
  • Project work- Housekeeping tasks including Index defrags, space management, log checking, providing secure backups to 3rd parties, performance tuning and capacity planning.
  • Best practice audits of SQL environments to ensure systems adhere to company policy and SOX compliance for passwords maintenance.
  • Design and implementation of new system requirements using T-SQL
  • Troubleshooting and resolution of live service issues
  • Setting up and maintaining Dev and Test environments, eventual handover to offshore capabilities.
  • ‘On-call’ and ‘out of hours’ support in addition to the core on-site daily cover.

 

19/01/2007 to 10/06/2009 – London Stock Exchange Group (Contract)

Job Title: SQL DBA

  • Day to day support responsibilities of the designated projects.
  • Day to day support of Production and Development database environments via a work queue as project time schedules
  • Providing regular updates of all project related activities.
  • Taking ownership of tasks and project deliverables
  • SQL Database administration and support on multiple mission critical clustered SQL 2000 and 2005 systems operating in an ITIL certified work environment
  • Setting up of replication technologies including mirroring and logshipping and provision of ongoing support
  • Adhering to the Stock Exchange’s rigorous Change Management process and supplementing all project work with clear and concise support documentation
  • Various project work: migration of databases to new hardware, clustered SQL 2000 to 2005 upgrades, integration between disparate systems of partner companies
  • Housekeeping tasks including Index defrags, space management, log checking, providing secure backups to 3rd parties, performance tuning and capacity planning.
  • Best practice audits of SQL environments to ensure systems adhere to company policy
  • Review of T-SQL code from 3rd parties and team members
  • Design and implementation of new system requirements using T-SQL
  • Design and implementation of backup strategies, utilizing Native SQL, Litespeed, Netbackup or a combination of technologies
  • Design and implementation of DTS and SSIS packages, including migration of DTS to SSIS packages
  • Design and implementation of SQL Reporting Services reports
  • Generating ADHOC reports for business users
  • Troubleshooting and resolution of live service issues
  • Setting up and maintaining UAT environments
  • Maintaining customer relations with the business
  • Review of third party applications and tools for suitability and making recommendations for their implementation
  • ‘On-call’ and ‘out of hours’ support in addition to the core on-site daily cover.

 

14/08/2006 to 31/12/2006 – Citigroup (Contract)

Job Title: SQL DBA

  • SQL Database administration support and services (Clustered SQL 2000 environment, EMC Storage)
  • Development of Recon database, involving data analysis, database design and stored proc development, DTS packages, interfacing with developers to facilitate a web front-end to drive the process, provide information and the mechanisms to track changes.
  • Various project work
  • Housekeeping tasks (Index defrags, space management, Log checking, providing backups to testers and UAT environments etc)
  • Audit of Production environments
  • Troubleshooting Production issues
  • Technical Documentation writing and Handover

 

05/06/2006 to 01/08/2006 – Brewin Dolphin Securities (Contract)

Job Title: SQL DBA and Application Support

  • SQL Database administration support and services (Clustered SQL 2000 environment, SAN Storage and Veritas Netbackup), VLDB (Very large Databases, 100 gig +)
  • Performance monitoring and housekeeping tasks (Index defrags, space management) using Quest Software’s Spotlight
  • Setting up business proposals for the implementation of Litespeed
  • Audit of Production environments
  • Troubleshooting Production issues
  • Technical Documentation writing and Handover
  • Provided consultation services around new Disaster Recovery solution

 

01/04/2006 to 03/06/06 – Dial-a-Phone Ltd (Contract)

Job Title: SQL DBA (2000)

  • SQL Database administration support and services (Clustered SQL 2000 environment, SAN Storage, LiteSpeed and Veritas Netbackup), VLDB (Very large Databases, 100 gig +)
  • Performance monitoring and housekeeping tasks (Index defrags, space management), using Idera’s SQL Diagnostics manager
  • Re-design and development of File upload processes
  • Audit of Production environments
  • Design and setup of Test and Dev environments, using SQL 2000 and Microsoft Virtual Machine / VM Ware
  • Deployment of scripts, DTS packages and other software and enhancements to production, ensuring daily report generation and distribution to business units
  • Troubleshooting Production issues
  • Various Project Work

 

 

Experience

Skills

References and letters of recommendation available on request

 

References

TELEPHONE NUMBER:  +44 78 522 00097

E-MAIL ADRESS: gerhard@quadetechnology.com

 

Contact