Database Administrator Server

Mofihinfoluwa Oresanya

CONTACT

*** ******** **** *, ******** Heights OH 44143 216-***-**** adt5v1@r.postjobfree.com

EXPERTISE

I am a SQL Database Administrator with over 4+ years of experience designing, analyzing, adapting, developing, implementing, testing, and maintaining database solutions for industry verticals like healthcare, banking, and public domain. Expertise in the Installation, Configuration, Maintenance and Administration of SQL Server 2019, 2016, 2014, 2012, 2008R2, 2008, 2005 in Production, Test, Development, Replication and Cluster Server Environments.

SUMMARY OF QUALIFICATIONS

Expert in Troubleshooting, Optimization and Performance tuning of SQL Server database server (Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)

Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) with different methodologies like Agile and Waterfall

SQL Server Database Administration

Project Management

Configuration Management Problem Identification/Resolutions Build and Release

Management Team Building and Leadership Team Collaboration

Effective Communication

EDUCATION

Bsc. Accounting Case Western Reserve University

TECHNICAL SKILLS

Databases: Dynamo DB, MySQL, RDBMS, NoSQL, Cassandra, PostgreSQL, Mongo DB, Oracle DB

PROFESSIONAL EXPERIENCE

SQL SERVER DATABASE ADMINISTRATOR

Medical Mutual, Cleveland, OH JAN 2021 – NOV 2022

Configure and tune MS SQL Server and provide 24x7 dedicated support to all Production, Development, UAT SQLServers.

Perform regular monitoring of the services, which includes backup job monitoring, Disk space

monitoring, Services monitoring and block monitoring, and troubleshooting using Red Gate Tools and Spotlight.

Troubleshoot various database server issues to free up log space.

Update statistics, configure number of locks, create databases, and match their data, log patterns with contingency. Performed many database upgrades using import/export.

Coordinate the work efforts of an 8-person team for various projects.

Help the team complete tasks successfully ad on-time, and resolve obstacles encountered by team members.

Proactively monitor database health through automated scripts for checking database and extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage.

Perform day to day tasks like re-indexing, checking integrity, backup, and recovery.

SQL SERVER DATABASE ADMINISTRATOR

Background Check Systems, Cleveland, OH January 2020 – December 2020

Supported several SQL Server 2012/2014/2019 instances related to a project management application.

Gathered user requirements, participate in user group meetings, defined report specifications,

and designed specification documents based on user requirements.

Performed MS SQL Server 2012/2014 administration in a non-clustered environment.

Upgraded SQL Server SQL 2014 version and applied SQL server service packs and security patches.

Performed SQL server performance tuning and troubleshooting. Performed routine DBA maintenance tasks like planning, monitoring databases, logs for errors.

Configured Replication - Snapshot and Transactional.

Configured and monitored Mirroring.

SQL Server Administration - including installation, configuration, upgrades, backups, and

restores.

SQL SERVER DATABASE ADMINISTRATOR

National Life Group, Cleveland OH May 2018 - December 2019

Responsibilities:

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

Exported and imported data from text files and Excel to SQL Server using Bulk Insert and BCP utility.

Worked with the development team to optimize schema and performance.

Worked on SSIS packages for transferring data from various data sources like MS Access and Excel.

Created and managed schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.

Designed SSIS packages to extract data from various OLTP sources, Text Files, XML Files, Excel and MS Access to OLAP systems like SQL Server.

Configuring, Maintaining and troubleshooting Log shipping, Mirroring, Always On Availability Groups, replication SQL server Failover cluster on same and multiple subnet.

Wrote complex T-SQL queries using stored procedures, functions and views.

Worked with the front-end developers to deploy the reports.

Proper use of Indexes to enhance performance of individual queries for fast and efficient reporting.

Set up and configured DB mail and created operators to send out an email whenever any SQL jobs fails.

Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.

Contact this candidate