William Gerrard

• Set strategic plans to govern functioning of database and analytic operations.
• Partnered with management team to optimise operations and reduce costs.
• Designed and developed data management solutions in line with client needs.
• Leveraged information security outlines to ensure compliant handling and management of financial and client data.
• Trained and mentored junior database personnel to share best practices and standardise strategies.
• Diagnosed and resolved performance, connectivity, security and database corruption issues.

• Built databases and table structures using database tools for web applications.
• Resolved performance issues quickly through accurate root cause identification.
• Assisted in creating database design documents, working with Dev and architecture team.
• Collected and analysed data, providing recommendations to help improve database performance.

• Resolved performance issues quickly through accurate root cause identification.
• Monitored alert log, memory, disk I/O and CPU usage as part of DBA daily activities.
• Provisioned and managed database instances, setting up replication and high availability.
• Diagnosed and resolved performance, connectivity, security and database corruption issues.

Director and Sole Consultant for the company. Providing Data Architecture, Management and Administration services to multiple clients across the North of England.

Clients included:

• The University of Manchester
• Freshfields, Manchester
• Restore Digital, Salford
• Insure the Box, Newcastle
• Northwest E-Health, Manchester

• Leader of a cross-functional team of Data Professionals across Development, Engineering, DevOps and Architecture.
• Responsible for a significant database consolidation project with a multi-million dollar budget working closely with Microsoft, Dell EMC and other vendors.
• Additional projects included working closely with Amazon Web Services as a partner on database and ERP migration to the AWS cloud.

• Built databases and table structures using database tools for web applications.
• Resolved performance issues quickly through accurate root cause identification.
• Assisted in creating database design documents, working with Dev and architecture team.
• Extracted and transformed data, accurately loading into data warehouse.
• Collected and analysed data, providing recommendations to help improve database performance.

DBA for the Salford Lung Study in collaboration with GlaxoSmithKline.

Started as a Junior Analyst and worked my way up to Deputy Team Lead / DBA.

• Generated reports from extracted data for analyses.
• Analysed large datasets, drawing meaningful conclusions and providing actionable recommendations.
• Improved data integrity with rigorous auditing and cleansing.
• Participated in requirements meetings and data mapping sessions to understand business needs.
• Developed dashboards that increased insights, interpretations and predictions for improved forecasting.
• Coached and mentored junior analysts in data mining best practices, uplifting team capabilities.