Bonny Bawak Enow

**** ******* ***** **,

Baton Rouge, LA 70816. Phone:614-***-****. Email: adm31t@r.postjobfree.com

Professional Profile

Enthusiastic administrative professional with over five plus years of experience in MS SQL Database administration, in installation, configuration, upgrade, migration using ETL(SSIS), performance tuning, patching, high availability, backup and recovery, Automation using, SQL scripts, PowerShell, Sql Server Agent etc., Experience include all aspects of SQL SERVER Database (2019, 2017, 2016, 2014, 2012 and 2008R2 and 2008) Also have working knowledge of the Azure Platform from configuration to implementation using VM’S, have also worked with different ticketing systems such as SERVICE NOW, service desk, and Jira services

Good communications and problem-solving skills. Very dependable and reliable. Citizen of the United States. No sponsorship required now or in the future.

Skills

•Understanding of Data Structure and Algorithms.

•Analytics and problem-solving skills

•SQL Server DBA, Data Security, SQL Profiler

•Performance Tuning, Patching, Upgrade, Scripting

•Migration, ETL(SSIS), Backup and Recovery

•Good understanding of Waterfall and Agile implementation methodologies

•Fair understanding of SDLC.

Professional Experience

HEALTHESYSTEMs, Inc. Tempe, Arizona February 2020 to Present

Sr. SQL SERVER DATABASE ADMINISTRATION

•Installing of SQL Server databases instances in development, Quality assurance, and production environments

•Create and manage database objects such as tables, store procedure, indexes and functions.

•Hands on in Troubleshooting and researching on error codes using Extended Events, Sql Profiler, and Performance monitor, Query Store, Sentry one etc.

•Run daily maintenance jobs and deployments

•Create users and grant the privileges.

•Work with the server teams to build and maintain Servers

•Do data encryption using TDE

•Work on SQL migration, upgrade and patching.

•Create and manage Backup/Restore ( Full, Deferential and Log Backups)

•Creation of Indexes to enhance Performance

•Database Performance evaluation

•Developing ETL packages using SSIS and Bulk-loading utilities

•Resolved technical and complex database issues before they impact production systems.

•Developed and maintained store procedures, advance queries, triggers, views, indices, and functions for databases.

•Participate in 7/24 rotating on-call nights and weekends as needed

•Configures and maintain High Availability solutions such as Replication, Always on AG group, mirroring, Log Shipping, for disaster Recovery

•Capacity planning, SQL SERVER Clustering, database security configuration, and database continuity

•Responsible for applying database services packs and other security and non-security patches based on company’s approved maintenance schedules and downtime

.

TEK-SYSTEMS (Microsoft) Charlotte, NC

Nov 2018 – Feb 2020

Azure (IAAS) Support Engineer

•Worked on Microsoft AZURE Cloud to provide IAAS support to clients

•Actively involved in Trouble shooting using tools like Query store, system monitor, and DMV’S

•Created Virtual Machines through Azure Portal

•Manage and Create Storage accounts and affinity Group in AZURE Portal

•Create Virtual Network, Subnets and End points in Azure portal

•Helped Clients in resolving Always on AG GROUP problems. Initiated communication with clients to troubleshoot error codes, performance issues in backup jobs and always on AG Group projects using tools like Performance monitor, profilers and DM

•Converted existing virtual machines from Standard to premium storage accounts,

•Monitored Azure infrastructure through system center operation manager (SCOM) . Migration of huge amount of data into AZURE using AZ COPY, migration Assistant and SSIS

•Used AZURE ACTIVE DIRECTORY to create and assign users/roles and to grant permissions and to create an additional security layer by using a multifactor authentication

SIBS IT (Boeing) Dallas, TX May 2016 – Nov 2018

SQL Server DBA

•I did installations, configuration, and upgrading of MS SQL Server

2008/2008R2/2012 /2014/2016 servers

•Responsible for supporting and managing over 100+ SQL Server databases running on multiple instances and ensuring their performance, availability and security.

•Managed production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

•Provided trend analysis to the service management team to enable them to make informed decisions regarding resource management

•Upgraded SQL Server 2008/2012 to SQL Server 2014/2016 following a detailed Upgrade Project Plans, which involved Successful testing of upgrades plans with the application team before cutover, and rollover to critical Production databases

•Managed multiple SQL Server instances in Active/Active and Active/Passive clusters.

•Responsible for implementation and release of database changes submitted by development team

•Migrated my servers from 2012/2014 to sql 2016 and did some patching on sql 2019

•Troubleshooting production issues and errors using Query store, performance monitor, Extended event, and profiler

•Used SSIS AND Bulk Copy as ETL tools to move data from one location or from one drive to another

Education

Pacific Institute of Technology, Jonesboro, GA September 2015 – March 2016 Diploma in Information Systems (Microsoft SQL Server 2012/2014)

University of Yaoundé, Sao, Cameroon September 2007 to June 2010

Bachelor’s degree in law and Business Management

Certifications

Successfully completed Microsoft certification exams:

• 70 -461(Querying Microsoft SQL Server 2012/2014 • 70 – 462 (Administering Microsoft SQL Server 2012/2014

Currently preparing for 70 – 463 - Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 which will qualify me for the Microsoft Certified Solutions Associates Certification in SQL Server. Also working on AZURE 104.

Additional Skills

•Quick Learner

•Adaptive and Friendly

•Ability to work under Pressure

References

Both personal and professional references will be provided upon request.

Contact this candidate