Resume

Sign in

Manager Sql

Location:
Atlanta, GA
Posted:
January 16, 2020

Contact this candidate

Resume:

OLIVIA D. LLOYD

adbbhz@r.postjobfree.com

Cell: 404-***-****

CAREER OBJECTIVE:

An inquisitive and confident Database Administrator with extensive experience and willingness to grow. My goal is to fine-tune the skills I have honed, while working in a high-performance environment that permits room for growth. Over a span of five years I have acquired knowledge in Information Technology and Database Administration that would permit easy acclimation in diverse environments. Specifically, As a DBA I aspire to develop efficient and effective database solutions which adheres to the technical objective of the company as well as support the goals and projected of the company.

TECHNICAL SKILLS/CORE COMPETENCES

Database Backup & Recovery

SQL Server 2008, 2008R2, 2012, 2014,2015,2017.

High Availability Solutions

Disaster Recovery

Data Migration

Database Performance Tuning

Database Upgrades Patches

SKILLS SUMMARY

5+ years of Experience with SQL Server 2008, 2008r2, 2012, 2014,2016,2017 RDBMS

Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies

Experience in troubleshooting and problem solving of SQL Server

Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.

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

Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.

Proficient in performance of SQL Server software new installation and upgrades.

Installation, Administration and Maintenance of SQL Server Instances.

Huge experience with AlwaysON High Availability solution.

Experience using Windows System Task Manager to manage CPU/Memory resources in an environment of multiple instances of SQL Server

Experience with SQL Server Database mirroring configuration and maintenance.

Experience with implementing, configuring, troubleshooting and maintaining Log Shipping on very scale databases

Experience in creating SQL SERVER functions and stored procedures using T-SQL.

Experience with performance tuning

Solid experience in Eliminating Blocking issues, performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager

Experience in SQL SERVER 2005/2008/2012/2014 database cloning

Experience with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server: Clustering, Replication, Log shipping and Database mirroring.

Experience working in operational 24x7 environment

Experience with large volume data extraction, transformation and loading (ETL) logic and tools.

Experience with cross-platform database migration and database instance consolidation.

Experience with periodic instance upgrades; applying patches and hotfixes.

Configure and support SSIS and SSRS for 2005, SQL Server 2008 R2, SQL Server 2012, 2014 and 2016.

Troubleshoot databases and custom application issues for 2005, SQL Server 2008 R2, SQL Server 2012, 2014 and 2016

Experienced in working with end users to define, implement, and maintain their reporting requirements.

Implemented SQL user security model using Active Directory groups.

Experienced in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.

Develop and document SQL coding guidelines.

Schedule, verify, and audit database backups and restores using native SQL or Red Gate backups.

Personal computers and SANs

Generate the weekly, monthly, and quarterly report by using SQL Standard Report.

Create reports that ran daily for jobs running in SQL Server Agent.

Experienced with monitoring and troubleshooting in 24x7 operations.

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

Vast experience with PowerShell

High availability (Always on, Clustering, log shipping, Replication, mirroring)

TECHNOLOGY SUMMARY

RDBMS: Database Administration, Enterprise Environments, Clustering

OPERATING SYSTEM: Server 2008, 2008r2, 2012

WORK EXPERIENCES

NSTAR TECHNOLOGIES (2016 – Present)

Lawrenceville, GA

MS SQL SERVER DBA

Established standards and schedules for database backups by making sure that the backup schedules meet the recovery requirements on a daily, weekly, as well as monthly basis. Used the RESTORE VERIFY option when creating backups.

Planned, implemented and documented database structured and contents for SQL Server databases

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

successfully engaged in various DR (Disaster Recover) efforts for customers.

Developed and optimized stored procedures, triggers, and SSIS packages

Troubleshoot databases and custom application issues

Developed and created stored procedures, advanced queries, triggers, views, indices, and functions for databases.

THE TECH-EDGE GROUP LLC (2014 -2016)

Atlanta, Ga

MS SQL DBA

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.

Worked on building and supporting highly available clusters.

Configured and Managed the High Availability and Disaster recovery Solutions Always On, Replication, Clustering on Critical Production Servers.

Configured and Managed Always On High Availability Mirror Groups and Replica Databases.

Monitored and optimized system performance using SQL Profiler and Database Engine Tuning Advisor.

EDUCATION:

Georgia State University (M.S Clinical Rehabilitation Counseling)

Hampton University (BA Psychology)

Tech Edge Learning Foundation (DBA Training Certification)

NIIT (Microsoft Office Training Certification)



Contact this candidate