Summary
Overview
Work History
Education
Skills
Accomplishments
Reading, Swimming, Exploring
Timeline
Generic

Tobi Olajumoke

Saugus,Massachusetts

Summary

Experienced Database Administrator with over 6 years’ experience managing Microsoft Sql Server databases on Prem and in the Cloud .

Adept Knowledge in the set up and troubleshoot AlwaysOn, Clustering, Database Mirroring, Log Shipping, including Replication models (Snapshot, Transactional/Merge) Familiar with Database Backup using third party tools like Rubric, Commvault and Restore/Recovery, Query Optimization, Security, SQL Server Installation, Configuration of Stand-alone and Clustered environments Have done Migration/Upgrade, applying service packs and routine DBA operations like database health check, index optimization, updating statistics, client/server connectivity and capacity planning.

Overview

9
9
years of professional experience

Work History

Data Administrator

Town Of Brookline
Brookline, MA
08.2022 - Current
  • Administrated and Maintained SQL Server database services to make sure that user applications are in good shape, to keep data safe and secured, including creating maintenance plan to back up database, transaction log, shrinking log files when needed, monitoring log files and failed logins as well as daily scheduled Jobs.
  • Responding to Application Managers requests to perform manual database performance tuning, checking the log space, checking for any bottlenecks or blockings affecting the performance of database.
  • Consolidating the cyclical task list (daily, weekly, quarterly) and other data extractions when requested which is based on schedules or upon request.
  • Worked on Data Modelling, creating table structures, Performing an ETL process that Extracted files from CSV formats, Transforms the data by establishing connectors through the Visual Studio in a package and load the data into the SQL Server
  • Automated the scheduled process for Database through the SQL Server Agent Jobs.
  • Worked with third party organization to make sure that Datasets are properly updated on the portal at the right time and with accurate frequency.
  • Installed SQL Server 2019, SQL Server Management Studio V18.x, Visual Studio Developer Edition.,SQL Server Reporting Services and Microsoft Reporting Services Projects
  • Daily SQL Server Health Checks

Database Administrator

Nanosoft Consulting LLC
Highland Heights, OH
02.2019 - 08.2022
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
  • Tested programs and databases to identify issues and make necessary modifications.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Created and implemented database designs and data models.
  • Built databases and table structures following best practice architecture methodology for web applications.
  • Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.

Database Administrator

Speedaf Express
Asaba, Delta State, Nigeria
03.2014 - 12.2018

• MS SQL Server design, Development and administration using SQL Server 2005 – 2014 database environments.

• Monitored SQL health checks 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.

• 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

• Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions

• Set up basic SSIS for our ETL processes, granted permissions for users of SSRS

Education

HND - Business Administration and Computer Studies

Federal Polytechnic
2008

Skills

  • Microsoft SQL Server Administration
  • Database Mirroring
  • Bug Fixes
  • Database Schemas
  • Database Support
  • Running Backups
  • Critical Thinking
  • Writing Queries
  • Data Maintenance
  • Data Security
  • Client Information Database Systems
  • Database Analysis

Accomplishments

  • Optimized existing procedures to improve performance by 90%.
  • Documented and resolved Database manual Refresh which led to using Powershell to automate the process.
  • Used Visual Studio to develop SSIS package to Extract Data from flat files to the Database and automating the process.
  • Automated Backup processes to reduce workflow by 20 hours.

Reading, Swimming, Exploring

I read Information Technology articles, LinkedIn learning, Plural sights and Udemy. Love to swim with family during summer, travel to new places and experience life.

Timeline

Data Administrator

Town Of Brookline
08.2022 - Current

Database Administrator

Nanosoft Consulting LLC
02.2019 - 08.2022

Database Administrator

Speedaf Express
03.2014 - 12.2018

HND - Business Administration and Computer Studies

Federal Polytechnic
Tobi Olajumoke