VIVIAN KENGHA MAGHA

ad3grg@r.postjobfree.com +1-651-***-**** White Bear Lake, MN 55110

Summary

I am an experienced SQL Server DBA with over 5 years of experience, who can be relied upon to perform duties with passion and professionalism while ensuring that the goals of the company are met. I pay attention to detail and have solid working experience in managing large databases, Backup/Restore, Migration, Configuring and managing HADR solutions, Performance Tuning and Data Security. I possess a methodical approach to troubleshooting and problem solving. I would like to add that I work well both as an individual contributor and as a team player and have an aptitude for learning.

Skills

• Installation

• Configuration

• Performance Tuning

• Monitoring using DMV

• Configuring Replication

• Failover Clustering

• Log Shipping

• AlwaysOn Availability

• Database Migration

• Backup and Restore

• Index management

• Integrity checks

• Statistics

• Data Encryption

• T-SQL Scripting

• Detail oriented

• Problem solving skills

• Documentation

Experience

MS SQL Server Database Administrator at Bright Star - St. Paul, MN 11/2019 - Current

• Installed and configured SQL Server 2008 - 2019 following best practices, applied service pack

• Configure and support replication (snapshot/transactional) in both 2016 and 2019 servers

• Finding DMV queries to answer questions about server-level performance

• Design and Implement backup/restore strategy following company's SLA

• Use Data Migration Assistant to perform vertical and horizontal migration, migrate data from unprime to an Azure environment using best practices

• Administering SQL Server security by Creating User Logins with appropriate roles Automate my jobs, system updates, reducing manual efforts by 10% in a week

• Implement HADR such as Failover Clustering, Log Shipping, AlwaysOn, for business continuity and keeping the business downtime to a minimum

• Maintained database security using Transparent Data Encryption, Always Encrypted and Dynamic Data Masking

• Create a Pro-Active, self-correcting environment with alerts and notifications

• Documenting my work in a systematic manner to keep up with a good knowledge sharing policy

• Participate in an on-call rotation to support after hours issues and planned work

• SQL Server 2008/2012/2016/2017 Administration Reviewing and optimizing virtual machines environment Reviewing and optimizing storage Responsible to monitor and troubleshooting Log shipping

• Used Data partitioning, Snapshot Isolation in SQL server. Jr. SQL Server Database Administrator at St. Anthony Park Care - St. Paul, Mn 05/2017 - 10/2019

• Installed and configured different versions of SQL Server

• Implement and enforce security for all the SQL Server Databases

• Used Performance monitor, Activity Monitor, DMV and Extended Events to optimize queries and enhance the performance of database servers

• Upgrading SQL 2012 to 2019 in our environment Setting up alwaysOn, replication and database mirroring Windows and SQL patching Reviewing and optimizing storage Responding to ticket queue (refreshing databases, creating logins and users) Performed all day-to-day aspects of MS SQL database administration

• Responsibilities include database design, installation, security, managing users and logins, performance monitoring and tuning, database availability, backup, and recovery, troubleshooting and problem resolution

• Configured High Availability Solution- Always on Cluster, Traditional Failover Clustering, and Log Shipping

• Designed and implemented comprehensive Back up and disaster recovery strategies according to company's SLA

• Automation of DBA Tasks and monitoring Capacity planning and resource allocation

• Respond to and resolve database access and performance issues. Help Desk Technician at St. Anthony Park Care - St. Paul, Mn 08/2016 - 04/2017

• Answering and appropriately handling customer support requests via phone, e-mail, and voice mail

• Updating and keeping our inventory accurate

• Assisting staff that are highly mobile and could be working out of many locations such as the office, the airport, their home, or various client sites

• Documenting, tracking, and monitoring all work items and resolution activity in the tracking system to ensure a timely resolution

• Escalating issues of higher complexity to Tier 2 and Tier 3 specialists when appropriate

• Participating in team projects that enhance the quality of service

• Searching online for possible solutions when they aren't documented in our knowledge base and creating and updating knowledge articles in the IT Knowledgebase

• Providing off-hours support on a scheduled rotation

• Other IT-related functions and projects as requested that are not limited to daily IT support. Education and Training

St Louis University Institute of Technology, Bamenda, Cameroon Bachelor's degree in computer science

KiawiTechIT Academy

300+ hours training program in SQL Server 2016, SQL server 2017, SQL Server 2019 Administration, TSQL Programming Certifications

Pursuing Azure SQL Database Administration (AZ104) References

Available on request.

Contact this candidate