GLADYS MBONG GEH EPSE ASOBO

Microsoft SQL Server Database Administrator

(DBA) Shaker heights, OH

ad2pei@r.postjobfree.com

(216-***-**-**

PROFESSIONAL SUMMARY

A Proactive, and self-motivated IT professional, who gives great attention to details, with over 7 years of experience in Database Administration and MS SQL Server Installations, Configuration, Upgrades, Troubleshooting, performance tuning, monitoring. Manage end-to-end security operations involving setting up logins, user IDs, and permission grant to database objects in line with company’s security policy. Ensure timely configuration of high availability solution, always-on, Replication, database mirroring and log shipping, to take care of certain irregularities. Identify areas of improvement, and troubleshoot slowness in SQL Server, and how to manage storage such as Disk, Memory, and CPU utilization processes for optimum results. Control data recovery, maintenance, data integrity, and space requirements for physical databases in an efficient manner. I am also a fast learner who is always open and ready to learn new technologies, Team focused and goal oriented. Experience in installing and configuring SSRS, SSIS packages and building simple reports. Excellent at migrating databases from On-Prem to Azure. Create Resource groups in Azure and allocate resources to these resource groups.

SKILLS

●SQL Server 2008-2019, Standalone and Cluster environments.

●Maintain security in my azure environment by creating locks on my resources and restricting access to some critical databases to read only mode.

●MS SQL Database Administration/Installation, Configuration/Security/HA, DR

●Administering and Performance tuning of Microsoft SQL Server Environment in an Enterprise level environment

●Database upgrade, implementation of small projects as they relate to Databases, deployment of these projects as well as Cross Platform Database Replication

●Ability to work effectively with ETL tools such as SSRS and SSIS

●Great understanding of Azure Platforms such as, IaaS, PaaS, SaaS

●Strong experience with Performance Tuning and Troubleshooting

●Query Optimization using in-built tools (SQL Profiler, Extended Events, Query store) and external tools (IDERA, SolarWinds)

●Excellent at creating Virtual Machines in Azure and installing SQL Servers in Azure.

●High Availability and disaster recovery solutions-Log Shipping, Always on Availability Groups, and Database mirroring

●Led the migration of databases from On Prem to Azure

●Solid data modelling and database design skills

●Excellent communication, facilitation, and collaborative skills in high pressure situations.

●Great knowledge on Database Security and SQL Databases

●SQL Server Task Automation and SQL Server Replication

●Great problem-Solving Skills and great experience with backup and restore processes.

Good understanding of Windows Desktop and server Operating Systems

●T-SQL Scripting, Query tuning and Production Support, capacity planning

●Project management understanding and skills.

●Experience working with Hyper-V, which entails the use of Virtual machine.

PROFESSIONAL EXPERIENCE

March 2023 – Current

Tri-force Consulting Company

Microsoft SQL Server Database Administrator

Install and configure Microsoft SQL Server 2019

Ensure security and create logins to users and grant these users permission to databases following the principle of least privileges.

Install and configure always on Availability Groups as well as set up replication for some databases.

Monitor performance of databases to ensure databases are performing at optimum.

Migrate databases from SQL 2016 to SQL Server to 2019

Maintained a good backup and recovery strategy following the SLA of the company.

Help users pull data for from Backend using simple scripts and Stored procedures.

Troubleshoot problems and users’ requests as they arise.

March 2020 – February 2023

Richelieu Foods Inc

Microsoft SQL Server Database Administrator Responsibilities:

●Review and Perform health check on all SQL server databases and implement Microsoft best practice.

●Ensure appropriate maintenance including database consistence check, index optimized, statistics and backups.

●Installation and configuration of new instances of SQL server instances following Microsoft best practices and company policies.

●Build and configured Windows fail-over clusters to enable High Availability of data.

●Set up and managed monitor Always-On availability groups.

●Install windows and SQL server patches.

●Task Automation using SQL server agent/ PowerShell.

●Administer database backups using both SQL server and third-party tools.

●Performance Tuning, troubleshoot and query optimization using inbuilt monitoring tools and 3rd party tools.

●Documenting of database processes

●Migration of databases, Resolving of tickets/Special assignments

●Provide full engagement in teams to identify risks and propose solutions to address them quickly and efficiently.

January 2019 – February 2020

Cleveland Kitchen

Microsoft SQL Server Database Administrator Responsibilities:

●Run SQL Server health checks on all SQL Server databases and implement Microsoft best practice.

●Install and configure new instances of SQL server.

●Plan, install, and test software upgrades and patches.

●Upgrade from SQL Server 2012 to SQL Server 2016

Database monitoring and evaluating database performance using inbuilt SQL Server monitoring tools and 3rd party tools trends to identify anomalies or errors.

●Administer database security and control access (create, users, logins, implement database encryption)

●Implement High Availability for business-critical databases such as, Log shipping, Replication, Always-On availability groups.

●Perform database transactions and security audits using SQL Queries, and Stored Procedures

●Ensure appropriate maintenance is in place including backups, index maintenance, consistency checks and statistics.

●Keep up to date with new software releases of Microsoft SQL Server and emerging technologies.

●Work in close collaboration with other IT departments to provide customer support.

December 2015 – August 2018

Bayerle Cooperative Credit Union

Limited

MS SQL Server Database Administrator Cameroon Responsibilities:

●Planning the Installation of Microsoft SQL Server 2005, 2008R2, 2012, 2014, building.

●Migrate SQL Server instances and Migrate databases.

●Support applications / OS with databases hosted on SQL Server.

●Implemented data security by creating users both at active directory and server level, assigning permissions following the principle of lease privilege.

●Set up always encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure client sensitive data.

●Set up and manage Always on availability groups, Log shipping, SQL Replication, for High Availability and disaster Recovery.

●Recover databases following companies SLA.

●Create and update database documentation about company standard procedures, technology features and production issue troubleshooting.

Leveraging the uses of in-built software in SSMS such as SQL Server profiler, Performance monitor, Extended Events, DMVs.

●Use 3rd party database monitoring tools like IDERA and Solar Winds.

●Ability to work both onsite and remotely with minimal supervision.

March 2012 –January 2015

United Bank of Africa

Bank Teller/Associate

Receive deposits and make payments into and out of customers’ accounts.

Answer phone calls and help customers solve their account related problems.

Record transactions as they are performed using excel spread sheets.

Handle cash, debit cards and maintain a clean work environment.

Use Microsoft word to perform other basic office duties.

Preparing money orders, travelers’ cheques and saving bonds.

Perform other office duties and responsibilities as assigned.

EDUCATION AND CERTIFICATION

●Bachelor’s Degree, Business Management, The University of Bamenda, Cameroon 2009 2012

●Master’s Degree, Business Management, The University of Bamenda, Cameroon 2012 – 2014

●Database Administration courses, January 2015 – August 2015

●Microsoft Technology Associate (MTA)

Contact this candidate