Post Job Free

Resume

Sign in

Database Administrator

Location:
Laurel, MD
Posted:
May 07, 2021

Contact this candidate

Resume:

OLUWATOMISIN ALABI

267-***-****

adl76u@r.postjobfree.com

Profile:

An extraordinary motivated and confident Database Administrator with over seven years of experience with a good eye for detail, highly knowledgeable in Microsoft SQL Server Database both on-premises and in the cloud, Design, Development, and Support of SQL Server 2019/2017/2016/2014/2012/2008R2/2008/2005. I am very ambitious and hope to be able to challenge assumptions and induce the introduction of new ideas and concepts on a practical and technological level. Work Authorization: Permanent Resident

Experiences:

Caresify Philadelphia, PA

SQLServer Database Administrator 01/2019 - Present

• Work with the configuration of Windows Server Failover Cluster (WSFC).

• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

• Work with SQL Server In-Place Upgrade from lower versions of SQL Server to higher versions.

• Experience in using SQL Server Tool like import/Export Wizard, SQL Server Enterprise Manager, SQL profiler and SQL Query Analyzer

• Work with migration of databases from one Windows Server and SQL Server instance to another Windows Server and SQL Server instance including the migration of all objects within the instance.

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Assist developers with complex query tuning and schema refinement.

• Work with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tool

• Work with backups, restores and recovery models

• Experience with E.T.L Tools (SSIS, SSRS, BCP, import & Export Wizard) for Extracting Transforming and Loading Data

• Advanced Knowledge of TSQL

• Work with the configuration and installation of AlwaysON High Availability Group with up to five replicas.

• Experience in setting up encryption (Transparent Data Encryption TDE)

• Implementing of SQL Logins, Roles & Permissions.

• Manage Azure SQL Server Database through multiple product lifecycle environments, from development to mission critical production system

• Migrate SQL Server databases from on premises to Azure SQL Server. Wolters Kluwer Philadelphia, PA

SQL Server Database Administrator 12/2016 - 01/2019

• Provisioning Databases and configuring appropriate High Availability and Disaster Recovery strategy based on the company RTO/RPO.

• Install SQL Server 2014/2012/2008R2/2008

• Migrating and Upgrading SQL server from 2014, 2016 and 2017

• Configures, Log shipping, Mirroring, AlwaysOn Availability Groups, replication SQL Server Failover Cluster.

• Monitoring daily, weekly, monthly, and quarterly Maintenance Task, ensuring that it's successful and jumping in to resolve issues when it fails.

• Carrying out performance tuning tasks regularly on issues ranging from query tuning to index optimization, TempDB issues, severe blocking, and long-running queries.

• Automation of repetitive tasks Using PowerShell.

• Involved in troubleshooting and fine-tuning of the database for its performance and concurrency complete documentation about the database Designed and created databases, tables views, store procedures, and triggers

• Deploying changes and rolling back changes from production.

• Patching weekly of Standalone and Cluster instances

• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008/2008R2, SQL Server 2012.Extensively worked on T-SQL Scripts - Stored Procedures, Functions, Triggers and Automation of Jobs

• Provide 24x7 support for critical production systems.

• Perform scheduled maintenance and support release deployment activities after hours.

• Share domain and technical expertise, providing technical mentorship and cross training to other peers and team members

Intercontinental Bank PLC Lagos, Nigeria

Junior SQL Server Database Administrators 11/2013 - 02/2016

• On-call production support in rotation

• Created database objects like tables, views, indexes (clustered and non-clustered)

• Create the necessary indexes to improve the query performance.

• Backup and restore Database functions using appropriate method.

• Worked with development team to optimize schema and performance

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

• Installed and configured SQL Server 2008 and 2012 on Windows server 2008.

• Administer SQL Server security and protect sensitive data

• Provide timely responses and resolution towards database backup, restore, mirroring, and synchronization request.

• Experience working with Windows server, including Active Directory Education:

Drexel University Philadelphia, PA

Master in Cybersecurity & Data Privacy 05/2022

Obafemi Awolowo University Lagos, Nigeria

Bachelor of Law 03/2011

Certification: SQL Server Database Administration

Scrum Master Accredited

References: Available upon request



Contact this candidate