Sql Server Database Administrator

• Aug 2021 - Present

Sql Server Database Administrator

• Sep 2017 - Present

SQL Database Administrator

• Nov 2018 - Oct 2021

Senior Database Specialist

• Jan 2008 - Sep 2017

• Technology Platform Owner for Microsoft SQL Server, responsible for installation, configuration, managing upgrades, implementing backup solutions, security design, tuning, database modeling, replication, log shipping, cluster management, DTS and SSIS package design.• Responsible for the company's whole worldwide SQL environment, including 100’s of SQL Servers ranging from SQL2000 through to SQL2012• Expert in all aspects of SQL administration including backup/restore, log_shipping, security etc.• Taught and supported a team of junior DBAs to provide first-level support for the SQL environment, and thereafter provided second-level support for all issues• Member of numerous development project teams, representing the Data Management Team in all aspects of database application design and implementation, whether in-house developed, or third-party applications• Actively involved in multi-discipline teams with knowledge in various related technologies including Oracle, UNIX, ETL, SAP, Data Warehouse etc.ACHIEVEMENTS:• Successfully virtualised all SQL Server instances throughout the corporation• Planned, implemented and tested Disaster Recovery solution for Tier 1 SQL Servers at corporate centre, involving leading-edge technologies such as EMC, VPlex, SRDF etc….• Successfully rationalised the corporate SQL landscape from running 6 SQL versions, to just 2, thereby simplifying administration and support, reducing costs and mitigating risks• Designed and implemented standard processes across all servers to automate the standard tasks of backups, and other database management routines• Cash award received for the successful introduction of brand new global development environment• Cash awards received for efficiency and success in various projects Show less

Database Administrator

• Jan 2006 - Jan 2008

• Database Administrator with responsibility for providing first-level support to the company's Oracle and SQL Server environments.• Supporting all aspects of database administration, including installation, backup, ETL etc.• Supporting developers in new database application design and implementation

Internal Auditor

• Jan 2003 - Jan 2006

• Member of global internal audit team, reviewing internal business procedures, identifying weaknesses and recommending improvements• Primary responsibility for designing and implementing the company’s new fixed asset audit procedures• Responsible for the design of computer interrogation programsACHIEVEMENTS:• Implemented the use of interrogation software within the team – saving the team considerable time and resourcesthrough the use of automated audit techniques• Won top prize in North American competition for our use of interrogation software Show less

Six Sigma Global Management Team Member

• Jan 2002 - Jan 2003

• Member of global leadership team, responsible for designing and implementing Six Sigma programme throughout the organisationACHIEVEMENTS:• Financial specialist on team with specific responsibility for the design/implementation of finance/IT procedures• Training of 60 financial advisors and 150 Black Belts (Project Team Leaders) on financial procedures• Six Sigma projects saved the company many millions of $s in its first two years

SAP Global Team Leader

• Jan 2000 - Jan 2002

• Led a small global team, with responsibility for the analysis, design, implementation, training and support of the Asset Management module throughout the organisation.ACHIEVEMENTS:• Promotion and cash award received for successful global implementation of SAP module.

Project Accountant and European Capital Accountant

• Feb 1996 - Jan 2000

• Project accountant and member of management team for Major plant expansion project.• System administrator and technical support for all capital/project systems throughout European organisation.ACHIEVEMENTS:• Promotion and cash award received for the implementation of strong financial/system controls enabling management to bring in project within budget.• Cash award received for the design and development of new reports assisting management control of Europe-wide projects.• European representative, part of team analysing foreign currency transactions within corporation: cash award received for substantial savings made as a result of work. Show less

Project Accountant/Team Leader

• Jan 1994 - Jan 1996

• Leader of a team tasked with the evaluation of different accounting systems and the implementation of the selected system. • Project accountant providing overall financial control and monitoring of the Trust’s capital process, in particular: - reviewing, approving and prioritising business cases; - financial appraisal of capital bids and evaluation of leases; - project accountant dealing with the construction of four community hospitals. ACHIEVEMENTS: • Re-designed controls and procedures surrounding the control of capital within the Trust, resulting in more efficient use of the Trust’s financial resources. Show less

Consultant

• Jan 1993 - Jan 1994

• Undertaking short-term accountancy and IT related projects. • Undertaking short-term accountancy and IT related projects.

Auditor / IT Consultant / Receivership team member

• Jan 1990 - Jan 1993

Auditor • Involved in a wide range of audit assignments and special accountancy-related work with a variety of clients in all industry sectors • Required investigation and analysis of existing reports and procedures, confirming financial information, and recommending areas for improvement. IT Consultant • Member of a small team within the Computer Assurance Services Department, providing a wide range of computer-related services to a variety of clients throughout Wales and South West England, with specific personal responsibility for: computer audit, modelling, systems reviews and controls testing. Receivership team • Temporary administration of small companies whilst in receivership Show less

Commerical Management Trainee

• Jan 1988 - Jan 1989

• Involved in the flow of stock from purchase of raw materials through production to sales of resulting goods. ACHIEVEMENTS: • Developed a computer program based on complex EEC rules, to plan the optimum time to book EEC subsidy: • Use of program saved at least one day per week of manual investigation and calculations by a senior employee. • Involved in the flow of stock from purchase of raw materials through production to sales of resulting goods. ACHIEVEMENTS: • Developed a computer program based on complex EEC rules, to plan the optimum time to book EEC subsidy: • Use of program saved at least one day per week of manual investigation and calculations by a senior employee.