William G. Email & Phone Number

Dublin, County Dublin, Ireland

Dublin, County Dublin, Ireland

Please note that Globalshares was acquired by JP Morgan in early 2023. This acquisition prompted a thorough assessment of my role as a Senior Database Administrator, which resulted in its alignment with JP Morgan's grading system, now classified as a VP - Database Management.Leading the database management efforts following the acquisition of Globalshares by JP Morgan in early 2023.Managing SQL Server 2019, Azure Managed Instance, Azure SQL Database, and leverage Powershell for automation.I lead the Performance Improvement project on the legacy databases in order to maintain the current system requirements while leading the onboarding of a significant number of additional stakeholders.

Dublin, County Dublin, Ireland

Brought in to expand the DBA Team at Global Shares, with a primary focus on optimising and performance tuning of the SQL Server environment, addressing issues like long-running queries, deadlocks, and blocking chains.Utilised SQL Server 2019, Azure, and Powershell to enhance database performance.

Dublin, Ireland

Managed SQL Server 2019 on-premises while preparing the environment for potential migration to Azure.Migrated existing database servers to SQL Server 2019, documented and rewrote the ETL solution, and provided support for the development team.

Manchester, England, United Kingdom

As an independent contractor operating through my Limited Company, WSG Data Solutions, I have successfully provided expert database management services to various organisations, demonstrating adaptability and expertise across a range of industries. This unique career structure has allowed me to take on diverse projects while maintaining the highest standards of database administration. Below is a list of companies I've had the privilege of working with during this period:During this time I worked with various editions of SQL Server, Azure, AWS, Powershell and Docker.FRESHFIELDS, MANCHESTER, UKJuly 2019 to December 2019A significant decommissioning and migration project involving thousands of databases over hundreds of servers.RESTORE DIGITAL, SALFORD, UKFebruary 2019 to May 2019Evaluated and re-architected the client’s SQL estate to bring it up to standard.Managed a consolidation and migration exercise of their SQL Estate in preparation for cloud migration.HARVEY WALSH, RUNCORN, UKJune 2018 to November 2018Continued development on a multi-Terabyte data warehouse.INSURE THE BOX, NEWCASTLE, UKDecember 2017 to June 2018SQL Server 2008R2 Migration Project.HARVEY WALSH, RUNCORN, UKJanuary 2017 to October 2017Took responsibility for server provisioning, design, and implementation of a multi-Terabyte data warehouse using Kimball methodology.NORTHWEST E-HEALTH, MANCHESTER, UKAugust 2016 to December 2016Provided additional capacity in the Database Team.Designed a largely automated disaster recovery plan and presented a proof-of-concept for migration to Microsoft Azure.Mentored and trained a Junior DBA during this period.

Denver

I was the Senior Database Administrator on the DevOps Engineering and Architecture team at Healthgrades. I was also a Leader for the cross-team Database Administration chapter. In addition to business as usual work supporting both the SQL Infrastructure, both on-premise and in the AWS cloud; my primary responsibility was dealing with licensing true-up and Enterprise agreement with Microsoft. The resulting consolidation exercise saved the company $2.5M in SQL licensing and a similar amount in windows licensing.SQL Server 2014. Amazon Web Services. RDS. EC2. Licensing and Enterprise Agreement. Performance Tuning and Optimization.

Fort Collins, Colorado Area

I was brought in as a Senior DBA on the Development team at the National Resource Conservation Service. My primary responsibility was the development of database back-ends for applications, including conversion of a spreadsheet-based system to SQL from 250,000 spreadsheets. In addition, I carried out some performance tuning work for their existing applications. While there I discovered licensing issues that saved the department $1.5M.SQL Server 2012. Database Design. ETL. SSIS. Development. Licensing. Performance Tuning and Optimization.

Manchester, United Kingdom

I was the production DBA for a clinical trial collaboration between Manchester University, Salford Royal Hospital and GlaxoSmithKline. In addition to business as usual database administration tasks of monitoring, troubleshooting, optimizing and disaster recovery work; this role involved managing the change review process for SQL Server and carrying some SQL development work.SQL Server 2008R2. Virtualization. Disaster Recovery. Development. Change Review.

Salford, United Kingdom

I was the senior member of the Information Team responsible for management of the Development SQL Environment and the Production SQL Server Reporting Services Environment. I also carried out analysis of Health Data for waiting list management and patient outcomes. I provided support to the Production DBA where required. In addition, I acted as Deputy Team Leader for the Information Analyst Team when required. I was responsible for upgrading the organizations primary reporting infrastructure from ad-hoc Excel/Custom ASP reports to an organization SQL-SSRS structure. I also mentored junior staff in SQL development.SQL Server 2000, 2005 and 2008R2. SSRS. SSIS. Development. Analysis. Mentor. Leadership.

Salford, United Kingdom

Business Intelligence Developer on the Information Team.

High Wycombe, United Kingdom

Various duties including IT support.

Bachelor Of Science (B.Sc.), Pharmaceutical Sciences

Studied as a Pharmacist.

Bachelor Of Science (Bsc), Open Science Degree, Second Class Honours

Part time degree taken while working full time. Courses were all Biological Science.

Education record