Sql Server Database Administrator

BENJAMIN ACQUAYE

********@*****.*** 240-***-**** Ashburn US

Personal Summary

Results-oriented and accomplished Database Administrator with Extensive Knowledge and Proficiency in database administration. Adept at Performing Various DBA services across a multitude of platforms (Windows, Linux, and UNIX. In the 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 ethic and an uncompromising devotion to delivering customer service. Team player. Dedicated. Resourceful. DMS activities include migrating on-premises SQL servers to AWS Aurora Postgres and Redshift. DMS activities such as on-premises Oracle databases to AWS Aurora Postgres and Redshift. DMS activities such as on-premises PostgreSQL to AWS Aurora Postgres and Redshift. Experience with database technologies (PostgreSQL, MS SQL, MySQL, MongoDB). Experience with Linux and Windows Server environments. Experience with cloud services (AWS, Microsoft Azure)

Technical Qualifications/Skills List

AWS, Cloud Computing, Postgres, MySQL, SQL Server Performance Tuning, Database Tuning Using Postgres and MySQL, Data Performance Analyzer Tool (DPA), Database Security (SQL Server Encryption), SQL Server Partition, Database Migration /Upgrade (All databases), Backup and Recovery, RDBMS, HA/Clustering /DR, Always On (Availability Groups), Mirroring, Log Shipping, Replication, MSBI, SSIS, SSRS AND SSAS, ETL, VMs, Active Directory, T-SQL, Windows/Linux/UNIX environments, MongoDB, MSSDB, DB Servers, ORACLE, Visual Studio, TFS, Ansible, Support Azure App developers with SQL, NoSQL Database, Oracle (11gr2-12c), AWS Cloud Computing, EC2, S3, RDS, DMS, VPC, Glue (Cloud Migration Using AWS, Aurora, SQL Server), Glue, RMF, SharePoint, and (e.g., FISMA, NIST RMF FedRAMP, CMMC, NIST 800-171 SOC-2, ISO 27001etc.), Plan of Action and milestones (POA&Ms), and waivers/exceptions.

Certifications & Training

MCSA – Microsoft Certified Solutions Associate, Certified

Casp+

CompTIA Security+, Certified

AWS Solutions Architect, Certified

OCA – Oracle Certified Associate

Microsoft Azure

DevOps Engineer (in progress)

Employment History

IPA Ashburn, VA

PostgreSQL, MySQL, MS SQL/ Administrator

07/2021 - Current

Provision AWS Aurora PostgreSQL instances, MySQL, in clustered and non-clustered configurations, including 24x7 production support and on-call troubleshooting.

RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS.

Ensure performance, security, and availability of databases.

Migration (On-Prem to Cloud using AWS.)

Prepare documentation and specifications.

Assist development teams in optimizing PostgreSQL.

SQL Development experience assisting front-end application developers

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

Experience with 24x7 support, troubleshooting, and managing databases in cloud environments (AWS).

Upgrading Postgres from version to version

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

Update the Root Certificate Server

Profile server resource usage, optimize and tweak as necessary.

Installed application on AWS EC2 instances and configured the storage on S3 buckets.

Amazon IAM was used to maintain the user credentials and created custom IAM policies for various groups defined within the organization.

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 for downtime.

Responsible for creation/management of database schema, administering tables, and data models, troubleshooting and performance tuning, assessing database performance, applying security mechanisms on database and user, Database patch management, and update, setting database parameters or specifications, Database Backup, restoring and Disaster Recovery procedures, and database migration and data warehousing

Monitoring and management of indexes, user accounts, and domains.

Reading Execution plan, Rebuilding Indexes, Building Data Sets, Migration, Partitioning, DML / DDL

Develop Stored Procedures and database triggers to support application development.

Participate in application development projects and be responsible for designing and implementing the database architecture.

Participate in creating development, staging, and production database instances and migrating from one environment to another.

Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently before production release.

Participate in a 24x7 support rotation.

Support complex web-based applications.

Demonstrated ability with infrastructure/DB automation tools like GitHub, Terraform, Ansible, or similar software.

Vulnerability management: Integrate Tableau vulnerability data and run daily compliance scans on Nessus Pro to check for new vulnerabilities and findings on Linux and Windows servers, as well as control failures. Check the Veracode platform for new vulnerabilities and open tickets for new ones. Open/Close tickets, update the Vulnerability tracker, and notate tickets on actions performed. Cross-check new findings on the CMS Tableau, including CVEs and KEVs (Known Exploitable Vulnerabilities), with an internal scan. Create Corrective Action Plans for issue remediation.

FEDERAL LAW ENFORCEMENT TRAINING CENTRE (FLETC) Brunswick, GA

MS SQL Database Administrator

05/2019 - 06/2021

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

Worked on migrating the data from on-premises 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 SQL and Redshift.

Involved in troubleshooting 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 for managing users, groups, security, Audit, Schemas, objects, such as tables, indexes, and views, Making Database Backups, and Performing Recovery When necessary, managing Various Logical and Physical backups, proactively monitoring the database's 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.

ACCENTURE LLP Frederick, MD

MySQL Server Administrator

04/2018 - 04/2019

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 the 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 for managing users, groups, security, Audit, Schemas, objects, such as tables, indexes, and views, Making Database Backups, and Performing Recovery When necessary, managing Various Logical and Physical backups, proactively monitoring the database's health, and taking Preventive or Corrective action as required.

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.

Performed Backup and Recovery, Troubleshooting and monitored databases.

Manage and maintain both MongoDB servers across multiple data centers.

BOLTOS SOLUTIONS Laurel, MD

SQL Database Administrator

05/2014 - 03/2018

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.

ASBRONWKON TECHNOLOGY Ghana

SQL & Oracle Database Administrator

06/2010 - 05/2014

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.

Education and Certifications

American Intercontinental University Atlanta, GA

Bachelor of Science in Information Technology Information Assurance and Security

01/2023

Accra-Poly-Tech Ghana

Bachelor of Science in Computer Science

02/1994

References

Nana, Opoku-Siaw, **********@*****.***, 202-***-****, IPA, Lead IT

Ernest, Osei-Owusu, ************@*****.***, 434-***-****, Creek Technology (Federal Law Enforcement Training Center) (FLETC), Lead IT, LinkedIn Address: www.linkedin.com/in/benjamin-acquaye-78b181b1

Websites, Portfolios, Profiles

www.linkedin.com/in/benjamin-acquaye-78b181b1

Languages

English:

Professional

#HRJ#4a196c0d-7ad2-429a-b510-06c08a28cfef#

Contact this candidate