SQL Server DBA

TECHNICAL PROFICIENCIES

Azure PowerShell WMWare/Hyper V Virtualization SSIS SQL Server 2008-2019

Career Summary

A highly motivated IT professional with over 6 years of experience in SQL Server Administration and Design.

Enhanced database performance implemented recovery procedures and achieved 99.9% uptime on all SQL Servers.

Increased efficiency 25% by providing optimum database performance with efficient backup and restore processes.

Saved $250K annually in licensing, hardware, and lower tech support calls, by migrating from standalone NT servers to VMware.

Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs.

Strong Experience with SQL Server 2000 through 2017 Administration standalone and cluster environment

Windows and SQL patching of servers with the latest Service packs available.

Provide DBA support and technical expertise for multiple applications in development, test and production - SQL Server 2005, 2008, and 2012, 2014, 2016 and 2017 environments.

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

Experience in supporting Very Large databases (VLDB) 500GB – 2TB and troubleshooting the problems.

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

An excellent team player with a very positive can; do attitude.

Configured and supported replication (Snapshot/Transactional/Merge) and log shipping in both SQL 2008 and 2012, 2014 and 2016 Servers.

Performance Tuning, Performance Baselining and Query Optimization

SQL Server Performance Dashboard Reports for Monitoring

High Availability Solution- Clustering, AlwaysOn, Database Mirroring and Log Shipping

Building of Window Server Clusters

Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events

Expertise in T-SQL writing stored procedures, triggers and functions.

Excellent knowledge on Data Domain Replication Technologies

Excellent knowledge on Server Virtualization with Hyper-V or VMWare

Data Collector for Performance Tuning

RECENT PROJECT

Database migration to Microsoft Azure

SQL 2008/R2 Upgrades, SQL 2012 Upgrades, Application Migration and SQL Server Consolidation.

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

Configured database backups and restoration, monitored and tuned database.

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator 12/2015 – Present

Texas Health Physicians Group, Euless Texas

Responsibilities:

Configured High Availability Solution- Clustering, AlwaysOn, Database Mirroring 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 etc. as requirement on SQL Server Environments.

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, Query Store and Database Engine Tuning Advisor (DTA) for performance.

Implementation of snapshot isolation and DDL triggers

Configured and supported replication and log shipping in both SQL 2008 through 2017.

Monitoring standby Databases to ensure high availability

Automation of DBA Tasks and monitoring

Configured and managed Contained Databases

Provision of Azure databases, Managed Instances, elastic pools, and Azure VMs

Used Azure Active Directory Multi Factor Authentication

Jr. MS SQL Server Database Administrator 10/2014 – 12/2015

Walmart, Wylie Texas

Responsibilities:

Installed SQL Server 2008 through 2014 on advanced servers, applied security fixes and patches

Documented processes for installations, clustering, availability group setup, and patching.

Maintained database response times in 24/7 Production environments

Automation of DBA Tasks and monitoring

Planning and implementation of Database backup/restore and disaster recovery

Database Mail and Operator

Capacity Planning and resource allocation

Monitoring standby Databases to ensure high availability

Internal Control /Audit 02/2010-06/2013

Bamenda Police Cooperative Credit Union

Bamenda, Cameroon

Responsibilities

Ensure policies implementation and compliance

Audit of Financial records/procedures,

Manage the image of the institution and institution’s website

Products recommendation

Customer service training

Contact this candidate