SQL Database Administrator/DBA Resume Alexandria, VA - Hire IT People

SUMMARY

4 + years of experience in Database Administration, Database Design, and support MS SQL in Production & Development environments.
Very Good knowledge of MS SQL Server 2000, 2005, 2008/R2, 2012, 2014 and 2016.
Experience in installation, configuration, maintenance, security, backup, troubleshooting, performance turning of MS SQL Server 2005, 2008r2, 2012, 2014 and 2016
Experience in Creating Tables, Views, Triggers, Dynamic Stored Procedures, User Defined Functions, and other Transact - SQL (DDL, DML) statements for various applications.
Tracked Server Activity, Query Performance, and Disk usage activity statistics via Performance Data Collection.
Worked with SSIS & SSRS for various BI requirements.
Experience in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Experience in Database migration using both in place and side by side migration
Experience in creation of logins, users and configuring permissions and assigning roles to users.
Experience years in configuring and managing Mirroring, Active/Active/Passive, and Always on Availability Groups
Experience in creating server, database, users, roles, and privileges in Azure portal
Experience in managing and troubleshooting Azure SQL databases through AppDynamics
Experience in managing and troubleshooting Azure SQL databases through portal
Manage Azure SQL servers, databases, and firewalls using the Azure portal

TECHNICAL SKILLS

Microsoft: Azure, SQL

Database Administration/Management: SQL Server 2016 2014, 2012, 2008(R2)/2005/2000

SQL Tools: Query Analyzer, Profiler, Database Mail, SQL Mail, SQL Agent, DTA, Task Manager

ETL Tools: SSIS, SSRS

Database Reporting and Analysis tool: SSRS (SQL Server Reporting Service)

Operating System: Windows Server 2014/ 2012/ 2008/2003/2000

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

SQL Database Administrator/DBA

Responsibilities:

Installed, Configured, and Managed SQL Server 2016, 2014, 2012, 2008/2008R2 and 2005 in development, test, and production environments.
Migrated from SQL server 2005 to 2008 and from 2008/R2 to 2012.
Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
Monitor SQL Server Error Log
Implement DBA maintenance tasks for increase the Database performance with the help of Re-indexing, Re-organize index, and Update Statistics.
SQL Server jobs scheduling and creating alerts and operators and Trouble shoot the Job failures.
Monitor Server Activity, and solving problem as needed
Configured and Maintained Replications (Transactional)
Configured Log Shipping as Standby database from Production database.
Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
Provided 24x7 on-call supports. Supported systems beyond regular hours/ weekends/ holidays
Documented changes made to the servers, including documentation of performance issues.
Created SQL server and database on Azure portal
Managed Azure SQL databases through Azure portal
Managed Azure SQL databases through AppDynamics

Confidential, Alexandria, VA

SQL Database Administrator/DBA

Responsibilities:

Installed, Configured, and Managed different versions of SQL server
Built and supported production servers on a 24/7 support on-call schedule.
Rebuild / Monitored indexes at regular intervals for better performance.
Configured and Maintained Replications (snapshot, merge and Transactional)
Monitored SQL server performance using SQL Profiler to find performance and dead locks.
Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Monitored and modified Performance using execution plans and Index tuning.

Confidential

SQL Database Administrator/DBA

Responsibilities:

Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008 and 2012
Supported production and development databases.
Solving the request raised by user support.
Upgrade MS SQL Server from different versions.
Participate in implementation of new releases into production.
Designed and implemented Backup plan and disaster recovery strategies
Developed Database Backup Scripts and automated this process
Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.
Worked with developers to tune the SQL queries using SQL Profiler
Solved critical production problems and performed point in time recovery plans.
Trouble shooting Problems by using SQL server profiler, DMV’S and Estimated Execution Plan