Summary
Overview
Work History
Education
Skills
Accomplishments
Affiliations
References
Timeline
Generic

KWAME MENSAH THOMPSON

Kansas City,MO

Summary

Experienced and dedicated SQL Server | Azure Database Administrator proficient in overseeing numerous servers in multi-instance environments. Skilled in tasks such as installation, configuration, tuning, and providing support for SQL Server versions 2008 through 2022. Adept at troubleshooting, active maintenance, and performing backups/restores. Demonstrate exceptional analytical acumen and versatility. Readily adapt to new roles, tasks, and applications within the dynamically evolving corporate environment. My proactive and results-oriented approach is complemented by strong interpersonal and communication skills. Enthusiastic about acquiring new skills and expanding my knowledge to navigate the ever-changing landscape of the business world.

Overview

9
9
years of professional experience

Work History

Senior SQL Database Administrator

QuiverData IT Solutions Inc.
03.2018 - Current
  • Proficient in creating logins, users, groups, roles, and databases, ensuring database reliability
  • Installs, configure, tune, and provide support for SQL Server versions spanning 2008 through 2022
  • Manages database storage, including file groups and strategic file placement
  • Effectively manages Azure computers and services
  • Leads migration initiatives, transferring VMs and SQL Databases from On-Prem to Azure
  • Creates and implements ETL packages for diverse tasks using Azure Data Factory (ADF) and Microsoft Integration Services (SSIS)
  • Sets up notifications, alerts, and automated response solutions through SQL Server Agent
  • Monitors SQL Agent jobs to ensure successful execution, preparing reports on backup failures, job failures, and disk space usage
  • Designs and implements Maintenance Plans for Full Backup, Differential Backup, and Transaction Log Backup
  • Compress backups to optimize disk space utilization
  • Designs, manage, and implement disaster recovery plans, including Data Refresh and Restore processes
  • Utilizes the Index Tuning Wizard for index reorganization, rebuilding, and updating statistics to enhance performance
  • Configures failover clusters and managed SQL Server databases effectively
  • Installs, patches, upgrades, and troubleshoots various database platforms
  • Monitor connections, locks, and database performance using the Performance Dashboard
  • Executes successful migration of data from SQL Server 2016 to SQL Server 2019
  • Implements partitioning strategies to handle tables with over 6 million rows
  • Responds to assigned tickets, conduct root cause analysis, and implement preventive measures
  • Develops and maintain ETL processes through SQL agent jobs
  • Efficiently use stored procedure development
  • Develops and install Windows Operating Systems’ jobs using PowerShell for executing various database tasks, including schema import/export across multiple instances.

SQL Database Administrator

TGL Services
Durham, North Carolina
09.2016 - 02.2018
  • Installed, configured, tuned, and provided comprehensive support for SQL Server versions 2012/2014, ensuring optimal performance and reliability
  • Collaborated seamlessly within a cross-functional team, fostering effective communication and synergy among business analysts, application developers, and data architects
  • Demonstrated proficiency in creating databases and logins with tailored permissions based on developers' specifications in various SQL Server environments
  • Evaluated and fine-tuned SQL queries, indexes, and triggers, significantly optimizing overall database performance
  • Supervised and configured failover clusters, contributing to robust database management and high availability
  • Spearheaded the design of both physical and logical data models for diverse development projects, ensuring alignment with project goals
  • Utilized SQL Server Reporting Services (SSRS) 2012/2014 to create insightful reports meeting specific business requirements
  • Expertly managed database storage, overseeing file groups and strategic file placement for enhanced efficiency
  • Implemented a sophisticated alert system and notifications through SQL Server Agent, streamlining issue identification and resolution
  • Conducted root cause analysis, proactively addressing issues to prevent future occurrences
  • Monitored SQL Agent jobs, maintaining a vigilant approach to ensure the successful execution of all tasks
  • Prepared comprehensive reports on backup failures, job failures, and disk space usage, contributing to data-driven decision-making
  • Executed meticulous database backups for Production, Test, and Development Servers, emphasizing data integrity and security
  • Successfully restored backups, verifying the reliability and completeness of the data recovery process
  • Designed, managed, and implemented robust disaster recovery plans, safeguarding data against potential disruptions
  • Employed advanced techniques, such as the index tuning wizard, to reorganize, rebuild indexes, and update statistics, ensuring optimal database performance
  • Responded promptly and efficiently to assigned tickets, showcasing a commitment to swift issue resolution and customer satisfaction
  • Continuously identified areas for improvement, proposing and implementing enhancements to streamline operational processes.

Sales Performance Development Management

Nestlé Ghana Limited
Accra, Ghana
09.2014 - 08.2016
  • Strategic Financial Oversight; Managed cash flow and account receipts to ensure financial accuracy and transparency
  • Maintained a comprehensive sales operations database, optimizing data accuracy and accessibility
  • Data Analysis and Reporting; Utilized distributor management solution software to review and analyze sales data, extracting valuable insights to drive decision-making
  • Prepared and delivered concise daily and weekly sales report briefings to the national sales manager, ensuring transparent communication and informed decision-making
  • Performance Analysis and Intervention; Analyzed challenges affecting poor sales performance, proactively designing and implementing targeted interventions for remediation
  • Provided oversight to a dynamic sales force, reconciled daily reports, and played a key role in identifying and implementing solutions to discrepancies
  • Team Leadership and Development; Led the management, evaluation, and development of field sales supervisors and regional sales managers, contributing to team effectiveness and growth
  • Monitored and evaluated the activities and performance of field sales supervisors, offering guidance and support for continuous improvement
  • Policy Implementation and Compliance; Played a pivotal role in supporting the implementation of the breast milk substitute code/policy of the World Health Organization, ensuring adherence to ethical standards and regulations
  • Recognition and Achievements; Contributed significantly to the sales department's recognition as the best team of the year in 2015, highlighting a commitment to excellence and outstanding performance.

Education

Bachelor of Arts in Political Science and Archaeology -

University of Ghana, Legon
06.2014

Skills

  • Presentations
  • Root Cause Analysis
  • SQL Server Versions: Extensive experience with MS SQL Server versions spanning 2008 through 2022
  • Management Systems: Skilled in MS SQL
  • SQL Server Tools: SQL Server Management Studio, Performance Monitor, Activity Monitor, Index Tuning Wizard, Query Analyzer, Database Tuning Wizard, Replication, SQL Server Business Intelligence, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
  • Data Migration: Competent in using the Import/Export Wizard and Azure Site/Recovery (ASR) for Microsoft Azure
  • Azure DevOps: Proficient in managing Azure computers and services
  • Optimization: Experienced in optimization techniques
  • Scrum Master: Trained and knowledgeable in Scrum methodology
  • Server Configuration: Adept in configuring server settings
  • Database Management: Skilled in database creation, backup/recovery, and disaster recovery for Microsoft SQL Server
  • Programming Skills: Possess excellent T-SQL and database programming skills
  • Additional Technical Proficiency: SQL Profiler, SQL Failover Clustering, Patching and Upgrades, VM Clustering, SQL Jobs Automation, PowerShell, Managing and Troubleshooting, Disk Partitioning and Table Partitioning, SPSS Software for Statistical Analysis and Research, Distributor Management Software Solution (DMS), Microsoft Office (Word, Excel, PowerPoint, Publisher, Outlook), Google (Docs, Sheets and Slides)

Accomplishments

  • Contributed significantly to the Nestle Ghana sales department's recognition as the best team of the year in 2015, highlighting a commitment to excellence and outstanding performance.

Affiliations

Plan, organize and implement community development projects aimed at uplifting deprived villages and smaller towns in Ghana.

Focus on building essential infrastructure such as schools and chip compounds, contributing to the overall development of the localities.

Empower local residents through skill-building programs, vocational training, and economic initiatives.

Establish partnerships with governmental and non-governmental entities, fostering collaborative efforts to amplify the impact of development initiatives in deprived towns.

Advocate for the rights and needs of deprived villages at regional and national levels, ensuring their concerns are addressed in policy and development agendas.

References

References available upon request.

Timeline

Senior SQL Database Administrator

QuiverData IT Solutions Inc.
03.2018 - Current

SQL Database Administrator

TGL Services
09.2016 - 02.2018

Sales Performance Development Management

Nestlé Ghana Limited
09.2014 - 08.2016

Bachelor of Arts in Political Science and Archaeology -

University of Ghana, Legon
KWAME MENSAH THOMPSON