OLIVIA D. LLOYD
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
Database Performance Tuning
Database Upgrades Patches
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)
RDBMS: Database Administration, Enterprise Environments, Clustering
OPERATING SYSTEM: Server 2008, 2008r2, 2012
NSTAR TECHNOLOGIES (2016 – Present)
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)
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.
Georgia State University (M.S Clinical Rehabilitation Counseling)
Hampton University (BA Psychology)
Tech Edge Learning Foundation (DBA Training Certification)
NIIT (Microsoft Office Training Certification)