I am a SQL Server database administrator with 5 years administration and development experience. I have been involved in the administration, maintenance, monitoring ,performance tuning and development of SQL Server databases most part of my career. DR management and the use of Azure Database Migration Services [DMS] are other areas I confidently consider to be my forte.
Overview
9
9
years of professional experience
Work History
SQL Server Data/Database Administrator
Emory University Primate Research Center
Atlanta, GA
01.2023 - Current
Monitored database size across Production, Staging, and Development environments.
Executed database backups and restorations focused on disaster recovery solutions.
Managed setups for both replication and Log Shipping.
Configured server accesses by setting up database roles.
Enhanced query performance by developing clustered and non-clustered indexes.
Optimized database performance through detailed analysis with activity monitor and DMVs.
Implemented strategic maintenance routines including index reorganization, backups and system clean-ups.
Configured SQL Server installations on server client machines.
Executed data migration across multiple servers.
Performed database tasks such as installation, configuration, and capacity planning.
Developed and optimized Stored Procedures to enhance database performance.
Monitored replication performance with Replication Monitor.
Executing upgrades on various databases.
Established profiler trace to monitor server activities.
Set up AlwaysOn availability groups for enhanced database performance.
Managed SQL server across both clustered and standalone settings.
Analyzed Event Viewer for issues related to replication, mirroring, and log shipping.
Crafted queries designed to free up space in database log files.
Facilitated flat file transfers to SQL database through import/export mechanism.
Generated comprehensive reports utilizing SQL Server Reporting Services (SSRS).
Managed ETL operations with SQL Server Integration Service (SSIS).
Transferred SSIS packages from SQL Server 2008 R2 to SSIS 2012.
Working with developers, support and QA team to maintain all database environment
SQL Data Analyst
Dove Technology
Norcross, GA
02.2020 - 04.2020
Analyzed data using statistical techniques and compiled ongoing reports.
Ensured data integrity by filtering and cleaning information based on system-generated reports.
Analyzed patterns within intricate data collections.
Oversaw maintenance of claims database with MS SQL Server relational database.
Managed extensive databases containing terabytes of data.
Addressed user inquiries during equipment malfunctions.
Recognized production impact, assessed downtime and found workarounds during maintenance.
Facilitated communication of details to stakeholders for necessary approvals.
Enhanced operational efficiency by automating routine tasks.
Gathered data from various primary and secondary sources.
Analyzed results from reports provided by testers to determine if specific products were ready to go live
Created and Managed process needed to communicate approval for work orders
Identified documentation needed for approval of certain requests
When specific documents were not included, followed up with users accordingly
Developed process to notify users who are responsible for specific steps in approval process
Took steps in the event of rejection of a specific task to minimize bottle necks to approval process
Updated processes accordingly as business rules changed and communicated those updates with stakeholders accordingly
Identified and communicated steps to take in the event specific exceptions would occur
Developed notification process for users when approval deadlines and important milestones were approaching
Software Tester
Nationwide Insurance, Ohio
Columbus, OH
06.2016 - 05.2018
Analyzed system specifications to understand software requirements and confirmed testability
Created comprehensive test plans, detailing testing strategies and methodologies to ensure software quality.
Developed and wrote test cases and scripts, including positive, negative, boundary, and edge cases.
Conducted both manual and automated tests, executed test scripts, and monitored software behavior to identify issues.
Accurately recorded and documented all defects and inconsistencies discovered during testing in a defect tracking system.
Worked closely with software developers to communicate bugs and issues found and verified bug fixes.
Performed thorough regression testing after any changes to ensure existing functionalities remained unaffected.
Prepared detailed reports on test findings and progress, including statistics on the testing process and issues encountered.
Ensured the final product met the quality standards and fulfilled all requirements and specifications.
Kept up-to-date with new testing tools and strategies, continuously improving testing processes and methodologies.
Education
Bachelor of Science - Health Services Managment [B. Sc. Admin]
University of Ghana [ City Campus]
Accra, Ghana
08-2010
Associate of Arts - Diploma in Business Admin. [DBA]
Institute of Professional Studies
Accra, Ghana
08-2008
High School Diploma -
Ebenezer Senior High School
Accra, Ghana
05-1998
Skills
SQL Server (2012, 2014, 2016, 2017, 2019)
Windows Server 2008
Windows Server 2012
Windows Server 2016
JIRA
TestRail
Mac OS X
HipChat
MS Office Suites
Microsoft Teams
Timeline
SQL Server Data/Database Administrator
Emory University Primate Research Center
01.2023 - Current
SQL Data Analyst
Dove Technology
02.2020 - 04.2020
Software Tester
Nationwide Insurance, Ohio
06.2016 - 05.2018
Bachelor of Science - Health Services Managment [B. Sc. Admin]
University of Ghana [ City Campus]
Associate of Arts - Diploma in Business Admin. [DBA]
Institute of Professional Studies
High School Diploma -
Ebenezer Senior High School
Similar Profiles
Gianni JohnsonGianni Johnson
Animal Care Technician at U Of Washington National Primate Research CenterAnimal Care Technician at U Of Washington National Primate Research Center
Assistant Operations Manager at EMORY UNIVERSITY WHITEHEAD BIOMEDICAL RESEARCH FACILITYAssistant Operations Manager at EMORY UNIVERSITY WHITEHEAD BIOMEDICAL RESEARCH FACILITY