WORK EXPERIENCE
SQL Server DBA
01/2020 - Present
DGtal-Mind Limited
•
Managing large SQL databases within a fast paced, highly transactional 24x7 environment for this leading online payment provider with clients in over 150 countries across the world
•
Manage test AWS EC2 database instances and set up regular test restore plan
•
Built and manage HA and DR systems using Failover Clustered instances, Availability Groups, Multi-site clusters and Replication across AWS Availability Zones
•
Configured and monitored performance, security and infrastructure metrics, ensuring high performance and availability as well as best fit for purpose infrastructure and security set up
•
Reviewed backup strategies and implemented recommendation to move long term backup snapshots to AWS s3 and Glacier Deep Archive resulting in significant savings
•
Using SQL Server Always On and Transactional Replication to scale out read traffic
•
Conduct real time monitoring and metrics generation with SEQ, SQL Sentry and DataDog
•
Manage indexing strategies, statistics updates and other maintenance activities
•
Review archiving strategy and liaise with software vendors and other third parties
•
Resolve issues and provide root cause analysis along with implementing preventative techniques
•
Analyse SQL query plans and leverage diagnostic tools to identify performance bottlenecks
•
Evaluate the merits/ benefits of available system upgrades and enhancements
SQL Server DBA
01/2019 - 12/2019
CapGemini/Swedbank (Solna, Sweden)
, Solna, Sweden
•
Working in a DBA Team of four on both Project work and BAU/Housekeeping duties
•
Projects – Task is to upgrade 4TB database server running SQL 2008 (SQL 2000 compatibility mode) to SQL 2017 ensuring that all Breaking and Behaviour Changes detected are fixed, tested and deployed to a new environment
•
BAU/Housekeeping – Ensuring that all scheduled jobs, backups and packages run accordingly, and any failure investigated and resolved
•
SQL Server installs – 2 node FCI/High Availability/Always On including Disaster Recovery
•
Working with development team in ensuring all database objects are fixed prior to upgrade
•
Troubleshooting using various SQL Tools –Query Store, Activity Monitor, Extended Events, DMV’s, Custom T-SQL Scripts, Powershell, PowerBI, PerfMon, SQL Server Profiler, Extended Events, SQL Data Collector and Database Engine Tuning Advisor
SQL Server DBA
08/2018 - 12/2018
Cheshire East Council (Chester, UK)
, Chester, UK
•
Working in a DBA Team of four on both Project work and BAU/Housekeeping duties
•
Projects – Estate Simplification, Application Simplification, Database Consolidation and Database Migration of all 2008 and 200R2 to 2016
•
BAU/Housekeeping – Ensuring that all jobs, backup and packages run accordingly and any failure investigated and resolved
•
SQL Server installs – Standalone and Failover Clusters (FC), Analysis Services, Reporting Services to High Availability/Always On
•
Working with development team in environment code refresh/releases including issues with database performance
•
Troubleshooting using various SQL Tools – System Centre Operations Manager (SCOM), Activity Monitor, Extended Events, DMV’s, Custom T-SQL Scripts, PerfMon, SQL Server Profiler, SQL Data Collector and Database Engine Tuning Advisor
SQL Server DBA
03/2018 - 08/2018
Tele2/Hexaware (Kista, Sweden)
, Kista, Sweden
•
GDPR enforcement on entire SQL Server Infrastructure
•
Managing SQL Server database environments from Test to Production including SQL Server installs – Standalone to High Availability/Always On
•
Working with development team in environment code refresh/releases
•
Developed and tested storage strategies and disaster-recovery plan for company’s operational database, delivering solution that guaranteed recovery performance and high availability
•
Troubleshooting using various SQL Tools – Activity Reports, PerfMon, SQL Server Profiler and Database Engine Tuning Advisor
Head of ICT/SQL Server Database Manager
11/2012 - 12/2017
Lagos State Residents Registration Agency (Lagos, Nigeria)
, Lagos, Nigeria
•
Managing a database estate made up of 8 million records (3.2TB data) running on Window 2012/SQL Server 2014 and 2016 Enterprise
•
Managing and ensuring the security and safety of the Agency’s computing operations including supporting the infrastructure necessary to deploy, operate and maintain the Agency’s communications and information systems. This includes the residents’ database and the Automated Fingerprint Identification System (AFIS)
•
Anticipating future infrastructure/network needs including identifying proactive solutions to satisfy such needs
•
Holding responsibility for capacity planning and scheduling vendor negotiations related to ICT
•
Serving as a technical expert representative across all teams, clients and the information technology industry
SQL Server Consultant
01/2011 - 10/2012
Centrica/British Gas (Staines, Middlesex, UK)
, Staines, Middlesex, UK
•
Development and environment support to Application and Development teams
•
Performance Tuning, Monitoring and Optimisation of SQL Server databases and instances
•
Project support from Design, Architecture, Applications environments Testing, UAT, Pre-Production and Production phases
•
Daily SQL Server Infrastructure health checks, monitoring and administration
•
BAU Duties including Replication (Snapshot, Merge, Transactional & Peer to Peer), Database Mirroring, Cluster Server monitoring, troubleshooting and administration; High Availability Always on setup, management and administration
Development SQL DBA
11/2009 - 12/2010
Sapient/Department of Health (Elephant & Castle, London, UK)
, Elephant & Castle, London, UK
•
Working for Sapient in various business units to ensure that all code development to production deployment was tested before rolling out to Production
SQL Server DBA
06/2008 - 10/2009
RBI (Reeds Business Information (Sutton, Surrey, UK)
, Sutton, Surrey, UK
•
Working in various lines of business to ensure that all code development to production deployment was tested before rolling out to Production including BAU duties
SQL Server DBA
06/2008 - 10/2009
Sagentia/Vodafone (Harston, Cambridge, UK)
, Harston, Cambridge, UK
•
Working with Vodafone in Kenya for the successful rollout of M-PESA (Mobile Money). Project involved millions of transactions per minute
SQL Server DBA
10/2008 - 10/2009
Citibank (Belfast, Northern Ireland)
, Belfast, Northern Ireland
•
Migration and consolidation project of SQL 6.5, 7.0, 2000 database servers to SQL Server 2008
Subject Matter Expert – SQL Server Platform
06/2006 - 12/2008
Getronics/Barclays Bank DSMP Project (Docklands, London, UK)
, Docklands, London, UK
•
Project involved upgrading all the business and critical line of business applications in all the bank branches in the UK
SQL Server Technical Design Architect
08/2004 - 05/2006
Clifford Chance (Docklands, London, UK)
, Docklands, London, UK
•
Worked on the Unity Project, which involved the design and architecture of Failover, Disaster Recovery AND Business Continuity for Clifford Chance global operations (London, New York, Hong Kong, Frankfurt, Amsterdam and Paris)
MS SQL Database Consultant
04/2004 - 07/2004
Experian (Nottingham, UK)
, Nottingham, UK
•
Project was a major implementation on behalf of a high street retailer in the set-up and rollout of Postilion Realtime and Office front-end applications with a back-end repository of MS SQL 2000 database servers running on Windows 2003 servers
MS SQL Database Consultant
01/2004 - 03/2004
Red Star Limited (Cambridge, UK)
, Cambridge, UK
•
On-line retailer (www.play.com) selling DVD’s, CD’s, Games and electrical equipment running 18 Production SQL 2000 Servers on a mixture of Windows 2000 and Windows 2003 servers. Task was to review persistent performance issues, security concerns, disaster recovery/backup and restores options
MS SQL Database Consultant
01/2003 - 12/2003
Avanade UK – BT/Accenture NHS Project (Leeds. York, UK)
, Leeds, York, UK
•
Conversion of all National Health Service (NHS) patient records from paper based to online
MS SQL Database Consultant
01/2003 - 12/2003
Foreign & Colonial (Investment Fund Managers) City, London
, City, London
•
Database Migrations from SQL 6.5 and SQL 7 to SQL 2000
Lead SQL DBA / Technical Architect
01/2001 - 12/2001
PricewaterhouseCoopers (Docklands, London, UK)
, Docklands, London, UK
•
Upzing of MS Access to SQL 2000. Database upgrades from SQL6.5 & SQL 7.0. Built/Configured 2 node Clusters for Production Environment
SQL DBA (Europe) / Web Administrator
06/2000 - 12/2001
IBM/Ford (Aveley, Essex, UK)
, Aveley, Essex, UK
•
Upzing of MS Access to SQL 2000. Database upgrades from SQL6.5 & SQL 7.0. Built/Configured 2 node Clusters for Production Environment