Database Administrator Server

Musiliat (Jennifer) Abiola Ogbozor

**** *********** **, ***** **, 75074

Contact: Cell 850-***-****, email: ************@*****.***

MS SQL SERVER DATABASE ADMINISTRATOR

Professional Summary:

Professional, detail-oriented, highly motivated IT professional with over 3+ years of experience in SQL Server Administration, with strong experience in migration of application and IT infrastructure. Strong Experience with upgrading SQL 2008 through 2019 Administration standalone and cluster environment. Organized, dedicated and ambitious and pay excellent attention to details. Always strive to learn and implement cutting edge technology and best practices.

Skills

oInstalling, configuring, and Harding SQL server instances.

oImplementing MS SQL server security practices

oDatabase backup and restores.

oDatabase mirroring, Log shipping and Replication

oScheduling and monitoring SQL server jobs and maintenance plan

oAlwaysOn Availability groups and Failover Clustering installation and configuration

oIndex creation and rebuilding

oUpdate statistic

oPerformance Monitoring and Tunning

oQuery optimization

oDatabase migration.

Recent Project

oSQL 2018 Upgrades, Application Migration and SQL Server Consolidation.

oApplying windows and SQL Server patches on Production/Non-Production Servers

oConfigured database backups and restoration, monitored and tuned database.

PROFESIONAL EXPERIENCE

MS SQL Database Administrator

Paramount INC

05/ 22 to Present

oInstalled and Configured SQL Server 2016 / 2019 successfully on windows 2019 servers.

oDesigned and implemented comprehensive Backup plan and disaster recovery strategies Involved in troubleshooting and fine-tuning of databases for its performance and concurrency Monitored and modified Performance using execution plans and Index tuning Rebuilt indexes at regular intervals for better performance Deployed new codes (database scripts) to UAT and Production Environments.

oPerformed SQL Server service pack and Windows Service pack upgrades.

oWorking with customers on Application rollouts Involved in Index Analysis and Performance Tuning.

oImplemented log shipping, mirroring and Transactional Replication Analyzed long running slow queries and tune the same to optimize application and system performance Implement AlwaysOn Availability Groups for high availability mechanism Worked on hardware.

oOversee multiple database administration operations including conducting server health check, supporting security operations, installation, and configurations in adherence to expected targets.

MS SQL Database Administrator

Consulate Healthcare consultant

10/2019 - 12/2021

oWorked with developers in development of the database schema design using the entity relationship model as per user requirement.

oWorked on planning and implementing MS SQL server security and database permission.

oWrote and reviewed T-SQL script for creating tables, constraints, triggers, stored procedures, views and functions for critical business applications.

oEstablished backup of SQL server 2016 by using SQL server Agent jobs for periodic backups

oUpdated statistics with full scan on a weekly basis to make sure that the query optimizer uses the most recent statistic.

oUsed SQL profiler, execute plan, performance Monitoring and DBCC Commands to find the slow running queries to get the performance metrics.

oImplemented database Mirroring to ensure high availability of critical databases.

Sunrise Community Inc.

06/ 2014- 06/2019

Director of Operations

Oversees the day-to-day operations of 24 beds ICF facility dealing with elderly and children with special needs and intellectual disabilities.

Prepared and monitored ongoing facility yearly budgets.

Ensure that all state regulations and company policy are adhered to by all staff members.

Ensure coordination of goals, plans, program, and services throughout the facility

Interview and hire all management staff.

Chair and coordinate facility management team meetings

Investigate and report unusual incidents in accordance with policies and procedure.

Education/Training

oMaster of Science: Healthcare Administrator, 2014

Florida A &M University

Tallahassee, Florida

oBachelor of Science: Healthcare Management, 2011

Florida A&M University

Tallahassee, Florida

180+ hours training program in SQL Server 2016, SQL server 2017 Administration, SQL server 2019 Administration, TSQL Programming at KiawiTech Consulting LLC

Reference Available Upon Request

Contact this candidate