Resume

Sign in

Sql Server Database

Location:
Grand Prairie, Texas, United States
Posted:
August 12, 2018

Contact this candidate

Resume:

SQL SERVER DATABASE ADMINISTRATOR

Nkengateh Donald Nkwentta

ac6m8i@r.postjobfree.com

214-***-****

Client-focused Database Administrator with 5 years of experience proactively working toward achieving high client satisfaction. As an IT professional, am very much committed to maintaining cutting edge technical skills and up-to-date industry knowledge. Deadline-focused with broad skill range including, Database Design, Development /Production Support of MS SQL Server [2008,2012,2014 &2016] in Production, UAT, Test, Development standalone and Cluster Server Environments. Strong Skill set in Database Administration using Windows platform. Always eager to acquire knowledge and share with colleagues. I am part of multiple IT Professional groups.

SQL SERVER DBA

Money Gram

Houston, TX

June 2016 – July 18 2018

Responsibilities

Installed and configured MS SQL Server 2008, 2012,2014,2016 versions.

Supported VLDB ranging from 500G to 3TB in over 150 database Servers the added sum was 60TB of data

Upgraded/migrated DB SQL Server to higher versions (2008 to 2012 and 2012 to 2014)

Migrated Databases from one SQL server database server to another server or from oracle to SQL server using backup and restore, detach and attach and also using SSMA

Implemented techniques and performed special tasks within the context of database performance and tuning to enhance application and database performance using different tools like Activity Monitor, SQL profilers, extended events, Database Tuning Advisors.

Experienced on both production environment and non-production environment support

Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.

Planned and performed capacity requirements including disk storage and generated quarterly reports on database growth rate for review.

Very experience in automating SQL SERVER tasks by scheduling Jobs, creating maintenance plans for backups, index rebuilding and reorg, update statistics etc. on a regular schedule.

Experience with maintaining database integrity and preventing/checking corruptions by utilizing DBCC.

Experience ins checking / resolving database deadlocks, locks and blocks as part of database performance monitoring.

Setup database alerts on critical database errors and failure and make sure us database mail to get this alert to help resolve database issues.

Involve and participated in ITOPS change review meeting to discuss and advice on any changes that need to be made on database production and non-production servers.

Experience in deploying / Implementing SQL Server High Availability (HA) Disaster Recovery (DR) techniques including Failover Clustering, Always On Availability Groups, Database Mirroring, Log shipping, Replication, Backup and Recovery and quickly resolving issues.

Experience with database / app troubleshooting and debugging including root cause analysis for server and database issues, errors, incidents and problems using different SQL server tools

Setup and managed database security defining roles and rights, access profiles and procedures for applications and end users and developers

Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perfmon, Profiler, Dynamic management views

For generating reports, we create Database snapshots and dropping them when the reporting is done.

Created Linked servers for importing and exporting data between oracle and SQL Servers.

Identified and evaluated industry trends in database systems to serve as a source of information and advice for management.

Knowledgeable in Installing and configuring SQL Server analysis and reporting services.

Participated in the preparation of project plans, providing technical expertise regarding architecture, development tools, and work effort estimates.

Supported the research, investigations and recommendation of best practices for information and application services and contribute to work plans.

Wrote documentation for a database including data standards, procedures and metadata

Work as part of a team of 6 DBAs in and 24/7 on call rotation.

Environment: MS SQL Server 2012/2008 R2/2008/2005 SSMS, SSAS,SSRS, SQL Agent, SQL Profiler, Windows 2008/2012R2/2016 server,, T-SQL, Visual Studio 2008/2012, Red Gate, MS Visual Studio 2012,Veeam Backups, Azure, AWS,Log shipping, Mirroring, Clustering, Always ON

SQL SERVER DBA

Wells Fargo

Dallas, Texas

February 2014 – April 2016

• Responsibilities:

Expertise experience in installing new instances of SQL Server 2014/2012/2008R2 on Microsoft Windows Server 2016/2012 R2/2008 and following best practices.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Optimize queries and database performance using graphical tools SQL Profiler, Query Execution Plan, Index Tuning Wizard etc.

Implemented High Availability & Disaster Recovery techniques like Always ON Availability Groups, Clustering (Both Active-Active and Active--Passive), Database Mirroring, and Log Shipping.

Performed database health checks using SQL profiler, performance monitor, performance counters and DBCC commands.

Migrated databases and upgraded SQL server RDBMS versions from SQL Server 2008 to 20012, 2008 to 2014, 2008R2 to 2012 and 2012 to 2014.

Experience in automating tasks in SQL server by creating maintenance plan jobs for regular database Backup, index rebuilding, database statistic update and DBCC corruption checks.

Security administration - Logins, Users and role creation, grant/deny permissions.

Exposure to run backups using third party backup tools SQL Lite Speed and Veaam backup.

Experience in Implementing Database maintenance plans, Configuring Database mail, setting up operators, profiles and setting up alert

Analyze upcoming changes to SQL Server for their impact on customers and products.

Expertise in monitoring performance using SQL Profiler, Activity Monitor, Perfmon in order to find locking, blocking and deadlock issues.

Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perfmon, Profiler, Dynamic management views

Updated database systems by reviewing, managing database administration projects including patching, hot fixes and service pack upgrades.

Strong experience using DMVs, DBCCs and SPs from SQL Server 2008R2 to 2014 for checking database health and performance.

Expertise in recovering the databases from disasters and implemented Point-In-Time Recovery solution.

Experience in writing technical reports for the management and for other of Production support.

Providing production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 5 Terabytes to achieve maximum performance and uptime in production environment.

Participate with other DBAs in 24/7/365 on call rotation for Production databases.

Environment: SQL Server 2008/2008 R2/2012/2014 Enterprise Edition with Clustering environment that includes Production (24x7), Logshipping, Mirroring, Always On, Migration, ETL, Microsoft, Windows /20032008R2/2012 Server, SSIS, Erwin, Visual studio,

EDUCATION

Bachelor Degree in Computer Science

(University Of Yaounde 1)

LANGUAGE

ENGLISH, FRENCH AND CHINESE



Contact this candidate