Augustine Boamah

Database Administrator Ii @Licking Memorial Health Systems

Newark, OH, US

Install, configure and administer SQL server 2017, 2019 on Production and development environment*Design,Deploy and migrate reports SQL server Reporting Services(SSRS)*Coordinate and perform database migration project activities with all applicable stakeholders including end-users, developers, vendors etc.*Documents and maintains database backup and recovery procedure for the environment necessary to ensure effective operation*Setup Transactional replication*Recover database from backup after system failure*Automate day to day operation of database administration with the help of stored procedures, scripts and SSIS to ensure databases continue to operate at peak performance*Set up database alerting based on Microsoft recommended best practice threshold*Identify, troubleshoot and fix database performance issues to ensure optimal system performance.*Create and deploy ETL packages to achieve various task using SSIS and azure Data factory (ADF)*Plan, Setup and manage Database disaster solution using AlwaysOn Availability groups for HA/DR,Log shipping and replication*Performs database migration from standalone SQL instance to AlwaysOn Availability Group Cluster*Configures Transparent data encryption to secure the data from hackers and malicious users*Manages database logins and users*Performs database migration from On-premise SQL environment to Azure database*Migrate VM, SQL databases from On-Premise to Azure, Configure Geo-replication for High availabilitySkills: Microsoft Azure · High Availability (HA) · Tableau · Disaster Recovery. performance monitoring & tunning, Replication, Database security, PowerShell, SSIS, Azure Data Factory, SSRS, AlwaysOn High Availability