Experience

Emovis

• IT Services and IT Consulting
• 200 - 300 Employee

• Database Administrator

  • Apr 2019 - Present



Computershare

• Australia
• Financial Services
• 700 & Above Employee

• Senior Database Administrator

  • May 2018 - Mar 2019



emovis

• Leeds

• Contract SQL Server DBA

  • Feb 2018 - Apr 2018



AdviserPlus

• Human Resources
• 100 - 200 Employee

• Contract SQL Server DBA

  • Oct 2017 - Dec 2017

  Day to day management of Live SQL Server estate Code review and deployment Respond to database requests Performance enhancements Devised scripted environment refresh, includes replication Use of Redgate SQL tools (SQL Monitor, SQL backup Pro) Day to day management of Live SQL Server estate Code review and deployment Respond to database requests Performance enhancements Devised scripted environment refresh, includes replication Use of Redgate SQL tools (SQL Monitor, SQL backup Pro)



Unit4

• Software Development
• 700 & Above Employee

• Managed Services Consultant / DBA

  • Jul 2015 - Aug 2017

  Implementation and daily monitoring of tasks (SQL Server backups, database maintenance, housekeeping, UNIT4 Financials\Dream) for customers, to ensure good performance and secure with minimal downtime.Implement scripts (T-SQL) against all customer databases to gather metrics, identify indexing, volumes to ensure optimum performance is maintained. Implemented for Oasis Healthcare which immediately resulted in no downtime during period-end, unlike previous months. Implemented SQL Server Log Shipping for Rank Organization and SuperGroup. Process tested, documented with DR tests scheduled yearly. Customers now have proven recovery strategy. Provided SQL Server Administration to Costcutter during migration from Sage to UNIT4 Financials followed by ongoing day to day management. Early involvement meant the risky part of the project (i.e. go-live) happened seamlessly with minimal issues. This led to a “Customer Success Story” between UNIT4 and the customer.Developed scripts (T-SQL, PowerShell and DOS) to reduce time taken for customer daily database checks from 2.5 hours to 1 hour, saving 1 day (20%) per week. Writing Ad-hoc SQL and T-SQL scripts when required for customersPresented technical training course to ensure that customers can manage environments correctly. This covered SQL Server database administration as well as UNIT4 Financials and Dream. Collateral used internally, with customers and presented this at UNIT4 user groups.Lack of Oracle 12 and 13 database administration knowledge within development team caused issues at critical stages of product testing (data volumes and performance). Immediate issues resolved then scheduled time periodically to review and make any further changes. Resulted in continued availability of the databases by development.Increased revenue of Managed Service by identifying knowledge gaps with customers from support calls raised or leads, then promoting service through to sale. Show less

• Team Leader - Technical Support and Managed Services / DBA

  • Jul 2011 - Jun 2015

  Restructuring of Customer Services led to myself taking on this new role. Around 30% of time spent on Team Leader tasks with remaining time covering Database Administration tasks, Managed Service and providing 1st and 2nd line support to customers.SQL Server Database Administration for customers (backups, restores, maintenance tasks, housekeeping) and specific UNIT4 Financials \ Dream technical tasks for customers. Improve delivery of Managed Services by training the team on SQL Server administration so work can be shared.Dealing effectively with any escalations raised by keeping customers informed as well as stakeholders updated. When required, carried out customer site visits to discuss issues and providing solutions. Scheduled regular meetings with team and also individuals , ensuring SMART objectives in place. Ensured the team adheres to company standards and procedures. Show less

• Technical Consultant / DBA

  • May 2006 - Jun 2011

  New team put together to provide extended SQL Server database administration and CODA technical support to customers. SQL Server Database Administration for customers, including setup of tasks (backups, maintenance tasks, housekeeping, restores) and specific UNIT4 Financials \ Dream technical tasks. Promote CODA’s products and services and identify consulting opportunities.Investigate, document and resolve the managed services technical tasks and issues raised.

• Senior Technical Support Consultant

  • Jun 2004 - Apr 2006

  Made this move to the Support desk as office based and would allow me spend evenings at home with a young family. This role provided 1st and 2nd line support to UK CODA customers via telephone and remote connection to customer systems.

• Senior Technical Consultant

  • May 1998 - May 2004

  Brought in as an expert on UNIX and ORACLE to strengthen the consultancy team. This involved installation, configuration and technical troubleshooting of CODA product set on various platforms (Windows, UNIX) and databases (ORACLE, SQL Server) for customers.Due to lack of US consultants, I volunteered as resource in the US to troubleshoot CODA environments for customers. Worked for the customer Tower Group in San Francisco who were faced with many technical issues that prevented actual live running. Able to identify and prioritise issues quickly. Within 3 days, most issues resolved and excellent feedback received.I developed and presented technical training courses to customers and put together troubleshooting kit-bag for consultants. I used this collateral to provide technical training to CODA partners in South Africa.I spent several months working on a large project for customer STA travel. Using ETL and T-SQL, successfully configured a data warehouse in order that complex, highly transactional SQL Server database with large volumes could be reported on. Show less



Yorkshire Building Society

• United Kingdom
• Financial Services
• 700 & Above Employee

• Technical Analyst

  • Jul 1987 - May 1998

  Brought in to join a small Technical support team. Initially my role was support of BULL mainframes, administration of GCOS 7 TDS and writing of some COBOL programs. The society undertook a major project to move from mainframes to UNIX (HP-UX 11) and also rewrite systems in-house using ORACLE 7.0 software. I undertook ORACLE administration training and then worked on migration and database administration (Administration (installation, upgrades, backups, security). This involved configuration of 50+ ORACLE databases (Live and Test) to agreed OFA standard, and using ORACLE Parallel Server (OPS) to partition head-office and branch activity. Further developed and implemented an ORACLE logon system (ujsing ORACLE 7.0, BSH and KSH scripting) to ensure secure access for UNIX users and operators. Successfully led a project to migrate a share dealing system from newly acquired subsidiary to HP UNIX server within tight 8-week period to meet demands of Halifax Share issue. Coordinated UNIX and ORACLE parties, and responsible for creating database, migrating the data, which involved exhaustive out of hours to complete. Worked with a small team to implement an off-shore banking system (Oracle 7.0, Forms 3.0, Menu 5.0) within timescales. Responsible for configuration and support of UNIX (DEC ALPHA) and ORACLE on site at Guernsey. Subsequently migrated to HP-UX 10.0 platform. Show less



DONCASTERS MONK BRIDGE LIMITED

• United Kingdom
• Mining

• Senior Programmer

  • Jun 1985 - Jun 1987

  Responsible for maintaining and developing stock level systems on Data General MV/4000 using COBOL. Responsible for maintaining and developing stock level systems on Data General MV/4000 using COBOL.



WOLSELEY-HUGHES MERCHANTS LIMITED

• United Kingdom

• Programmer

  • Mar 1979 - May 1984

  Started as an operator on the mainframe and quickly made the move as trainee COBOL programmer. The work involved writing specifications , developing COBOL programs (JSP standard used), and testing and maintaining IDS2 hierarchical databases . Involved with migration of systems to Bull DPS/7 from Level 64 platform. Started as an operator on the mainframe and quickly made the move as trainee COBOL programmer. The work involved writing specifications , developing COBOL programs (JSP standard used), and testing and maintaining IDS2 hierarchical databases . Involved with migration of systems to Bull DPS/7 from Level 64 platform.