Summary
Overview
Work History
Education
Skills
Timeline
Generic

Felix Aryee

Lawrenceville,GA

Summary

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
Felix Aryee