ETIENNE AGWARANYAM
adjlhh@r.postjobfree.com
Cell: 240-***-****
Work Authorization: US CITIZEN
TECHNICAL SUMMARY
Proven working experience as a database administrator with four years of hands-on experience with large databases and end-user applications
Broad experience with on-demand SQL Server assessment
Proven skills in SQL installation and post-installation hardening
Experience in creating and altering tables using T-SQL syntax
SQL Server Upgrades/Migration, Updates, Upgrade Advisor, Backup/Recovery, Performance Tuning, DTA, SQL Server Profiler, and Index Optimized.
SQL Server 2012, 2014, 2016, 2019 perform patching, software installation, upgrades, migration, and capacity planning.
Implement data security and hardening (groups, role, privileges, and authentication)
Designed and implement increment and full backup policies and procedures, which is essential to a successful backup, and restore strategy.
Strong ability to work with High Availability and Disaster Recovery tools
Strong in Microsoft SQL Server 2008 – 2019
MYSQL, C++, CSS, HTML, and Java
WORK EXPERIENCE
SQL SERVER DBA July 2018– December 2020
COMCAST DC, Washington DC
Assume primary ownership for the build, data management, access and permission, and roles request submitted and work with the application team and manager on prioritization.
Provide Database Administration and support of SQL server 2012 and 2016
Implement and support Administration tasks such as backup and recovery procedures, database utilities, and database log shipping technologies for both PROD and NON PROD environments
Provide technical support and troubleshooting assistance to application development teams and other third party software provides utility SQL Server platform.
Log schedule and track all changes suing management system tools
Define users and enable data distribution to the right user, in an appropriate format, and on time
Determine, enforce, and document database policies, procedures, and standards.
Monitor database performance, implement changes and apply new patches and version when requiring
Implemented troubleshooting of SQL Server performance issues using SQL Server Profiler, Trace, Index tuning wizard, and Database Engine Tuning Advisor
Responsible for all corrections to the database infrastructure and repairs to the system or database.
SQL SERVER DBA May 2015 – June 2018
Strategic Intelligence Tech Institute
Administers Microsoft SQL Server version 2012, and 2016 database systems.
Build and design automated jobs for indexes, backups, purges, mas SQL connections, daily maintenance, and scheduling task
Creates Users, Logins, and database object as per organization requirements
Ensure all database servers are back up and tested to meet the organization’s RPO and RTO
Install and configure new SQL Servers, involve in migration to a newer version of SQL Server
Configure and support mirroring, replication, and log shipping in both SQL Server 2012 and 2016
Installed and configured SQL Server 2012 clustered environment with high availability
Creates jobs using maintenance plans for Full, Differential, and Transactional Log backups.
Performance tuning (fragmentation, compression drive distribution, load balancing, replication), technical documentation, and implementation of SQL Server disaster recovery models
Implement data security and hardening (group, roles, privileges, and authentication)
Maintain SQL Server instances to ensure software are properly installed, security patches are applied and upgrades
EDUCATION
Bachelor of Science in Information Technology
December 2020
Towson University, Towson, MD.
CERTIFICATIONS
70-461 (Querying Microsoft SQL Server 2012/2014), January 2017
70-462 (Administering MS SQL Server 2012/2014 Database), January 2017
70- 463 (Implementing Data Warehouse with Microsoft SQL Server 2012/2014), January 2017.