SQL SERVER DBA

Momisola Odeyemi

Houston ● Texas ● Tel.: 346-***-****● E-Mail: ************@*******.***

linkedin.com/in/momisola-odeyemi-19bb861ba

Job Objective

A highly motivated IT professional with over 5 years of experience in SQL Server Administration and Database Design seeking employment in your Organization. Accomplished and highly qualified IT professional with diverse and extensive database administration experience. Seeking a DBA position in your organization where I can apply my experience and efficiently contribute to the company’s growth.

My career goal is to be a part of a growing organization and aid in accomplishment of organizational objectives by utilizing my knowledge with what I have learned and am still learning. I am equipped with an excellent work ethic, possesses a strong sense of responsibility and teamwork with a track record of dependability.

Professional Summary

• Enhanced database performance, implemented recovery procedures and achieved 99.9% up time on all SQL Servers.

• Increased efficiency 25% by providing optimum database performance with efficient backup and restore processes.

• Strong Experience with SQL Server 2008 to 2019 versions.

• Setup and maintain database backups, statistics, indexes and agent jobs

• Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions

(Log Shipping, Mirroring, Always On, Clustering, and Replication), TDE (Transparent Data Encryption)

• Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud.

• Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2008, and 2012, 2014, 2016 and 2017 environments.

• High Availability Solution- Clustering, Always On, Replication and Log Shipping

• Configured and supported replication (Snapshot/Transactional/Merge) and log shipping in both SQL 2008 through 2019 Servers.

• Production level support for onsite and offshore - On Call 24/7 environment

• Planned and executed database migration

• Database cross-platform migration between various systems including Azure

• Query Store, Import/Export Wizard, SSMS, SQL Server Profiler, Extended Events and Tuning Advisor tools

• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

• Experience With migration to Azure

• Experience with partitioned schemas and tables, creating File groups using SQL Server.

• Experience in SQL Server Performance Tuning, Query Optimization, Client Connectivity and Database Consistency Checks Using DBCC.

• Experience in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring user accounts, granting privileges to users and groups

• In charge of Server Lease Replacement, Server Decommissioning for the entire Momisola Odeyemi

Houston ● Texas ● Tel.: 346-***-****● E-Mail: ************@*******.*** linkedin.com/in/momisola-odeyemi-19bb861ba

Professional Experience

Expeditors International

MS SQL Database Administrator 12/2018 – present

Responsibilities:

Upgrading SQL 2008 to 2016 in our environment

• Setting up always on, replication and database mirroring

• Database migration to Azure

• Windows and SQL patching

• Reviewing and optimizing VMW environment

• Reviewing and optimizing storage

• Responding to ticket queue (refreshing databases, creating logins and users)

• Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.

• Configured High Availability Solution- Always On Cluster, Traditional Failover Clustering, Database Mirroring and Log Shipping.

• Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Views, Indexes, and Triggers etc. as requirement on SQL Server Environments.

• Responded to and resolved all database access and performance issues.

• Oriented other database administrators on SQL Server management including upgrades and migration.

• Ensured databases adhere to corporate standards and policies, including database auditing.

• Installed SQL Server 2012, 2014, 2016 and 2017 on advanced servers, applied security fixes.

• SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor

(DTA) for performance.

• In charge of Server Lease Replacement, Server Decommissioning for the entire Datacenter.

Halliburton Energy Services

MS SQL Database Administrator 10/2014– 10/ 2018

• Installed and configured SQL Server

• Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space

• Managed the migration of SQL Server 2012 databases to SQL Server 2016

• Created and maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects

• Designed and implemented comprehensive Backup plan and disaster recovery strategies

• Rebuilding the indexes at regular intervals for better performance. Momisola Odeyemi

Houston ● Texas ● Tel.: 346-***-****● E-Mail: ************@*******.*** linkedin.com/in/momisola-odeyemi-19bb861ba

• Responsible for Stored Procedures optimization, Performance tuning & index tuning.

• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers

• Used log shipping for synchronization of database

• Implemented and maintained Database mirroring as a DR solution

• SQL Server 2005/2008/2012/2016/2017 Administration

• Reviewing and optimizing storage

• Used Data partitioning, Snapshot Isolation in SQL server

• Update statistics, database integrity check and backup operations

• Creating and Maintaining database maintenance plans

• Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.

• Planning and implementation of Database backup/restore and disaster recovery

• Installed SQL Server 2012 on advanced servers, applied security fixes.

• SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor

(DTA) for performance.

• Implementation of snapshot isolation

• Configured and supported replication and log shipping in both SQL 2008 and 2012.

• Maintained database response times in 24/7 Production environments.

• Monitoring standby Databases to ensure high availability

• Automation of DBA Tasks and monitoring

• Configured and managed Contained Database

• Configured and supported replication and log shipping in both SQL 2008 and 2012. Education and Training

• Master of Science in Accounting & Management: Obafemi Awolowo University - Nigeria

• 180+ hours training program in SQL Server 2016, SQL server 2017 Administration, TSQL Programming at KiawiTech Academy - Houston Tx

• 180+ hours training program in SQL server 2016 BI (SSIS, SSAS, SSRS, MDX, TA, DW, Power BI) at KiawiTech Academy – Houston Tx

Certifications

Microsoft Azure - USA 2021

Microsoft Certified: Microsoft Azure Architect Technologies AZ-303 Microsoft Azure - USA 2020

Microsoft Certified: Azure Administrator Associate AZ-104 Microsoft Azure - USA 2020

Microsoft Certified: Microsoft Azure Fundamentals AZ-900

Contact this candidate