Simon Bartlett Email & Phone Number

Manchester, England, United Kingdom

Providing expert SQL server knowledge to assist the company through peak (Black Friday/Cyber Monday weekend) following a massive On Prem Sage 200 2011 on SQL2008R2 upgrade to AWS/Sage 200 2019/SQL 2017 upgrade. Predictably there were significant issues; the DB is 8TB with 3000 users (against a Sage published “large deployment” of 50 users/500GB). The work.

Nottingham, United Kingdom

QA of third party data warehouse design plus BAU work on existing DW components developed inhouse over a long period.

Ipswich, United Kingdom

Providing expert SQL Server migration support. Willis had bought a French insurer, Gras Savoye, with extensive interests in Africa. These local offices’ applications were to be migrated into central management with data centre – based SQL Servers and Citrix hosted applications. The role was to recover the DBs, update where possible to supported versions of.

Bournemouth

Providing ETL development expertise to help prepare for GDPR requirements, including redevelopment of existing SSIS packages, stored procedures and functions as well as creating new ones. Coding for obfuscation of data on data – subject request including analysis of fields which would be deemed Personal or Sensitive data, while leaving the data warehouse.

Stoke-on-Trent, United Kingdom

Nottingham, United Kingdom

Bruntingthorpe Airfield And Proving Ground

Providing specialist SQL Server expertise, covering redevelopment of existing databases and associated objects (stored procedures, views, triggers etc) to overcome significant performance issues in the automotive management application written in - house, and to facilitate the development of the new management software by scripting a new SSIS ETL package.

York, United Kingdom

Providing a broad range of DBA services within the DBA Team. A mixture of production DBA, ETL, BI and SQL Server development work.

Sandycroft, N Wales

Providing migration consultancy and resource to lead the move of a large number of databases and applications from a variety of SQL2000, 2005 and 2008 servers to all new SQL2012 SP1 clustered master with SQL2012 SP1 on a number of VMs for replication/load spreading (scale out) to serve all of the company's web presence as well as MI reporting on SSRS.

RAC Control Centre, Walsall

SQL DBA/SSIS developer to provide DBA and release capability plus third party management and liaison with the outsourced infrastructure provider. Entota was building a range of data warehouses with all of the associated ETL to facilitate the separation of the RAC from Aviva and provide internal management reporting and data analysis and I was involved in.

Congleton

Classic SQL DBA role. Brought in to complete a migration from an old SQL2005 cluster to a "new cluster" to clear the out of support SAN and allow decommissioning, but the "new cluster" was actually not a cluster but a mirrored solution implimented by the previous "DBA" whick was not fit for purpose with very expensive loss of production if the main DB is.

Provided expert SQL Server development and DBA knowledge to the well known price comparison website provider. Taken on for the final stages of the release of the new Home Insurance channel’s development to assist an existing DBA. Immediately identified a number of issues with partitioning and purging procedures which I rectified; also spent time scripting.

I provided expert SQL Server knowledge to a financial company. I was again involved in a wide variety of tasks, including routine monitoring of live and DR systems, staging and production releases, quality reviews of developers’ code, assessment and instigation of changes including service packing of clusters and an in – depth licensing review and wrote a.

I provided expert SQL Server knowledge to a car dealership accounts system company whose database systems have grown rapidly from very small beginnings to an unmanageable size. The systems were largely written by non – SQL Server developers and as such the scalability was very poor. I was involved in a wide variety of tasks, including re – writing existing.

A typical DBA role, working as part of a team of 11 DBAs spread across 4 offices in 2 countries with business customers and other IT functions even more dispersed. The role included all aspects of production DBA work, third line support, development, SSIS ETL, SSRS reporting, proactive and reactive service improvement, documentation and project co –.

Ba (Hons) Equivalent, Management & Leadership

Education record