Sql Server Database Administrator

SUNNY NDUKA

MICROSOFT SQL SERVER DATABASE ADMINISTRATOR

SUMMARY

Multi-talented Microsoft SQL Server Database Administrator with 5 years of expertise and hands on experience in managing, performance monitoring, and securing of database solutions in various environments. Hands-on experience with managing SQL Servers relational databases hosted on SQL versions of 2008/2008R2/2012/2014/2016/2017/2019 running on physical and virtual hardware platforms in a 24x7 support delivery environment. Provided dedicated support for users in production, development, and testing servers and troubleshooted a wide range of incidents and problems based on their priorities in multiple ticketing system. Motivated initiative-taker consistently meets deadlines and succeeds in high-pressure environments.

SKILLS

Database Management

Query Scripting/Monitoring

Data Security

Always ON

Database Administration

Replication

Microsoft SQL Server

Data Storage/Capacity

Data Restore Troubleshooting

Manage/Design Tables

Performance Monitoring

Collaboration

Extended Event

Team Lead

Data Log Shipping

Meeting Facilitation

Backups/Recovery, Management Studio

Scheduling Emails, Alerts, & Maintenance Plans

EXPERIENCE

Microsoft SQL Server Database Administrator Premier Inc – Raleigh, NC 01/2021 – 10/2023

IT experience in Database Administration and Support of MS SQL Server 2019, 2017, 2016, 2014, and 2012 in Production, Test, Development, and Cluster Server Environments.

Experience in Database Design, Performance Tuning, Optimization, Backup and Recovery in SQL Server 2017, 2016, 2014, and 2012.

Experience in Disaster Recovery Planning, Execution, and Testing.

Experience in using SQL Server tools like Import/Export Wizard, SQL Management Studio, SQL Server Data Tools, SQL Profiler, and SQL Query Analyzer.

Experience in migration from MS SQL Server 2012 to MS SQL Server 2014, 2016, and 2017.

Experience in Database Administration activities for DB Security (Creating Logins, Users, Roles, and Assigning Permissions).

Experience in performing administrative tasks such as Database files management, Backup/Restore, Security management, Database Monitoring, Database Integration, and Synchronization.

Extensive use of SQL Server, Performance Tuning, Index Tuning, and managing Server and Clients.

Implementing High Availability using Log Shipping and Database Mirroring in SQL Server 2017.

High Availability SQL Server Solution including Replication Models (Snapshots, Transactional, Merge, and Peer to Peer) and SQL Server Clustering.

Junior SQL Server Database Administrator Aramark – Raleigh, NC 12/2018 – 11/2020

Installed, configured, and upgraded production SQL server instances from 2008, 2012, 2014, 2016, 2017 and 2019 in a virtual environment.

Monitors database performance. Performs routine checks and updates, as necessary.

Responsible for reliable back-up/recovery methodology.

Performs troubleshooting of problems within databases using Execution Plan, Profiler or Activity Monitor.

Perform in the successful completion of planning and advising on SQL server configuration for a new application and keeps management aware of progress and issues.

Day-to-day data administration of SQL Server in a clustered environment.

Ensure database is backed up with Full, Differential, and Transactional Log and can be recovered.

Configure SQL Server monitoring utilities to reduce the number of false alarms.

Monitoring, performance tuning, and query tuning to include index optimizations.

Setup high availability as part of the disaster recovery strategy for the database.

Manage maintenance plans for index reorg, index rebuild, and updating statistics.

Communicate deployment status, risks, and mitigation plans.

Proactively maintain database servers by monitoring and tuning.

Review query plan and causes of index scans/seek using execution plans.

Creating logins and granting permissions in Security.

Maintenance plan using the Olahallengren.

Database Administrator Cellular World – Belize City, Belize 09/2015 – 11/2016

Responds to requests for technical assistance in person, via phone, and electronically.

Identifies and escalates situations requiring immediate attention.

Tracks, routes problems, requests, and documents resolutions.

Remains current with system information, changes, and updates.

Research questions using available informational resources.

Advises users on appropriate action and follows standard Service Desk procedures.

Supports remote access applications and hardware.

Diagnoses technical hardware and software issues.

Performs root cause analysis and resolves issues.

Performs workstation administration, management, setup, and configuration.

Support both the workstation hardware and software. This includes Operating system installation, configuration, and upgrade.

Install hardware and peripheral components like disk drives, printers, keyboards, and monitors.

Troubleshoot software.

Performed daily backups of client/customer information.

EDUCATION & TRAINING

Associate of Arts in Computer Science 05/2015

Wesley Junior College – Belize City, Belize

High School Diploma 06/2013

Sadie Vernon Technical High School – Belize City, Belize

CERTIFICATIONS

Microsoft SQL Server Database Administrator

Scrum Master

Scrum Fundamentals

REFERENCES

References available upon request.

Contact this candidate