Post Job Free

Resume

Sign in

Security Manager

Location:
Bowie, MD
Salary:
30
Posted:
January 21, 2021

Contact this candidate

Resume:

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.



Contact this candidate