OLANREWAJU AKEEM OBISESAN
SENIOR SQL SERVER DBA
Houston,TX
Summary
Highly trained, skillful, and accomplished database administrator with 6+ years of depth experience in MS SQL Server database development and administration in enterprise production environment. Extensive experience in installation, Upgrades (In place Upgrade and side-by-side) and configuration of MS SQL Server 2008 R2, 2008 versions on both Standalone and Cluster Environments. Exceptional abilities in Software installation, Maintenance, Data Extraction, Transformation, and Loading. Specialized in Data Handling, Database Backup and Recovery. Dynamic, highly driven, and diligent professional with a proven track record of success in database security through configuring transparent database encryption (TDE) and dynamic data masking. Database administrator with capabilities of monitoring performance, conducting diagnostic tests, troubleshooting database issues, configuring devices, and planning for capacity expansion and other upgrades. Proven adaptability of learning new skills, embracing challenges effectively under pressure, and dedication to generate great customer and shareholder value propositions through innovation. Looking for a high-level opportunity in a dynamic organization in which my enthusiasm, expertise, and talents are utilized to the greatest degree possible.
Overview
6
6
years of professional experience
1
1
year of post-secondary education
4
4
Certificates
Work History
Senior SQL Server DBA
TELEWORLD SOLUTIONS
01.2020 - Current
- Installed and Configured SQL Server 2008 R2 Servers in Production, QA, UAT, DEV and DEV-INT Environments.
- Created databases, Logins, Roles and granted appropriate permissions.
- Created jobs, alerts, activity logs, error logs to capture any possible error.
- Participated in SDLC methodologies such as planning, analysis, design and implementation.
- Solved issues related to server performance and disk space
- Successfully implemented Database Mirroring in SQL Server 2005/2008R2 for high availability.
- Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
- Maintained High Availability such as Log Shipping and Mirroring as a database disaster technique.
- Supported 24*7 production support and solved all kinds of critical problems.
- Created Clustered and Non Clustered Indexes on tables, views, and columns
- Creating and managing schema objects such as tables, views, index, and procedures.
- Created SQL Server Clustering on multiple nodes.
- Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
- Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
- Developed Different Maintenance Plans for database monitoring
SQL Server Database Administrator (Production DBA
Datalogix
01.2018 - 11.2020
- Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment
- Configured and Maintained Fail-Over Clustering using SQL Server 2012
- Experience in Always-On environment
- Maintained server and database security including database encryption (TDE)
- Installed and Configured SQL Server Reporting Services (SSRS)
- Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files
- Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
- Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
- Monitored Space estimation for database objects
- Scheduled Alerts and Jobs Using SQL Server Agent (Automation)
Junior SQL Server Database Administrator
Etisalat Telecommunication
LAGOS, NIGERIA
02.2016 - 07.2017
- MS SQL Server design, Development and administration using SQL Server 2005 – 2014 database environments.
- Monitoring SQL health check and identifying issues and fixing them.
- Used SQL Indexes for improving query performance, lower storage and maintenance cost
- Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance.
- Implemented Installation, Configuration and Upgrading of SQL Server.
- Good experience in User Management and maintaining of databases.
- Automation of administrative tasks like creating jobs and schedules, alerts using SQL Server Agent monitoring and troubleshooting jobs, event notifications using Database Mail.
- Maintained server security by assigning logins, server and database roles and server permissions.
- Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mirroring and Replication.
- Maintained database response times in 24X7 production environment and proactively generated reports
- Planned and Implemented database backup/restore and disaster recovery
- Implemented Log Shipping from Primary to Standby servers
- Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions
- Used tools like SQL Profiler, Fog Light, Red Gate for monitoring my environment
- Responsible for installing and maintaining SSIS, SSRS, and Power BI
Education
Bachelor of Science - IT MANAGMENT
Western Governors University
Salt Lake City, UT 06.2021 - Current
Skills
SQL SERVER
Certification
PMP
Timeline
CEH
11-2021
SAFe
07-2021
Bachelor of Science - IT MANAGMENT
Western Governors University
06.2021 - Current
Scrum Masater
11-2020
PMP
03-2020
Senior SQL Server DBA
TELEWORLD SOLUTIONS
01.2020 - Current
SQL Server Database Administrator (Production DBA
Datalogix
01.2018 - 11.2020
Junior SQL Server Database Administrator
Etisalat Telecommunication
02.2016 - 07.2017
Similar Profiles
Susmitha GillaSusmitha Gilla
RF Engineer 2 at TeleWorld SolutionsRF Engineer 2 at TeleWorld Solutions
Mebatsion Dereje-YilmaMebatsion Dereje-Yilma
Recruiting Coordinator at Teleworld SolutionsRecruiting Coordinator at Teleworld Solutions
Benjamin OnyeibeBenjamin Onyeibe
Team Lead - Agile Delivery at Teleworld SolutionsTeam Lead - Agile Delivery at Teleworld Solutions