Administrator Associate Database

NTEANKAH LARIS PUWAGHA

SQL DATABASE ADMINISTRATOR,

LINCOLN NEBRASKA,

+1-402-***-****: ************@*****.***

SUMMARY

Five years experienced SQL Server Certified Database Administrator adept at maintaining database integrity and security by developing policies and procedures. Highly skilled in orchestrating high availability and disaster recovery solutions by implementing failover clustering, log-shipping, replication, Always On, analyzing performance and tuning data. Proficient in reviewing database designs and documents for providing suggestions for enhancement base and optimal performance of databases, ETL, Windows Clustering. Ensuring security by implementing TDE, DDM, Always Encrypted & Auditing. Patching and DB upgrades and Managing Relational Databases on Azure, Virtualization – Hyper-V, Build Domains Controllers and Active Directories, strong experience with SQL server migration from older to newer versions. Managing of large size databases.

PROFESSIONAL EXPERIENCE

5 years of experience in Database Administration for very large and complex databases in SQL Server 2005 through 2019.

Performed all day-to-day aspects of MS SQL server database administration. Responsibilities include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup and restore, troubleshooting and problem resolution.

Configured High Availability Solution- Clustering, Always On and Log Shipping.

Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server environments.

Planning and implementation of Database backup/restore and disaster recovery

Installed SQL Server 2005-2019 following Microsoft best practices, applied Patches and security fixes.

SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.

Configured and supported replication and log shipping in both SQL 2008 and 2012.

Maintained database response times 24/7 in Production environments.

Monitoring standby Databases to ensure high availability

Automation of DBA tasks using PowerShell scripts and monitoring

Configured and managed Contained Database

Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud. 2

RECENT PROJECt

SQL 2008/R2, SQL 2012 and SQL 2017 Upgrades, both In-Place and Side-By-Side upgrades.

Applying windows and SQL Server patches on Production/Non-Production Servers

Configured database backups and restoration, monitored and tuned database.

Migration of SQL Server Databases and Managed instances WORK HISTORY

07/07/2021 – Current,

SQL SERVER DBA Lincoln Industries

Responsibilities

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.

Configure and currently working on High Availability(HA) and Disaster Recovery(DR) solutions for SQL server with clustering, Always ON and Log Shipping

Involved in the planning, setup, and implementation of new servers in our company

Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database.

Planned and deployed monthly windows and SQL server patches.

Planning and implementation of Database backup/restore and disaster recovery

Implementation of snapshot isolation and DDL triggers

Migration of SQL Server 2005 to SQL Server 2008

Perform all types of Replication

Installed SQL Server 2008 on advanced servers, applied security fixes

SQL Server Upgrade and updates

Oriented other database administrators on SQL Server management including upgrades and migration.

Monitoring standby databases to ensure high availability

Production level support for onsite and offshore Clients

Support Patch Management

Automation of database tasks and monitoring

Maintained database response times in 24X7 Production environments

Developing SQL scripts for maintaining administration tasks

Monitoring standby databases to ensure high availability 10/2017 – 03/2021

Junior Database Administrator, University of Douala. Responsibilities

Installed and configured SQL Server 2005/2008/2012/2016/2017

Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space

Managed the migration of SQL Server 2012 databases to SQL Server 2016

Created and maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions, and other schema objects

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Rebuilding indexes at regular intervals for better performance. 3

Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Used log shipping for synchronization of database

Reviewing and optimizing virtual machines environment

Reviewing and optimizing storage

Responsible for monitoring and troubleshooting Log shipping

Update statistics, database integrity check and backup operations

Creating and Maintaining database maintenance plans

Configured High Availability Solution- Clustering, Always On and Log Shipping.

Planning and implementation of Database backup/restore and disaster recovery

Installed SQL Server 2012 on advanced servers, applied security fixes.

SQL Server Profiler, Extended Events, for performance.

Implementation of snapshot isolation

Configured and supported replication and log shipping in both SQL 2008 and 2012.

Monitoring standby Databases to ensure high availability

Configured and managed Contained Database

Configured and supported replication and log shipping in both SQL 2008 and 2012. 10/2015 – 08/2017

Academic Placement Representative,

University of Douala.

Responsibilities

Offer list of programs carried out by the university

Direct questions to the right department when needed

Keep new commers informed about the various schools in the university

Direct students to their various faculties and schools

Maintain accurate records of the number of students in the school of technology

Follow up with parents or new students as needed to ensure any problems they faced are resolve EDUCATION

University of Yaoundé II SOA- Cameroon

Associate’s degree in Computer science.

Microsoft Certified Azure Database Administrator Associate (AZ104) – Pursuing

Advanced SQL server Database Administration training at KiawitechIT Academy Ltd 2015-2017 Application experience

Microsoft SQL server 2005-2019

Windows server 2008, 2012, 2012 r2, 2016, 2019

Microsoft office suite (Word, Excel, power point, office 365)

Service Now

Active directory

Windows (7,8,10)

Hyper-V, Workstation

Contact this candidate