Bukola Ojotu

Experience

• 

  Diamond Bank NIG

  Nov 2014 - Feb 2016

  Sql Server Database Administrator

  • Monitor Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. • Expertise in handling blocking and deadlock situations, using Data availability solutions like Online Restore, Online index operation, Database Snapshot and Fast recovery. • Proactively monitor the database systems to ensure secure services with minimum downtime. • Designed and performed various disaster recovery procedures and database maintenance. • Performed and automated database backups and restores. • Configure log shipping, as well as schedule various jobs and design, create and schedule various maintenance plans. • Perform various standard DBA task and created and deleted databases and database objects, when necessary Show less

• 

  Kuehne+Nagel

  Mar 2016 - Jun 2019

  SQL Database Administrator

  • Improve and manage maintenance of the databases to include Deployments and Upgrades. • Responsible for implementation and release of database changes as submitted by the development • team. • Monitoring and troubleshooting Buffer Latch contention and extensively worked on troubleshooting and fine-tuning of databases for performance. • Responsible for security and non-security patches based on company approved maintenance schedules. • Query optimization and improving overall performance. • Working with tools like Lite speed for Backups and SQL Sentry Tool for monitoring the servers. impact of latches or CPU usage. • Worked with a team of 5 that manages over 1200 databases of 250GB to 2TB. • proactively monitored and ensured high database performance and availability • Identified and troubleshoot any Blockings, Deadlocks. • Identified and troubleshoot any CPU or Memory spikes • Monitored table and disk utilization and database fragmentation and created trace files and validate any issues on the database in question • Worked with team to ensure appropriate hardware resources are allocated and worked with users to develop and optimize their SQL Server queries • Designed and performed various disaster recovery procedures and database maintenance. • Performed and automate database backups and restores • Configure log shipping, as well as schedule various jobs and design, create and schedule various maintenance plans • Perform various standard DBA task and created and deleted databases and database objects, when necessary. Show less

• 

  Blazingice Associates

  Jul 2019 - now

  SQL Database Administrator (MS SQL Server)

  • Responsible for installing SQL Server database instances in all environments including but not limited to development, Quality Analysis and Production. • Develop and create stored procedures, advanced queries, views, indices, and functions for databases. • Support various MS SQL Server environments from SQL Server 2005 thru SQL Server 2008r2 as well as with SQL Server 2012 on Windows Server 2003, 2003r2, 2008, 2008r2 and 2012. • MS SQL Server 2005/2008/2008R2R2/2012 administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery. • Familiar with virtualization and managing SQL databases in a virtual environment. • Knowledge of High Availability of database servers using Database mirroring, replications, Log Shipping and • Responsible for supporting the SQL Server databases and ensuring their performance, availability, and security. • Involved in performance testing and optimization of a 2TB OLTP Database. • Manage the products and development databases including performance tuning, capacity planning, SQL • Server clustering, database security configuration, and database continuity. • Managing SQL Server database security by granting permissions securable to the principals and automate various routine maintenance tasks like backups, index reorganization, index rebuilds on all production databases. • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. • Expertise in handling blocking and deadlock situations, using Data availability solutions like Online Restore, Online index operation, Database Snapshot and Fast recovery. • Pro-actively monitor the database systems to ensure secure services with minimum downtime Show less