Käyttäjän adrianbrough profiilikuva
@adrianbrough
Jäsen alkaen 8. kesäkuuta 2017
0 Suositukset

adrianbrough

Online-tilassa Offline-tilassa
I provide Database Administration / Development and Commercial Analysis Services / Reporting Support on a freelance basis. I have experience in MS SQL Server 2008 and 2008 R2 and in MS SQL Server 2016 SP1 with particular T-SQL skill for reporting views. I have some experience of SSIS / SSAS and of Integration with MS Access and MS Excel. Before going freelance in 2016 I had 8 years Commercial Analysis and DBA experience with an Educational Publisher. Recent projects have included providing SQL support to convert an MS Access Database into MS SQL for a manufacturing SME, and setting up appropriate backup and maintenance processes. Also merging of three sets of customer records (100k in total) from different CRM's in a clients new CRM using Google bigQuery.
$44 USD/hr
3 arvostelua
4.5
  • 100%Suoritetut työtehtävät
  • 100%Budjetin mukaisesti
  • 100%Ajallaan
  • N/AUudelleenpalkkaamisaste

Portfolio

Viimeaikaiset arvostelut

Kokemus

Freelance Database Administrator and Developer

Dec 2016

Freelance database work mainly in MS SQL and MS Access for a range of companies and via online freelance sites.

Database Administrator (c0mmercial Analyst till 2012)

Jan 2008 - Dec 2016 (8 years)

I maintained on and off site production and test SQL instances including a MS SQL 2008 R2 cluster and replication processes between instances. I checked in a complex set of databases and simplified the inter-dependencies between them using SSDT in Visual Studio + Redgate's SQL Toolbelt adding tSQLt tests and developing robust rollout processes. I provided additional IT support for reporting processes and forecasting.

Authorizations Officer

Dec 2006 - Jan 2008 (1 year)

Authorisations Officer in a fast moving Membership Department assembling paperwork to gain Financial Services Authority authorisation for financial advisors. Required rapid analysis of the content of complex files and triaging of issues by importance. Initially employed via an agency but subsequently directly employed. A good eye for detail needed and also considerable tact in chasing up advisor's paperwork and references.

Lecturer

Sep 1999 - Jul 2006 (6 years)

University Research Fellow then Lecturer in Solid State NMR of Engineering [login to view URL] for funding. Management and supervision of research students and contracts. Lecturing and examining. Main workload in research using and maintaining / troubleshooting complex analytical equipment, and analysing results to build up patterns and conclusions. Significant programming to automate fitting / analysis of results. Published extensively in peer-reviewed journals.

Koulutus

MA, Chemistry, Merton College

1986 - 1989 (3 years)

D Phil (PhD) NMR Spectroscopy of Inorganic Solids, Merton College and Inorganic Chemistry Lab

1990 - 1994 (4 years)

Todistukset

  • SQL Level 1
    95%
  • US English Level 1
    95%

Varmennukset

  • Facebook yhdistetty
  • Suositeltu freelancer
  • Maksutapa varmennettu
  • Puhelin varmennettu
  • Henkilöllisyys varmennettu
  • Sähköposti varmennettu

Omat vahvimmat taitoni

Selaa samanlaisia freelancereita