Experience

• 

  London & Quadrant

  • Sidcup, Kent, United Kingdom

  • Database Manager

    • Oct 2011 - Present
    • Sidcup, Kent, United Kingdom

    Mike is responsible over 50 SQL servers and 500+ databases. All production server runs under window cluster in active-passive mode and database are replicated for High Availability for Disaster Recovery. All servers and databases are actively monitor using Red Gate monitoring tool for any issues with threshold setting.• Installing, configuring, administering, supporting and securing SQL 2005, SQL 2008 R2, 2012 and SQL 2016 servers including Alwayson replication, Mirroring and Log shipping.• Database administration using MS SQL 2000/2005/2008 R2/2012/2016, SSIS, T-SQL, Reporting Services (SSRS), data analysis and design, file structures, retrieval and access methods, capacity planning, data modelling, strategic planning, project implementation and data replication.• Responsible for backup, restoration, maintenance plans and databases security in production/development environments. • Batch programming, stored Procedures, triggers with T-SQL and optimizing queries.• Upgrade SQL Server 2005 to SQL 2008 R2, SQL 2012 and SQL 2016• HA / DR solutions (Always on, Mirroring, Peer-Peer replications and Log-shipping)• Responsible for SQL Server Hardware Resource Planning• Responsible for archiving of data and availability of data for further analysis

• 

  Santia Consulting Ltd

  • Crawley, UK

  • MS SQL DBA

    • Jun 2010 - Sep 2011
    • Crawley, UK

    Mike was SQL DBA who is responsible for looking after Health and Safety databases and providing data service for large clients for marketing including local authority and FTSE 100 companies. • Database Administration • Database administration using MS SQL 2000/2005/2008, SSIS, T-SQL, Reporting Services (SSRS), data analysis and design, file structures, retrieval and access methods, capacity planning, data modelling, strategic planning, project implementation and data replication.• Responsible for backup, restoration, maintenance plans and databases security in production/development environments. • Batch programming, stored Procedures, triggers with T-SQL and optimizing queries.• Upgrade SQL Server 2000 to SQL Server 2005 and SQL 2008• Transform and Uploading of periodic data from remote with DTS, SSIS packages and Configuring SQL clients.• Administering around 10 databases and some large databases over 2 TB• 24/7 Production support• Data Integration from legacy system DB2, Excel to SQL 2000• Administering Sales Force CRM system• Relational Junction (Sesame) ETL tool for administering the Sales Force CRM system in SQL 2008 database• Data servicing , cleansing, de-duping, comparison with in-house database and Experian databases

• 

  London Capital Group

  • London, United Kingdom

  • Database Administrator

    • May 2007 - Apr 2010
    • London, United Kingdom

    Mike was assigned the role of the Database Administrator to carry out full database design and implement a new web base spread trading system. He was responsible for disaster recovery setup and data migration from legacy system to new trading platform. His responsibility included: • Installing, configuring, administering, supporting and securing SQL 2005 servers. • Providing consultation on SQL Server and database design to development and analyst teams. • Implementing database design, schema modification and application architecture as per business requirements • Installing and configuring SSRS and SSIS package• Responsible backup/restore, maintenance plan and disaster recovery plans for production and development environments. • Troubleshooting performance issues and fine-tuning queries and stored procedures. • Implementing and administering database replication between SQL Server databases, i.e. data mirroring, merge replication, transaction replication. • Writing T-SQL, Store Procedure, triggers and creating jobs to automate repetitive tasks. • On call Production Support of Live systems• Upgrading and upsizing databases from earlier versions to the latest versions• Data migration from legacy system using ETL• Deployment of new software release management from various environments to production• Setting up Disaster recovery environment in compliance with FSA regulation and client requirement • Liaising with Trading companies Reuters, Tenfore and Currenex for live trading feeds• Setting up window cluster for fault tolerance • Assisting Developers in Java & Hibernate for database access

• 

  Chaucer Consulting

  • Faversham, Kent

  • Senior consultant

    • 2005 - 2007
    • Faversham, Kent

    As a senior consultant Mike has worked with various companies within the UK and International to implement full system integration and to provide top level support. • Provide process, data and object modelling in a variety of application & database environments.• Provide database design, development, and enhancement, as well as management and coordination of changes to existing applications.• Maintain senior level expertise and currency in industry leading information management technologies• Serve as Project Lead or Project Manager via management of end to end• System life cycle development of major projects.• Develop costing proposals for projects, perform risk analysis, and manage change control.• Provide business analysis, business area assessment, user needs analysis and business systems design for major projects.• Project documentation• Provide senior level programming as required.

• 

  CP Ships

  • Crawley, UK

  • Project Manger/Database Adminstrator

    • 1979 - 2005
    • Crawley, UK

    During his employment with this organization he implemented an SAP financial system, shipping documentation and container tracking systems and various other IT systems. His responsibilities included full program life-cycle from inception to post implementation review of the new systems. He was been responsible for building various interfaces with third parties (Customs & Excise, Port Authorities, Ford, General Motors etc) using international EDI standards (ANSI X12 and Edifact message standards). He has been involved in various data migration activities.He also assisted in setting up the offshore helpdesk facilities including disaster recovery.