cloudteam profile

Uploaded File

Fenot

SQL Database Administrator

8 years experience W2 Washington, DC

Available immediately

Actively seeking

Fenot

views

SQL Database Administrator

3 recommendations

Recommendations

Average rating

Profile views

Database Backups Database Design DBA SQL SQL Server Disaster Recovery Microsoft Excel Oracle Stored Procedure Triggers

Remove Note

Overview
Detail

Recent Experience

SQL Database Administrator 06/15 - present

SQL DBA SQL Server Performance Tuning Database Backups Database Design

SQL Database Administrator 02/11 - 03/14

SQL DBA Stored Procedure SQL Server Oracle Triggers Disaster Recovery Database Backups Database Design Microsoft Excel

Summary

Five plus years of SQL Server Database Administration experience on Development, Test, and Production environments.
Experience in Installing, Configuring, Managing, Migrating/Upgrading Database, and Troubleshooting issues related to SQL Server 2016/2014/2012/2008R2/2008/2005.
Monitoring Database Performance and Tuning using SQL Server Profiler, Database Tuning Advisor, Activity Monitor, and Performance Monitor.
Automating Jobs, Creating Maintenance Plans, Creating, Reorganizing, and Rebuilding Indexes.
Experience on SQL Security and Audit Management.
Experience on SQL Server High Availability and Disaster Recovery solutions, including Database Backup/Restore, Log shipping, Mirroring, Replication, Always On Availability Group and Failover Clustering.
Experience in Creating Stored Procedures, Triggers, User Functions, and Views.

Top 5 Skills

Skills	Proficiency	Last Used
Database Backups		2020
Database Design		2020
DBA		2020
SQL		2020
SQL Server		2020

Education and Certifications

Bachelor's in Information Technology HIT

Catholic University

MCITP (Microsoft Certified IT Professional) - SQL Server,

DBA,

Preferences

Availability:Immediately

Willing to relocate?:Yes

Relocation preference

Any location

Prepared to Travel:No travel (0%)

Employment Type:Any

Security Clearance:No clearance

Citizenship:U.S. Citizen

Summary

Five plus years of SQL Server Database Administration experience on Development, Test, and Production environments.
Experience in Installing, Configuring, Managing, Migrating/Upgrading Database, and Troubleshooting issues related to SQL Server 2016/2014/2012/2008R2/2008/2005.
Monitoring Database Performance and Tuning using SQL Server Profiler, Database Tuning Advisor, Activity Monitor, and Performance Monitor.
Automating Jobs, Creating Maintenance Plans, Creating, Reorganizing, and Rebuilding Indexes.
Experience on SQL Security and Audit Management.
Experience on SQL Server High Availability and Disaster Recovery solutions, including Database Backup/Restore, Log shipping, Mirroring, Replication, Always On Availability Group and Failover Clustering.
Experience in Creating Stored Procedures, Triggers, User Functions, and Views.

Experience

SQL Database Administrator
Information Technology
Jun 2015 - present
Washington, DC

Installing, Configuring, and Managing MS SQL Server 2014 and 2016 in Development, Test, and Production environments.
Migrating Databases from SQL Server 2008/2008 R2 to SQL Server 2014/2016
Monitoring SQL Server 2014/2012/2008R2/2008/2005
Configured database mail in all SQL Servers.
Designing and implementing the backup and restore plan according to company’s Recovery Time Objective (RTO) and Recovery Point Objective (RPO).
Preparing Standards and Company’s Best Practices.
Creating Jobs and alerts in SQL Server Agent.
Configured SQL Server Agent and automating alerts and maintenance plan jobs.
Troubleshooting and root cause analysis for slow running quires, missing index, outdated statistics, blocking and deadlocking issues.
Expertise on using SQL Server Profiler, Database tuning Advisor, Dynamic management views, sys tables and DBCC commands for troubleshooting.
Resolving and monitoring database auditing.
Regularly checking SQL Server and database overall health check.

Skills

SQL DBA SQL Server Performance Tuning Database Backups Database Design

Remove Skill

References

Average Rating

2 recommendations

SQL Database Administrator
Information Technology
Feb 2011 - Mar 2014
Washington, DC

Configured and installed of MS SQL Server 2008/2008R2
Worked on database migration from SQL Server 2005 to 2008/2008R2
Performed, designed and implemented comprehensive backup plan and disaster recovery strategies.
Automated job through SQL Server Agent and maintenance plan
Analyzed expensive queries and tune system performance
Import and Export data from flat file, Excel, Oracle, to SQL Server
Set up and maintained security at the database and server level
Prepared documentations for the best practice
Participated on database design.
Applied Service Packs and Hot Fixes on SQL Server 2008R2/2012.

Skills

SQL DBA Stored Procedure SQL Server Oracle Triggers Disaster Recovery Database Backups Database Design Microsoft Excel

Remove Skill

References

Average Rating

0 recommendations

Edit Skills

Non-cloudteam Skill

Education

Bachelor's in Information Technology HIT Catholic University

Certifications

MCITP (Microsoft Certified IT Professional) - SQL Server
DBA

Skills

Skill	Last Used	Years Experience
Database Backups	2020	7
Database Design	2020	7
DBA	2020	5
SQL	2020	5
SQL Server	2020	5
Disaster Recovery	2014	3
Microsoft Excel	2014	3
Oracle	2014	3
Stored Procedure	2014	3
Triggers	2014	3
Performance Tuning	2020	2
Data Replication	0	less than 1