Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ebenezer Ntiamoah

Riverside,MO

Summary

A SQL Server Database Professional with over 7 years of experience managing critical databases both on-Prem and in the Cloud (Azure), with extensive experience in administration and support of next-generation SQL Server databases in production, test, development, stand-alone and clustered environments.

● Have substantial expertise in Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR) Strategies.

● Hands on experience in setting up and troubleshooting Always On, Clustering, Database Mirroring, Log Shipping, including Replication (Snapshot, Transactional/Merge and Peer to Peer).

● Database Backup and Restore/Recovery, Query Optimization, Security, SQL Server Installation, Configuration of Stand-alone and Clustered environments. ● Migration/Upgrade, applying service packs and routine/emergency DBA operations like database health check, index optimization, updating statistics, client/server connectivity and capacity planning.

● Responsible for securing SQL Server, User Management, assigning permissions and roles.

● Using Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, Scripts, and other third-party tools to resolve bottlenecks, deadlocks, and slow running queries.

● Database security through configuring dynamic data masking.

● Experienced with Active Directory (AD) objects and user permissions.

Overview

6
6
years of professional experience

Work History

SQL Server Database Administrator

Quiver Data Inco
06.2022 - Current
  • Develop and Create Stored Procedures, advanced queries, triggers, views, indexes and functions for databases
  • Provisioning Databases and configuring appropriate HA/DR strategy based on the RTO/RPO objectives of the organization
  • Manage over 2100 databases and VLDB across multiple data centers
  • Enhance database performance, perform system backup and restores, implement recovery procedures and conduct regular health checks
  • Carry out performance tuning tasks on a regular basis on issues ranging from query tuning to index optimization, TempDB issues, to IO, High CPU usage, severe blocking, long running query etc
  • Collaborating with cross functional teams in making Technical decisions, capacity planning and upgrading of SQL Servers for business requirements
  • Configuring, Maintaining, and troubleshooting Log shipping, Mirroring, AlwaysOn Availability Groups, Replication, SQL server Failover cluster and High Availability Disaster Recovery Solutions
  • Configuring DR solution with Transaction Replication from Distribution Server with multiple update table subscriptions
  • Migration of SQL Server from on premises to Azure SQL Database and large-scale database migrations on various versions of SQL Server
  • Schedule and monitor daily, weekly, Monthly, and quarterly Maintenance Task, ensuring that its successful and resolves any issues when it fails
  • Performs Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
  • Using ETL packages for data warehousing
  • Weekly Patching of Standalone and Cluster instances
  • Performs Physical and Logical Data Modelling for databases of varied sizes including VLDBs
  • Configure DR solution with Transaction Replication from Distribution Server with multiple Update table subscriptions
  • Manage the products and development databases including performing tuning, capacity, SQL server clustering, database security configuration and database continuity
  • Manages permissions and security, performs security tasks like Grant, Revoke permissions for security tasks
  • Provides On-Call support to Mission critical Environments
  • Expert in using DBCC trace flags, handling blocking and deadlock situations
  • Use tools like Solarwinds, Fog Light, Red Gate for monitoring my environment.

SQL Database Administrator

Suame Municipal Assembly
11.2019 - 09.2022
  • Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization;
  • Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access;
  • Set user privileges within and outside the database environment from the pg_hba.conf;
  • Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures;
  • Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the crontab periodically in regular intervals;
  • During production hours, resolved lock/deadlocks and resource contention issues;
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
  • pg_dump, pg_basebackup, X-TRA backup for SQL Server,
  • Monitored my databases using solarwinds;
  • created a SQL Server Databases;
  • started, stopped and reloaded my databases.
  • Database security with row level security, search_path, pg_hba.conf and Postgresql.conf.

SQL Server Database Administrator

Heritage Bank
11.2017 - 06.2019
  • Installed and configured edition of SQL Server 2005/2008 like Enterprise edition
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Set up and controlled user access levels across databases to protect important data.
  • Successfully migrated from SQL Server2005 to SQL Server 2008 on Development and Testing Environment
  • Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment
  • Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates
  • Designed New Reports and Customized existing reports of older version to New version
  • Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance
  • Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated
  • Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments
  • Creating logins and roles with the appropriate permissions
  • Responsible for resolving blocking and locking issues
  • Successfully implemented database mirroring between Primary server and Mirror Server
  • Implemented log shipping in standby mode to support DR servers
  • Provided 24 X 7 dedicated supports for SQL Server production server


Education

Master of Science - Information Systems And Business Analytics

Park University
Kansas City, MO
10.2024

Bachelor of Science - Environmental Health

University of Education Winneba
Ghana
08.2017

Skills

  • SQL Server Installation, Implementation and Migration
  • Database Security, Backup and Recovery
  • Performance Tuning and Capacity Monitoring
  • HADR Configurations: Log Shipping, Mirroring, Clustering, Transactional Replications, AlwaysOn Availability Groups
  • Standby/Failover Administration
  • ETL Processes (SSIS, SSRS, SSAS)
  • SQL server Tools: SSMS, SQL Profiler, PerfMon, SQLCMD, Database Tuning Wizard, SQL Server Upgrade Advisor
  • Monitoring Tools: Solarwinds, Redgate SQL Monitor
  • T-SQL
  • Database Maintenance
  • Cloud Migration using Azure
  • Powershell
  • Python

Timeline

SQL Server Database Administrator

Quiver Data Inco
06.2022 - Current

SQL Database Administrator

Suame Municipal Assembly
11.2019 - 09.2022

SQL Server Database Administrator

Heritage Bank
11.2017 - 06.2019

Master of Science - Information Systems And Business Analytics

Park University

Bachelor of Science - Environmental Health

University of Education Winneba

Similar Profiles

CREATE PROFILE
Ebenezer Ntiamoah