Clemson University Database Administrator
Resume:
Oliver Lloyd
Cell: 571-***-****
**************@*****.***
Objective:
A forward thinking SQL Server Database Administrator that is looking for opportunities to utilize skills I have honed to contribute to a team, while gaining additional skills in the ever advancing field of Information Technology. With the diversity of my experience, I am capable of adapting to any environment, and quickly understanding complex concepts.
CORE EXPERTISE:
Database Upgrades and Patches
Reporting services
Integrations Services
Analysis services
Project Management
Windows Server
Linux and PowerShell
Performance tuning
Backups and Recovery
VSphere Licensing
Sql Server Management studio
Clustering
Cloud Architecture Admin
Always On HA
AWS SQL Cloud Administration
Replications etc.
Database Migration
Disaster Recovery
Database Security
High Availability
VMWare
Foglight
WORK EXPERIENCE:
June 2020 – Present
AT&T retail.
Sr SQL Database Administrator (Azure SQL Cloud)
Serving as the technical expert in SQL Server technologies.
Worked with Linux, JDA and Citrix servers
Trouble shooter Citrix issue
Worked with reporting using sql queries and excel
Migrated data between various servers
Worked as a front facing Liaison for client and team
Perform azure security admin responsibilities and maintain roles
Designing, installing and configuring databases and servers in Azure.
Serving as sole Azure dba.
Participating in SQL Server database table design and operations.
Participating in software upgrades, revisions, patches, and fixes mandated by the vendor.
Assisting in the resolution of complex problems in support of production; including on call support.
Ensuring that the detailed physical design of database and data structures comply with data policies, standards, principles, and meets the established level of service agreements/goals for the system.
Managing the corporations, Licensing and Elections systems for the state.
Managed Team budget as it related to new technologies
Maintaining solid technical skills in R/DBMSs, products, utilities, protocols, and techniques.
Managing and monitoring SLAs for uptime and performance of SQL Server databases.
Flexible, adaptable, and able to managing multiple tasks in a dynamic environment.
Proactively monitoring the database systems to ensure secure services with minimum downtime.
Project management for Database technical project
Provide on call support on a rotating basis.
Other duties as assigned
Also helps with sys admin responsibilities
June 2017 – 2020
OHRS Inc.
SQL Database Administrator (AWS SQL Cloud)
Serving as the technical expert in SQL Server technologies.
Worked with Linux
Experience with RDS, Athena, Ec2, and IAM roles
Designing, installing and configuring databases.
Serving as lead for the SQL Server Production team.
Participating in SQL Server database systems design and operations.
Participating in software upgrades, revisions, patches, and fixes mandated by the vendor.
Utilized tools like Foglight and Cloud watch to monitor Database
Assisting in the resolution of complex problems in support of production; including on call support.
Ensuring that the detailed physical design of database and data structures comply with data policies, standards, principles, and meets the established level of service agreements/goals for the system.
Managing the corporations, Licensing and Elections systems for the state of Georgia.
Participate in disaster recovery strategizing for the Secretary of state’s office.
Maintaining solid technical skills in R/DBMSs, products, utilities, protocols, and techniques.
Managing and monitoring SLAs for uptime and performance of SQL Server databases.
Demonstrating experience in working on root cause analysis for SQL Server database issues.
Flexible, adaptable, and able to managing multiple tasks in a dynamic environment.
Proactively monitoring the database systems to ensure secure services with minimum downtime.
Project management for Database technical projects.
Provide on call support on a rotating basis.
Other duties as assigned
Lead efforts of DBA team in stopping spiral of production environment and stabilize the database environment; leading to business continuity.
Revise and improve current monitoring strategies for the entire database enterprise (Introduced and setup Solar winds and SQL Sentry).
Standardize processes for the Infra DB team by creating documentations for installations, migrations, upgrades, backups, restores, index maintenance, etc.
Lead the efforts of the database team in improving CPU consumption for all critical production database servers by tuning queries, databases, instances, etc. Thereby reducing the CPU workload from a steady 90% to 10% and resulting in a 300% increase in transaction processing.
Mentoring less experienced team mates on internal IT policy changes and the technology in general.
Revise current DR and HA strategies and improving them, thereby reducing downtime in the event of any failure.
Determine and document stabilization roadmap for the next 5 years based on trends in technology for the company.
Participating in on-call rotation with the team.
Designed and participated in the effort that led to the change of our push replication (Transactional) architecture from a 2-tier to a 3-tier system.
Maintaining all environments (prod, uat, test, training and dev).
Troubleshooting issues and carrying out root cause analysis on the issues as well as finding lasting solutions to those problems and documenting findings.
Worked with SQL Sentry and Solarwinds to implement farm-wide monitoring and alerting for all production and UAT/QA database systems (the company was formerly using Idera’s SQL Diagnostic Manager prior to my arrival).
Performing frequent health checks for all backups and productions (mission-critical) databases.
Creating and analyzing daily reports for mission-critical databases.
Establish escalation policies for the db team.
Setting up and managing replication, mirroring and log shipping.
Ensuring that all configurations are properly implemented and working based on the company needs (Resource Governor, Policy based management, CMS, etc).
Saving the company over 120,000 in licensing costs for sql server by consolidating databases and instances based on specific criteria.
Assisted in the development and maintenance of the data architecture to provide a foundation for database design
Generated routine and ad-hoc reports using internal and external data sources to complete data requests
Presented information in a concise, user-friendly format by determining target audience needs to support decision processes outcomes
Performed related duties as required and assigned.
April 2016 – August 2017
Amaya Capital (Remote)
SQL Database Administrator (SQL Server)
Evaluating the current infrastructure and proposing revisions.
Building out new clusters to handle mission-critical databases.
Revise and improve current monitoring strategies for the entire database enterprise.
Standardize processes within the data ops department including creating documentations for installations, migrations, upgrades, backups, restores, index maintenance, etc.
Mentoring less experienced team mates on changes and the technology in general.
Revise current DR and HA strategies and improving them, thereby reducing downtime in the event of any failure.
Proactively monitoring the entire instances and databases for any abnormalities.
Troubleshooting issues and carrying out root cause analysis on the issues as well as finding lasting solutions to those problems and documenting findings.
Participating in on-call rotation with the team.
Maintaining all environments (prod, uat, test, training and dev).
Performing mini health checks every morning.
Analyzing daily reports for mission-critical databases.
Setting up and managing replication, mirroring and log shipping.
April 2012 – May 2016
Grady Hospital
SQL Database Administrator (SQL Server)/Intern
Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap
Lead database compliance effort in accordance with sas70 and iso20k and participate with internal and external audits resulting in fulfillment of FDA requirements.
Lead on supporting client and in-house database systems on various infrastructure projects improving service level agreements by reducing time to deliver database solutions to business.
Managed technical review board (TRB) meetings ensuring that changes to production environments are validated and thoroughly tested. This effort reduced the number of outages by over 25%.
Responsible for promoting team bonding among members of my team.
Responsible for tracking and inspiring the career growth of team members.
Responsible for scheduling and presiding over team meetings and making notes to senior management on the progress of my team.
Managed datacenter with over 120TB of data and set up various measures to manage the said data including; partitioning, transactional and peer to peer replication, log shipping, mirroring and clustering.
Supporting production environments and mission critical databases on a 24/7/365 basis including on-call responsibilities.
Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.
Performed various data migration tasks for mission critical databases.
Worked with a team of 6 to manage over 2000 databases ranging from 350GB to 2.3TB.
Ensured availability of instance and databases via clustering and mirroring.
Set up policies to guide database usage in SQL server 2008r2.
Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis
Worked with bi team and reporting group in generating the weekly, monthly, and quarterly report by using SQL Reporting Services.
Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity
Designed, implemented and upgraded SQL Server 2005, 2008 and 2008r2 databases for mission-critical business
Developed and optimized stored procedures, triggers, and SSIS packages
Troubleshoot databases and custom application issues
Designed the backups and recovery strategies for SQL Server databases to meet our customer SLA requirements.
Managed entire project to which were assigned in accordance with the Service Level Agreement (SLA) and Statement of Work (SOW) to ensure all departmental related cost and expenses are keep on track with the project schedule.
SKILLS SUMMARY
·Experience writing, debugging, and tuning Transactional SQL, DTS and SSIS stored procedures.
·Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.
·Experienced in configuring HADR using SQL server 2012.
·Experienced in setting up partially contained databases using SQL server 2012.
·Experienced in deploying SQL server 2012 cluster solutions.
·Responsible for improvement and maintenance of the databases to include release rollout and upgrades.
·SQL Server Replication (Native and GG).
·Experience managing multiple MS SQL 2000, 2005, 2008, 2008r2, 2012 RDBMS on web-based, transactions.
·Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.
·Maintenance and tuning of the databases and replication.
·Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.
·Provide SQL Server database physical model creation and implementation (data type, indexing, and table design).
·Experience working with merge and transactional replication.
·Management of multi-terabyte production clustered systems using ACTIVE-PASSIVE Clustering.
·Experience with SQL Server 2000, 2005, 2008, 2008r2 and 2012 on Windows NT, Server 2003, 2008 and 2008r2.
·Proficient in performance of SQL Server software new installation and upgrades.
·Proficient in Backup/recovery strategies implementation.
·Proficient in maintaining and supporting SQL Server Transactional and merge replication.
·Expert in reviewing overall physical database structure for overall stability
·Proficient in use of tools like SQL Server profiler and Windows performance monitor.
·Experience with implementing Database Disaster Recovery and Planning
·Proficient in logical and physical database modeling.
·Experienced with the design, implementation, and administration of SQL Server and Oracle database solutions.
·Have good understanding of Disk and Server configuration for SQL Server.
·Experience with network connection tuning using SQL Server 2005.
·Development database support (SQL, T-SQL tuning, Application tuning etc).
·Proficient in SQL Server 2005, 2008 and 2008r2 database cloning.
·Proficient in writing and optimizing T-SQL codes and stored procedures.
·Expert in Data Loading and ETL.
·Experience using PowerShell (Windows and SQL server).
·Experience configuring and supporting SSRS for SQL server 2005 and 2008r2.
·Proficient in data conversions, scrubbing and ETL using DTS and SSIS packages.
·Experience with SAN from the workgroup servers to the enterprise servers, providing the computer applications and database resources necessary to drive the data.
·Experience with monitoring and troubleshooting 24x7 operations.
·Extensive knowledge in Microsoft SQL Server databases, as well as SSIS, DTS packages,
·T-SQL, performance tuning, database design and data warehousing.
·Experience with cross-platform database migration and database instance consolidation
TECHNICAL SKILLS:
RDBMS: SQL 2000, 2005, SQL 2008, 2008R2, 2012, 2014, 2016, Database Administration, Data Modeling, Replication, Enterprise Environments, performance Tuning, SQL Profiler, Clustering, SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services, High Availability.
Operating systems: Windows ME/NT/2000/2003/2008/Xp/Vista/7/8/10;
Windows Servers 2005 through 2016
Third Party Tools: Sentry One, Red Gate, Splunk etc.
EDUCATION:
Clemson University, South Carolina (BS Economics).
Contact this candidate