OLUWAFEMI POPOOLA ADEREMI

adhouc@r.postjobfree.com, +1-301-***-****

Professional Summary

I am a Microsoft Certified Professional with over 5 years of experience in Database Administration, System Analysis, Design and Support of MS SQL Server 2017/2016/2014/2012/2008R2/2008/2005 in Production, Test, Development, Stand-alone and Clustered Environments.

Expertise in Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR) Solutions.

Hands on in setting up and troubleshooting Always On, Clustering, Database Mirroring, Log Shipping, including Replication models (Snapshot, Transactional/Merge).

Experience in Database Backup and Restore/Recovery, Query Optimization, Security, SQL Server Installation, Configuration of Stand-alone and Clustered environments

Experienced in Migration/Upgrade, applying service packs and routine DBA operations like database health check, index optimization, updating statistics, client/server connectivity and capacity planning.

Experienced with creating and support ETL processes, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Responsible for securing SQL Server, User Management, assigning permissions and roles

Experience with database Cloud Azure

Brentwood Trade and Integrated Services, New York

SQL Server Database Administrator April 2017 till date

Brentwood Trade is a Financial Service Firm, I was part of the DBA team that managed over 500 databases in a highly available Multi-Terabyte environment.

Responsibilities.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of DTS Packages to load the Data from various Databases and Files.

Configured Delayed Log Shipping for synchronization of Production Database with Standby Database.

Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server enterprise manager, Database Wizard and Transact SQL Statements.

Analyzed long running /slow queries and tune the same to optimize application and system performance.

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.

Implemented Snapshot replication. Used Log shipping for synchronization of database at the DR Site.

Created Linked Servers to another Database Server (SQL, Informix and Oracle).

Developed and Maintained a Version / Change control in SQL Code such as Procedures, Views.

Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.

Analyzed long running slow queries and tune the same to optimize application and system performance.

Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment. Controlled and coordinated the installations (Security Patches, Service Packs).

Regular Database Maintenance process, Checking the disk, Defrag procedures in Development environments.

Used SQL Profiler for performance monitoring to resolve Dead Locks and Long running queries by checking appropriate changes.

Documented standard operating procedures (SOP), database administration standards and best practices for all the major SQL Server activities including installs, patches, upgrades, database maintenance plans, retirements, security standards, etc. Documented disaster recovery procedures to bring the server/ database online quickly, in case of any drive corruption or server issues or service pack failures.

Environment: SQL Server 2008/2012/2014/2016/2017

Vomoz Communications, Columbia, MD 21045

SQL Server Database Administrator January 2015 – February 2017

Involved in Technical sessions to enhance the new features for Business Work Flow.

Involved in controlling and co-coordinating the installations (Security patches [Patch Management], Service packs) and system performance before pre-deployment.

Use all the SQL Server tools for the Implementation and Administration of the databases. The tools include Performance Monitor, Profiler Trace, Index Tuning Wizard, ISQL, OSQL, Query Analyzer, Enterprise Manager, Component Checker, Regmon and Filemon.

Setup and troubleshoot for Active/Passive Clustering on SQL Server 2008. Setting up DR sites using Log-Shipping and Monitored and maintained Log Shipping of Databases from production server to DR server.

Configured Disaster Recovery solution using Log Shipping for maintaining the databases

Setup Snapshot, Transactional Replication b/w Servers. Troubleshoot monitor Publishers, Distributors, Subscribers

Involved in upgrading of existing Servers from SQL Server 7.0 to SQL Server 2008.

Performed Database Refresh tasks from Production to Development and Staging Servers

Used Perfmon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes.

Involved in Creation of logins, Users as per Security standards and groups, roles, jobs, alerts and sending mail confirmation upon tasks. Performed Uploading of bulk data using BCP Utility

Database support with Store Procedures, Cursors and Queries, monitoring the flow of Order Management by the Oracle Back-End support using TOAD tool.

Interaction with Development and Testing team to support the E2E Business applications

Environment: SQL Server 2008/2012

Skills.

-Ability to research

-Multitasking

-Good communication skill

-Problem solving abilities

Education

Certification:

2006-2010 business administration Obafemi Awolowo University

2018 Microsoft Certified Professional Microsoft

2020 Microsoft Azure Administrator

2020 Microsoft Azure Fundamentals

Reference: Available on Request.

Contact this candidate