Database Administrator Ssis

Professional Summary

Olanrewaju Alagbe

***********@*****.*** 346-***-****

GreenBelt, MD

P

• Over 8 years’ experience supporting Microsoft SQL Server Databases OnPrem and in the cloud.

• Over 2 years’ experience supporting PostgreSQL onPrem and in the cloud.

• Over 4 year experience working with Azure, AWS, GCP architecting and deploying database solutions in the cloud.

• Experience working with Devops tools (GitHub, Bitbucket, AzureDevops, Jenkins, Docker, Kubernetes).

• Experience working with Very Large Database (VLDB) and Data Warehouse setups.

• Solid experience with High availability and Disaster Recovery solutions, Always-On, Mirroring, LogShipping.

• Experience in Disaster Recovery Planning and Setup

• Knowledge of TSQL, Yaml, Json, Pythion PowerShell Scripting for automation

• Experience Working With SSIS, SSRS, Power Bi and Tableau for reporting and data visualization.

• Experience in Upgrading/Migrating to different versions of SQL server.

• Knowledge of Windows Server Administration.

• Experience in Supporting thousands of SQL server.

• Supporting Reporting Servers (SSRS), Integration Services (SSIS), Analysis Services

(SSAS)

• Deploying changes and rolling back changes from production.

• Working with team in an agile environment. maintaining

• Creating documentations and SOPs for configuring, maintaining, and troubleshooting DBs

• Supporting 2005, 2008, 2012, 2014, 2016, 2017, 2019, Azure SQL, Azure Managed Instance, SQL VM Instances both on premises and in the cloud. Recent Projects

• Migrating From over 200 DBs to Azure SQL, Azure Managed Instance, SQL on Azure VM.

• Migrated SQL Server Databases to PostgreSQL

• Migrated legacy Applications from SQL 2005,2008 to 2019 SQ Server WORK EXPRIENCE

GIC Markets

SQL Server Database Administrator Jul 2017 – Present I am a part of a global team that manages over 2000 SQL servers with over 7000 Databases in Prod, Stage and Test Environment.

Responsibilities

• Provisioning Databases and configuring appropriate HA/DR strategy based on the RTO/RPO of the business division.

• Configuring, Maintaining and troubleshooting Log shipping, Mirroring, Always On Availability Groups, SQL server Failover cluster on same and multiple subnet.

• Carrying out performance tuning task on a regular basis on issues ranging from query tuning to index optimization, TempDB issues, to IO, High CPU usage, severe blocking, long running query, always on out of sync, mirroring out of sync, log shipping out of sync.

• Maintaining SQL Server Cluster setup and configuration

• Weekly Patching of Standalone and Cluster instances

• Migrating and Upgrading SQL server from Legacy to 2014, 2016, &2017

• Creating and supporting ETL process from Oracle to SQL server, Sybase to SQL server, Access to SQL server, Excel to SQL Server.

• Managing permissions and security.

• Monitoring daily, weekly, Monthly and quarterly Maintenance Task, ensuring that its successful and jumping into resolve issues when it fails

• Automation of repetitive task Using PowerShell.

• Carrying out regular health checks across thousands of servers using PowerShell script.

• Maintaining database space issue, resolving excessive log growth issue, and Normalization of DBs

• Worked with other team members to implement changes to server, instance and database.

• Provide regular supports to application owners and develop CityPrime

SQL DBA Feb 2015 – Dec 2017

CityPrime FX is a Financial Service Firm dealing with FX, CFDs and Global Equities I worked as a Microsoft SQL Database Administrator managing 150 Databases. RESPONSIBILITIES

• Implemented Always-On Availability Groups (AAG) and HA/DR Setup and Configuration

• Performed Regular Backup and Maintenance Jobs across the 150 Database Managed

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

• Installed and administered 3-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

• Migrated database from on premise to Aws Cloud.

• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

• Rebuilding / monitoring the indexes at regular intervals for better performance.

• Recovering the databases from backup in disasters. Implementing Point-In- Time Recovery solutions.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Involved in Source Data Analysis, analysis and designing mappings for data extraction using log shipping.

• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re- index and update statistics in databases.

Education

Jan 2004 – June 2009 Olabisi Onabanjo University Computer Science Feb 2010-Aug2011 Edutech Lagos MS-SQL Server Administration

Contact this candidate