Andrew Jefferson

Experience

• 

  Electrolux

  Feb 2002 - Mar 2005

  IT Specialist
• 

  Alexander Forbes

  Apr 2005 - Sept 2007

  IT Specialist & MSSQL DBA
• 

  Absa Capital / Barclays Capital

  Jan 2007 - Aug 2011

  Database Manager

  MSSQL Clustering, Mirroring, Log ShippingMSSQL Service Broker, Event NotificationsPerformance Optimization / TuningDesigning Software implementationsJob Design, Monitoring, TroubleshootingMigrating MSSQL & Sybase SystemsUpgrading MSSQL from version 8 to 9 or 10Upgrading Sybase from version 12 to 15Oracle to MSSQL and Sybase DB ConversionsSybase to Oracle and MSSQL DB ConversionsMSSQL to Oracle and Sybase DB ConversionsUNIX / LINUX solution scriptingDesigned custom Sybase high availability solutionTechnical Documentation / DR Test URLD'sOccasional Windows Server AdministrationDesigning disaster recovery solutionsXML data conversions solutionsETL process design and implementationDevelop Tactical / Strategic Reporting SolutionsGlobal support for MSSQL - LDN / NYK / SGP / SOX Control OfficerMSSQL & Sybase Custom AutomationAutomation of MSSQL administration tasksSybase / MSSQL ß à Oracle DB MigrationsDesigning custom MSSQL security solutionsDBA Team Management / DevelopmentReport Directly to IT Production HeadABSA Capital DR Site ManagerMigrated Ex-Leyman’s estate to Barclays Capital Show less

• 

  Financial Intelligence Centre

  Oct 2011 - May 2012

  Database Manager

  System StabilizationDatabase Design and Development Partitioning and Advanced ArchivingDesign and Implementation of SOP’sDesign and Implementation of Standardization Database ConsolidationDatabase Upgrades and MigrationsEPM and UCP ImplementationCapacity and Availability planningDatabase EngineeringPerformance Tuning and OptimizationEnterprise Policy Management Implementation

• 

  Standard Bank

  Apr 2012 - Jun 2015

  Lead BICC Database Developer, Administrator and Integration Specialist

  Responsible for taking manual operations and transforming them into automated systems. My largest accomplishment so far at Standard Bank is having automated the Enterprise Performance Management and Renumeration process for Standard Banks 44,000 Employees across the globe into a 3rd Party cloud based solution, Besides the initial data load, the process also manages all incremental updates, be it modifications or new items.Other General Duties as listed below.Operational Data Store Development, SAP Queries and Extractions,Developing an Integration Layer,Data Profiling,Advanced Archiving,Partitioning and Data Compression,Indexing and performance tuning, Show less

• 

  JSE

  Jul 2015 - now

  MSSQL Team Lead | Senior Database Design and Engineering