Integration Specialist Dba

ADESOLA OLOYEDE

Phone: 678-***-****

Email **************@*****.**.**

PROFESSIONAL SUMMARY

I am a DBA who has been supporting database vendor and custom applications for 8 years. I have extensive experience in Data Wearhouse, data integration, ETL, database migration, cloud technologies, Disaster recovery, High availability, database security, performance tuning, data analysis database installation/upgrades and Cluster Management in SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012, SQL 2012, SQL 2014, SQL 2016, SQL 2017, Oracle (migrations) on various operating system (windows and Linux)

SKILLS

Active Listening

Administration and Management

Innovative

Coordination

Customer and Personal Service

Management of Personnel Resources

Project Management

WORK EXPERIENCE

DBA/Data Integration Specialist Nov 2016 Present

Infotech Remote

oInstalled and maintained multiple SQL Server environments.

oSQL Server Analysis Services (SSAS)

oSQL Server Integration Services installs (SSIS)

oSQL Server Reporting Services installs (SSRS)

oDeploy and Maintain API application

oProvide windows VM(Includes storage, Network, Security)

oInstall SQL Azure on VM and Azure database

oDesign Stretch DB on Azure Installed products.

oImplemented/Deployed products.

oDesign and Implement BI solutions using SSIS

oDeployed Agile in implementation of projects

DBA May 2014 Nov 2016

HomeDepot Atlanta GA

oWorked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.

oWorked With 'insert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).

oCreated new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005 and 2008 R2 and 2012

oSetting up and Monitored transactional replication, Database mirroring on Production and QA servers.

oWorked in Active-Active Cluster environment as a High availability solution.

oTuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

oExtensively used TSM litespeed backups

oChecking Database Health by using DBCC Commands and DMVS

oMonitored and modified Performance using execution plans and Index tuning.

oExperience in Database security and integrity planning

oUsed log shipping for synchronization of databases.

oInstalled and Upgraded from SQL Server 2000 and 2005 to SQL server 2008 R2 on Various Production Servers.

oMigrated Databases from SQL Server 2005 and SQL Server 2008 legacy application to SQL Server 2012 with deprecation of clustering and mirroring HA solutions and replace with Always On solution.

oWorked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.

oPrepared Documentation for the Disaster Recovery plan

oDesigned Data Integrator jobs with Error Handling and email notifications.

oManaging Databases spread across multiple servers in Production, Development, staging & testing environments.

oDaily routine DBA tasks like handling user's permissions and space issues on Production and Test servers

oInstalled and maintained 2-Node (Active-Active) Clustering as a High availability solution.

o Responsible to Monitor and troubleshooting Log Shipping.

o Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server

EDUCATION

Project Management

Oct 2007 University of Greenwich London

Certification

Microsoft Certification: SQL Server 2012/2014 (MCITP)

Agile Training co: Agile Fundamentals Course Cert. Dec 2021

Contact this candidate