Experience

CareFree Management Ltd

• United Kingdom
• Hospitals and Health Care
• 1 - 100 Employee

• SQL Database Administrator

  • May 2016 - Present

  SQL Database Administrator\Systems Architect – 2016 – CURRENT (Contract Role) - UK CAREFREE MANAGEMENT LTD – SOFTWARE HOUSE (HEALTHCARE) – UK Initially to performance tune the application, addressing database issues (indexing, sizing, stored procedure re-writing\recommendations, archiving, bottleneck troubleshooting, table structure changes) as well us underlying hardware and SQL Server setup issues. Overhaul of security practices and process management, enforcing stricter guidelines for all user groups and application security, introducing separation between development\support through to testing and production. Worked closely with infrastructure provider to introduce redundancy and high availability across the entire company wide estate as well as implementing disaster recovery solutions. Managed various non-sql server related projects and acted as a primary source of contact for most internal staff members as well as external 3rd party suppliers. Show less



Nestlé

• Switzerland
• Food and Beverage Services
• 700 & Above Employee

• SQL Database Administrator

  • Apr 2015 - May 2016

  SQL Database Administrator - 2015 – 2016 (Contract Role) - Switzerland NESTLÉ / SWISSCOM (Velti Group) – NUTRITION, HEALTH AND WELLNESS – GLOBAL Performed SQL server audit. Brought Nestlé Suisse SQL server estate in line with global compliancy framework. Enhanced SQL server user security, permissions and privileges. SQL server migration 2008r2 – 2012. Migration of old access database to SQL 2012 including database re-structure and rebuilding. Implemented new backup strategy and new index maintenance routines. Ongoing duties: Consult and advise on SQL server estate. Performance tune various scripts and rework problem scripts. Perform data cleansing exercises. Develop small scale ETL solutions. Participate in application upgrades and out of hours maintenance. Provide help and advice where needed and drive process change. Show less



V.Group

• United Kingdom
• Maritime
• 700 & Above Employee

• SQL Database Administrator

  • Apr 2012 - Apr 2015

  SQL Database Administrator - 2012 – 2015 (Contract Role) - UK V SHIPS INTERNATIONAL – SHIP MANAGEMENT COMPANY – GLOBAL Upgraded large replicated SQL Server estate SQL2000 x86 – SQL2008r2 x64. Performance tuned. Performance monitoring and PAL analysis. Completed new index strategy. Revised backup routines. Implemented log shipping. Created new security model. Installed and configured new SQL2008r2 servers and 2012 server. Integration of data from Oracle 11g to SQL Server. General troubleshooting. Supported other team members. Designed reports for monitoring using SSRS. Introduced compliance measures. Documented configuration of SQL server estate. Show less



Aggreko

• United Kingdom
• Utilities
• 700 & Above Employee

• SQL Database Administrator

  • Apr 2011 - Apr 2012

  SQL Database Administrator - 2011 – 2012 (Contract Role) - UK AGGREKO PLC – ENERGY PROVIDER – GLOBAL Implemented SQL backup processes and procedures for all databases. Performance tuned – indexing where necessary and query optimising. Analysed performance monitor and PAL reports. Worked with Oracle DBAs to pull data from Oracle 10g into SQL Server. Managed SQL Server users/accounts and securities/permissions where required. Wrote stored procedures/triggers. Migrated databases to new servers. Disaster recovery (DR) planning and implementation. Database mirroring. SQL 2008r2 Installations. New clustered SQL instance installations – clustering. Offer advice and guidance to team members as appropriate. Wrote technical documents. Delivered short training sessions. Show less



Invocas Group

• United Kingdom
• Financial Services
• 1 - 100 Employee

• SQL Database Administrator

  • Apr 2009 - Apr 2011

  SQL Database Administrator/Migration Specialist - 2009 – 2011 (Permanent Role) - UK INVOCAS FINANCIAL LTD – FINANCIAL SERVICES COMPANY – NATIONAL Performance tuned – indexing where necessary and query optimisation. Managed users/accounts and securities/permissions. Wrote stored procedures/triggers for various projects. Migrated databases to new servers. Designed and produced reports using SSRS. Used SSIS to integrate and manipulate data from existing systems into Salesforce.com. Implemented a DBAmp connection from SQL Server to Salesforce Live and Sandbox environments. Supported team members as appropriate. Show less



Allied Vehicles Group

• United Kingdom
• Motor Vehicle Manufacturing
• 100 - 200 Employee

• SQL Database Administrator

  • Jun 2007 - Apr 2009

  SQL Database Administrator - 2007 – 2009 (Permanent Role) - UK ALLIED VEHICLES LTD – AUTOMOTIVE MANUFACTURER – NATIONAL Ensured databases ran efficiently, backups were complete and disaster recovery achievable. Wrote SQL queries to extract key information from databases for various sections within the company, particularly for marketing campaigns. Designed a data cube using SSAS to aid the marketing function of the business. Used business objects to write reports through Crystal reports software. Developed the company’s existing CRM system using SQL 2000. Implemented call logging system (in line with ITIL standards) which increased the efficiency of the IT function. Analysed call logging data to establish trends and patterns to instigate and inform business improvement. Show less



Rise Solutions

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Business Development Manager

  • Sep 2006 - Jun 2007

  Service Delivery/Business Development Manager - 2006 – 2007 (Permanent Role) - UK RISE SOLUTIONS LTD – IT SERVICES SME – LOCAL Sought new business opportunities and pitched for and won tenders. Investigated clients’ needs and expectations for projects - consulting client stakeholder groups (internal and external). Liaised with technical development team to ensure the needs established through consultations were met. Delivered projects on time and in budget resulting in repeat business from clients. Led in the research, analysis and design of various software development projects resulting in the modernisation of clients’ business processes, using process mapping and data flow techniques for example. Show less



Torex Retail

• United Kingdom
• IT Services and IT Consulting

• Technical Support Analyst

  • May 2004 - Sep 2006

  2nd Line Support Analyst (Product Specialist) - 2004 – 2006 (Permanent Role) - UK TOREX RETAIL PLC – SOFTWARE DEVELOPMENT - RETAIL, HEALTH AND LEISURE – INTERNATIONAL Investigated issues and problems escalated by 1st line support team. Ensured that service level agreements were met for all clients. Diagnosed hardware/software issues and solved technical problems by remotely administering clients’ systems. As one of the team’s product specialists, delivered product training to internal staff members and client groups. Worked within helpdesk institute (HDI) standards and assisted with the company’s HDI accreditation process. Worked within ITIL standards. Communicated effectively in both technical and everyday language and became an excellent link between clients, programmers and engineers. Wrote and presented service delivery reports for senior management team to analyse trends in customer issues and recommend resolutions for improved customer service and product development/upgrade opportunities. Show less



MAM Software Group Inc.

• United Kingdom
• Software Development

• Technical Support Analyst

  • Jun 2001 - May 2004

  2nd Line Support Analyst - 2001 – 2004 (Permanent Role) - UK MAM SOFTWARE LTD – SOFTWARE DEVELOPMENT – AUTOMOTIVE INDUSTRY – INTERNATIONAL Resolved clients issues escalated from 1st line support. Re-developed problematic aspect of software product. Analysed call data for trending problems. 2nd Line Support Analyst - 2001 – 2004 (Permanent Role) - UK MAM SOFTWARE LTD – SOFTWARE DEVELOPMENT – AUTOMOTIVE INDUSTRY – INTERNATIONAL Resolved clients issues escalated from 1st line support. Re-developed problematic aspect of software product. Analysed call data for trending problems.