Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Generic

Vivian Kengha Magha

White Bear Lake,MN

Summary

Experienced SQL Server Database Administrator (DBA) with over 5 years of experience in all aspects of SQL server ranging from installation to database design, monitoring and performance tuning as well as Backup and Restore strategies, Patching and Migration. Also highly skilled in the development and management of High Availability and disaster Recovery solutions (HADR) like Log Shipping, Replication, AlwaysOn and Traditional Failover Clustering.

Highly strategic in approach to troubleshooting, problem solving and optimization of SQL Server. Also a detail-oriented team player with strong organizational skills and capable of handling multiple projects simultaneously with a high degree of accuracy.

Overview

7
7
years of professional experience

Work History

MS SQL Server Database Administrator

Baywood Home Care
11.2019 - Current
  • Installed and configured SQL Server 2016, 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
  • 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

St.Anthony Park Care
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
  • In our environment
  • Setting up alwaysOn, replication and database mirroring
  • Windows and SQL patching

Help Desk Analyst

St.Anthony Park Care
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

Bachelor of Science - General Nursing And Information Technology

St Louis University Institute of Health And Biomedical Sciences Bamenda
11.2015

SQL Server 2019 Administration, TSQL - undefined

300+ hours training program in SQL Server 2016, SQL server - undefined

KiawiTechIT Academy
2017

Skills

  • Installation, Configuration of MS SQL Server versions from 2008 to 2019 following best practices
  • Performance Tuning & Monitoring using DMV, Extended Events, Activity Monitor
  • Configuring Replication, Failover Clustering, Log Shipping, AlwaysOn Availability
  • Database Migration, Backup and Restore
  • Index management, integrity checks, statistics
  • Managing Logins and Permission for a multi-user
  • Configuring Transparent Data Encryption, Dynamic Data Masking and Always Encrypted
  • Good Knowledge of T-SQL Scripting,
  • Detail oriented, Strong analytical, Problem solving and Interpersonal skills
  • Documenting all my processes in a step- by -step manner to keep up with a good knowledge sharing policy within the team and the entire company
  • Skills
  • Able to work effectively with multiple teams at once Able to thrive in a fast-paced, time compressed and dynamic environment
  • Excellent verbal and written Communication skills
  • Excellent interpersonal skills with the ability to manage sensitive and confidential situations with tact, professionalism, and diplomacy
  • Excellent organizational skills and attention to detail
  • Proficient with
  • Microsoft Word or related software

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

MS SQL Server Database Administrator

Baywood Home Care
11.2019 - Current

Jr SQL Server Database Administrator

St.Anthony Park Care
05.2017 - 10.2019

Help Desk Analyst

St.Anthony Park Care
08.2016 - 04.2017

Bachelor of Science - General Nursing And Information Technology

St Louis University Institute of Health And Biomedical Sciences Bamenda

SQL Server 2019 Administration, TSQL - undefined

300+ hours training program in SQL Server 2016, SQL server - undefined

KiawiTechIT Academy

Similar Profiles

CREATE PROFILE
Vivian Kengha Magha