Gboyega Adepegba

[email protected] • +44 845 226 1990

LinkedIn: http://www.linkedin.com/in/gboyegaadepegba

PROFESSIONAL SUMMARY

An analytical, logical and innovative person with strong intent to enhance business performance; easily adapts to various working environments with a profound resolve to deliver high standards to both clients and employers. Experienced in working to tight deadlines with a strong focus on prioritising workloads; Proactive approach to fault diagnosis, information gathering & business analysis and ability to learn quickly; Currently seeking a challenging opportunity to enhance experience and further career development in IT.

WORK EXPERIENCE

SQL Server DBA

01/2022 - Present

Managed Services Provider based in London )(Non-Police Personnel Vetting (NPPV) / Security Check (SC))

• Administration and management of over 100 clients SQL estate by determining root cause to prevent repeat occurrence

• Engage in database projects including full system design, in situ server/database upgrades performance tuning, Azure migrations, disaster recovery and high availability

• SQL Server Relational Database Engine Database administration from SQL 2008 to 2019

• Microsoft Azure implementation, administration and support (PaaS , Managed Instances and VM's)

• Disaster recovery including log shipping, Mirroring and Always on availability groups

• Architecture, design and implementation of highly available database solutions (OLTP)

• Replication Transactional, Merge and Peer-to-Peer

• Database & Application performance tuning using Extended Events and SQL Profiler

• Large-scale data manipulation and Extract Transform and Load (ETL) using SQL Server Integration Services, Transact-SQL code and other techniques

• OLAP cube architecture, design and implementation using SQL Server Analysis Services

• Work with customers and delivery partners to help define and deliver high impact solutions based on Microsoft’s data stack

• Work with management when necessary to resolve sensitive account issues and to effectively manage customer incidents (Major Incident Management and Problem Tickets)

• Provision of direct technical thought leadership and services to external teams, stakeholders or customers

SQL Server DBA

01/2020 - 12/2021

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

• Managing mission critical line of business applications dependent on SQL Server databases

Head of ICT/SQL Server Database Manager

11/2012 - 12/2017

Lagos State Residents Registration Agency (Lagos, Nigeria) , Lagos, Nigeria

• Greenfield project undertaken to register population made up of 23 million residents within the state on a central database

• Project Management, Vendor Management, Database Management and Budgeting

• Tools & Environment: MS SQL Server 2008R2, 2012, 2014 and 2016. BMC Remedy and Atlassian JIRA

SQL Server Consultant

01/2011 - 10/2012

Centrica/British Gas (Staines, Middlesex, UK) , Staines, Middlesex, UK

• Working in various business units to ensure that all code development to production deployment was tested before rolling out to Production

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)