Data Security

BENJAMIN ACQUAYE

Frederick MD

Phone: 240-***-**** Email: ****************@*****.***

BACKGROUND SUMMARY

Results-oriented and accomplished Database Administrator with Extensive Knowledge and Proficiency in database administration. Adept Performing Various DBA services and across a multitude of platforms (Windows, Linux and Unix. In Production Development and test environment to ensure Data Integrity.

Ability to communicate effectively with cross functional teams and work well in a dynamic fast paced working environment.

Possess the knowledge and ability to facilitate strategic best practices.

Self-motivated. Good work ethics, and an uncompromising devotion to customer service delivery.

Team player, Dedicated, Resourceful.

EDUCATION

Accra Technical University

Bachelor of Technology in Computer Science

CERTIFICATION & TRAINING

MCSA – Microsoft Certified Solutions Associate, Certified

CompTIA Security+, Certified

AWS Solutions Architect, Certified

OCA – Oracle Certified Associate, Certified

Microsoft Azure

OCP - Oracle Certified Professional – in progress

MCSE – in progress

Python, Networking, SysOps – in progress

DHS Experience

CORE QUALIFICATIONS

·

SQL Server Performance Tuning

Database Migration /Upgrade

Backup and Recovery

HA/Clustering /DR

Always On (Availability Groups)

Mirroring

Log Shipping

Replication

MSBI, SSIS, SSRS AND SSAS

ETL

Database Security, Facets

VMs, Active Directory, T-SQL

Forglight (Tools), Spotlight

Windows/Linux/UNIX environments

Visual Studio

TFS

Powershell and GIT

Support Azure App developers with SQL

MS Servers, ORACLE

NoSQL Database

MongoDB

Relational database platforms (Mysql, Oracle 11gr2-12c)

AWS Cloud S3, RDS (Cloud Migration Using AWS, Aurora, SQL Server), Glue

Migration (Migrate data databases into SQL server on Azure using the SSMA tool.)

Azure SSIS, ETL

Project Management and Support

Cloud Computing

PROFESSIONAL EXPERIENCE

Federal Law Enforcement Training Centre (FLETC) 05/ 2019 – 05/ 2020

Database Administrator (Azure)

On Performance Dashboard, installed, configured Microsoft Sql Server (2012/2014/2016/2017-2019) etc., Including MSBI, SSRA, SSAS, SSIS and ETL

Installed, Configured and Monitored AlwaysOn, HADR, Database Migration and Upgraded Microsoft Sql Servers. Created user defined roles, modified access roles and user passwords for existing roles.

Managed user roles and user privileges.

Proactively updated latest Security Patches to Databases, which were provided by Microsoft.

Performed performance tuning as part of day to day activities.

Manage and maintain both MongoDB servers across multiple data centers.

Experience in managing multi - node MongoDB clusters on public cloud environment.

Excellent skills in database backup, replication, recovery, restoration, DTS and Linked servers.

Used MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets.

Manage, maintain, and troubleshoot the company databases housed in MongoDB

Create the scripts to automate routine tasks and establish backup protocols to ensure

the reliability and safety of data sets.

Performed benchmarking and fixed performance bottlenecks on SQL Server 2012-2019.

Used Query Store, Perfmon, Extended Events, DMVs, SQL Profiler and also third-Party Tools in performance tuning.

Performed Backup and Recovery.

Performed Database migration and testing.

Simulated production captured workload on new server and analyzed statistics.

Pre-plan and fixed issues before going live.

Maintained Database System, monitored database growth at level of schema.

Automatic database backup: User can define his on interval for different backup type (Full, Differential & T-log).

Automatic indexing: User can specify schema or table level indexing activity on meeting user defined fragmentation level. Indexing include rebuilding and reorganizing.

Set automatic database statistics update.

Excellent skills in database backup, replication, recovery, restoration, DTS and Linked servers.

Backup and Recovery, Monitor databases, Performance Tuning

Performed other works as requested and assigned.

MongoDB Install and configure of Mongo Databases Check the Integrity of the Databases, Performance Tuning, Clustering Backup and Recovery

Motoring of Databases Daily, Setup Maintenace Job

Issuse with Client Not able to access databases, Users, Query Runing Slow, Power Outage.

Backup Database and Test,

Accenture LLP, Frederick - MD 04/ 2018 – 04/ 2019

SQL Server Administrator

Participated in daily meetings to discuss new database designs, modeling and creations.

Installed, configured and administered database software within the Microsoft SQL server stack including MSBI, SSRS, SSAS and SSIS.

Migrated data out of MySQL into Azure SQL.

Performed MySQL replication setups and administration on Master-Slave and Master-Master.

Created User defined roles, modified access for existing users.

Managed User roles and User privileges.

Performed Backup and Recovery, Troubleshooted and monitored databases.

Manage and maintain both MongoDB servers across multiple data centers.

Experience in managing multi - node MongoDB clusters on public cloud environment.

Excellent skills in database backup, replication, recovery, restoration, DTS and Linked servers.

Used MongoDB third party tools (ROBO MONGO, MongoDB compass) and mongo-built in binaries to monitor and analysis the performance of MONGODB.

Created groups and set up restrictive permissions and configured Sudo files etc.

Installed and configured PostgreSQL from source or packages on Linux machines.

Proactively updated latest security patches to database.

Delivered innovative BI & Data warehouse solutions.

Allocated system storage, planned future storage requirements, and maintained system security.

Tuned auto-vacuum parameters to ensure up-to-date table statistics and reclaimed space consumed by dead tuples.

Boltos Solutions, Laurel - MD 05/2014 – 03/2018

Database Administrator

Installed SQL, Oracle Database, Tar Files and prepared YAML configuration files.

Implemented backup, disaster recovery and replication requirements

Completed basic backup/restore and implemented security functions for various applications using MariaDB (MySQL).

Performed MySQL replication setup and administration on Master-Slave and Master-Master.

Created User defined roles, modified access for existing users.

Managed User roles and User privileges.

Designed and developed SQL procedures.

Performed CRUD operations on imported data.

Performed Tuning test on production database by altering the parameters.

Managed end-to-end complex data migration, conversion and data modeling.

Installed, configured and maintained MS SQL Server 2005/2008R2/2012.

Asbrownkon Technology, Ghana 06/ 2010 –05 /2014

SQL & Oracle Database Administrator

Implemented simple snapshots to replicate data among production databases.

Participated in monthly health checks using tools we developed and frequently fixed production and non-production dashboard issues on OEM.

Proactively managed standby replication methodologies.

Performed log-shipping mirroring replication and clustering.

Managed end-to-end complex data migration.

Migrated and refreshed data for numerous database environments using the Data Pump Utility table level, schema level, tablespace level, or entire DB) and RMAN in efforts for TSA Exits within HPE.

Managed MySQL database, migrations and upgrades

Contact this candidate