Benjamin Acquaye

Database Devops Engineer Cloud Engineer Linux SRE Build & Release

240-***-**** ad0ixw@r.postjobfree.com

SUMMARY

I am a highly motivated US citizen with over 10 years of IT experience, seeking an environment that promotes continuous learning and innovation. My expertise includes supporting, automating, and optimizing application deployments in AWS through the development of secure and high-performance CI/CD pipelines. I possess knowledge of strategic best practices, am self-motivated with strong work ethics, and am dedicated to delivering exceptional customer service. I excel as a team player and have hands-on experience in database migration activities from on-premise to cloud environments, working with technologies such as PostgreSQL, MS SQL, MySQL, and MongoDB, as well as Linux, Windows Server, and cloud services like AWS and Microsoft Azure.

CERTIFICATIONS:

●CompTIA: CompTIA Security+

●AMAZON: AWS Solutions Architect – Associate

●MCSA Microsoft Certified Solution Associate

TECHNICAL SKILLS:

Database

OPERATING SYSTEM

MSSQL, POSTGRES, MYSQL MongoDB

REDHAT, CENTOS, UBUNTU, WINDOWS

BUILD MANAGEMENT TOOLS

Maven

SCRIPTING LANGUAGES

Shell scripting

APPLICATION SERVERS

Apache Tomcat, JBoss

CONTINUOUS INTEGRATION TOOLS

Jenkins

CLOUD SERVICES

AWS (EC2, S3, EBS, ELB, IAM, AMI)

IAAC TOOL

Terraform

MONITORING TOOL

AWS CloudWatch, Nagios, ELK

STATIC CODE ANALYSIS TOOL

SonarQube

AUTOMATION TOOLS

ARTIFACTORY STORAGE

Vagrant,Ansible, Terraform

Nexus, JFrog

TICKETING TOOL

JIRA

WEB SERVERS

CONTAINERIZATION

Nginx, HA Proxy, Apache

Docker, Kubernetes

EXPERIENCE

IPA July 2021 - Present

PostgreSQL AWS Cloud Solutions Architect DevOps

Job Description:

Responsibilities

•Migration (On-Prem to Cloud using AWS, Azure)

•Provision AWS Aurora PostgreSQL instances, MySQL, both in clustered and non-clustered configurations

•Ensure performance, security, and availability of databases

•Prepare documentations and specifications

•Assist development teams in optimizing for PostgreSQL

•SQL Development experience assisting front end application developers

•Worked on Migrate the data from On-primase databases to AWS Aurora PostgreSQL, MySQL, and Redshift.

•Upgrading Postgres from version to version

•Handle common database procedures, such as upgrade, backup, recovery, migration, etc.

•Created SQL native backup jobs in AWS IaaS environment servers.

•Collaborate with other team members and stakeholders

•Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.

•Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.

Collaborating with NTSHA and development teams to evaluate and identify optimal cloud solutions.

Modifying and improving existing systems.

Educating teams on the implementation of new cloud technologies and initiatives.

Designing, developing and deploying modular cloud-based systems.

Developing and maintaining cloud solutions for CI/CD. Github, Jenkins, Sonarqube and Artifactory.

Managing AWS AMI’s for DevSecOps.

Identifying, analyzing, and resolving infrastructure vulnerabilities and application deployment issues.

Regularly reviewing existing systems and making recommendations for improvements.

Interacting with clients, providing cloud support, and making recommendations based on client needs.

Federal Law Enforcement Training Centre (FLETC) May 2019 – June 2021

MSSQL Database Administrator

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

• Worked on migrate the data from on- premise SQL server208R2 and SQL server 2016 to AWS PostgreSQL.

• Analyzed source table designed through Aws Schema Conversion tool and Identified data type issues, fixed the same and created those tables in AWS Postgres QL and Redshift.

• Involved in troubleshoot the DMS task failures and worked on those tasks.

• Installed, Configured and Monitored Always On, HADR, Database Migration and Upgraded Microsoft SQL Servers. Created user defined roles, modified access roles and user passwords for existing roles

• Responsible Managing User’s, groups, security, Audit, Schemas Object, such as tables, indexes and views, Making Database Backups and Performing Recovery When necessary, managing Various Logical and Physical backups Proactively monitoring the databases health and taking Preventive or Corrective action as required

• Created/configured instances in AWS RDS during database migration

• Migrated SQL Server databases from on-prem servers to AWS using DynamoDB and Oracle DB engines in AWS RDS

• 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.

Accenture LLP, Frederick - MD Apr 2018 – Apr 2019

MYSQL 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

• Created SQL Server databases in AWS RDS in preparation for migration of databases from on-prem servers

Moved data out of on prem SQL Server to AWS RDS SQL Server instances

• Migrated data out of MySQL into Azure SQL.

• Responsible Managing User’s, groups, security, Audit, Schemas Object, such as tables, indexes and views, Making Database Backups and Performing Recovery When necessary, managing Various Logical and Physical backups Proactively monitoring the databases health and taking Preventive or Corrective action as required

• 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, Troubleshooting 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-v Boltos Solutions, Laurel - MD

Boltos Solution

May 2014 – Mar2018

SQL 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 Jun 2010 –May 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.

• Responsible Managing User’s, groups, security, Audit, Schemas Object, such as tables, indexes and views, Making Database Backups and Performing Recovery When necessary, managing Various Logical and Physical backups Proactively monitoring the databases health and taking Preventive or Corrective action as required

• 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 upgrade.

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

EDUCATION & TRAINING

American Intercontinental University

●Bachelor (BSIT) of Science in Information Technology

Contact this candidate