Darryl Wilson
(SQL Developer & Infrastructure Specialist)
Flat 9, 32 Foxendale Close, Northwich, Cheshire, CW8 4GY
E-mail: *********@*******.***
www.linkedin.com/in/darrylwilson
Mobile: 077********
Profile
Experienced SQL Developer of 15 years. Significant knowledge of all aspects of the Microsoft SQL stack including both Application and Infrastructure. I am confident using SSIS and SSRS, writing TSQL scripts and SSIS packages to facilitate complex integration requirements. I am experienced in providing documentation and have delivered training for Systems delivered. I can converse with all levels of expertise; including Clients (internal/external) and Management. In my current role I am working in Professional Services at Manchester Metropolitan University and have gained invaluable experience in the Higher Education Sector.
Education
HND Software Engineering
BTEC National Diploma Computer Studies
Core Skills
Skill
Expertise Level
SQL Server Integration Services
Intermediate
SQL Server Reporting Services
Strong
SQL Server Administration
Strong
TSQL
Strong/Expert
Classic ASP
Expert
SQL Server Design, Configuration and Installation
Intermediate
SQL Server Performance Analysis
Intermediate
Business Intelligence Tools
Intermediate
Oracle
Experienced
PowerShell
Experienced
Career Summary
Manchester Metropolitan University (Fixed Term Contract)
Nov 2020 – May 2021 Mar 2019 – Jun 2020
3rd Line SQL Database Engineer
Providing SQL Support at a 3rd Line Support level for many departments across the University. On a day to day basis I am working in the Infrastructure team with strong support ties to Business Systems and the Student Journey Operations teams. Supporting these teams requires a high level of SQL knowledge alongside the Infrastructure knowledge to enable the standard of support required. In the Infrastructure team additional responsibilities include SQL Server administration, backups, restores, creating queries. Liaising with Internal Clients assisting them with the setup and maintenance of databases and queries. I use a helpdesk system as a stream of work, along with Daily BAU tasks (that involve PowerShell scripts to check for disk space and failed backup jobs). I install SQL Server to servers, adhering to a predefined structure and file locations. I setup the users and grant access as (and when) required, using Windows and SSMS. I also apply patches to SQL Servers when available outside of working hours.
Combined NHS (Permanent)
Jan 2018 – Mar 2019
Developer
Designing and implementing Lorenzo iForms.
Reason for leaving: Opportunity at Manchester Metropolitan University
Hempsons (Permanent)
Mar 2017 – Oct 2017
Database Developer
Maintaining Multiple websites across different database installations. Creating Queries, Views and Stored procedures, integrating with Lexis Nexis Visual Files. Creating Documentation. As changes and new items arose, I had to liaise with staff to gather and document their requirements/changes.
Reason for leaving: Redundancy
Kindertons Mgmt (Permanent)
Sep 2015 – Feb 2017
Database Administrator
Working on a helpdesk, creating jobs and assisting users to solve their issues. I was heavily involved in SQL Query writing using SQL Server and Access. I maintained the databases, and created import facilities using different formats of data. I backed up and restored databases. I liaised with Users to communicate issues and solutions. I used SSIS to run SQL Stored Procedures on a Schedule. I designed/updated Views/Stored Procedures and set the permissions for required Users. I created Views and conversed with Directors to give them daily up-to-date data. Investigated the use of Power BI as a replacement to Access queries.
Daily, I would provide support to users and explain how to properly create queries. When users would want a new job or amending an existing object, I would gather their requirements and document them.
Reason for leaving: Lack of Progression Opportunities
Aintree University Hosp (Contract)
Feb 2015 – June 12 2015
DB/Web Developer
Making amendments to existing e-procurement stock system. Integrating with JAC to authenticate users, allowing the direct ordering of stock and integrating with existing system parts. Creation of SQL Databases, integrating with JAC Database, Import and export of data. Creation of indexes and Users, Stored Procedures to Speed up programming execution.
Reason for leaving: End of Contract
The Walton Centre (Contract)
Sep 2012 - Apr 2014
DB/Web Developer
Design and implementation of the TONiC website, creating questionnaires and analysis of data. Other work includes internal websites. Creation of TONiC Database from scratch, creation of regular backups and disaster recovery procedures. Use of stored Procedures and Indexes to speedup execution.
Reason for leaving: End of Contract
Askews Library Services (Contract)
Aug 2011 - Aug 2012
DB/Web Developer
The creation of a Stock Management System that imports data from csv format (includes Marc21) into a database and then displays statistical data for a given time period. Also produces graphs. A recommendation application makes suggestions for books to stock. Use of SQL Server to create the database and creation of backup/recovery procedures. Us of TSQL to interrogate the database on an adhoc frequency.
Reason for leaving: End of Contract
ADZMedia (Contract)
Oct 2010
DB/Web Developer
Short term contract fixing broken website by implementing new DTS script, also updating ecommerce script.
Reason for leaving: End of Contract
Mandogroup (Contract)
May 2010
Web Developer
Short term contract fixing broken website by implementing new upload dll. Involved Analysis of pages and bug fixing. Use of SQL Server to create the database and creation of backup/recovery procedures. Us of TSQL to interrogate the database on an adhoc frequency.
Reason for leaving: End of Contract
CITS (Contract)
Oct 2009 - Feb 2010
Web Developer
Development of Clients’ applications using VB, SQL Server, MS Access, ASP and IIS to create Applications and set up Virtual directories. Liaising with clients to continually deliver quality software to specification.
Reason for leaving: End of Contract
Hugh Baird College (Contract)
May 2009 – Oct 2009
Web Developer
Contract fixing broken website by implementing new DTS script, also updating ecommerce script.
Reason for leaving: End of Contract
Further Employment History Available on request
Personal Details
Driving License
Full (Clean)
Car Owner
Yes
Interests
Snooker
Bismarck & Titanic History
References available on request