SQL Server DBA Resume MD - Hire IT People

SUMMARY:

5+ Years of Database Administration on MSSQL Server 2016,2014, 2012, 2008 R2, 2008, 2005 and 2000 versions.
Experience in Migrating from SQL server 2000 to 2005 and 2005 to 2008 and 2008R2 to 2012 to 2014 and 2016 by using In - Place upgrade process as well as side-by-side upgrade process and documented complete Upgrade Process.
Created effective Backup and Recovery plans by Transactional Log and Full Database Backups and utilized to recover data in 'Point in time' in case of disaster of server based on ERT (Estimated Recovery Time), RTO (Recovery Time Objective), and RPO (Recovery Point Objective) Policies.
Knowledge of skills writing T-SQL scripts, stored procedures, triggers and functions. Worked on SSIS packages, handling data quality issues and generating various types of reports using SSRS on OLAP databases.
Good in implementation of security models, Database authentication modes, creation of logins, granting permissions and assigning roles to users on databases.
Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks, Optimization, Performance tuning of SQL Server databases using DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard and third-party tool. (IDERA) Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, Re-Indexing, Updating Statistics, performing Maintenance Tasks.
Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
24 X 7 Production Database on Call Support, Outspoken person with ability to work in a team-centric, dynamic business environment.

TECHNICAL SKILLS:

Environment: Databases: Virtualization tools (Vmware), SQL Server 2016/2014/2012/2008 R2 Enterprise, Windows Enterprise Server 2012/2008R2, T-SQL, SSIS, SSAS, SSRSTools: SQL Doctor, BCP, Import and Export Wizard, Profiler, DTS, SQL Diagnostic Manager, Microsoft Office (Word, Excel, Power Point, Outlook, Access)

Operating System: Windows server 2005, windows server 2008, Window Server 2012 and Vista/windows 7, Windows 8/8.1/Windows 10.

PROFESSIONAL EXPERIENCE:

Confidential, MD

SQL Server DBA

Installation, Upgrades, Patching and Configuration of MS SQL Server 2016, 2014, 2012, 2008R2 & 2008 in different 32/64-bit production, test and development environments.
As a part of SQL DB team, I am also responsible for planning DR, ensuring databases are online and providing infrastructure and application DB support. Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS. Ensuring data recovery, maintenance, Data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server Environments.
Participating in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export. Using BCP to import/export data from different sources of data into SQL Server Databases and vice versa
Automate maintenance plan jobs in SQL Server agent and task scheduler: such as backup database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics. Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting, and other tasks as assigned or expected from DBAs

Confidential

SQL Server DBA

Monitored Databases and troubleshooting SQL Server performance issues
Designed and implemented comprehensive Backup plan and disaster recovery strategies
Installed, Configured and Maintained Cluster Fail-Over Servers in SQL Server 2000, 2005 & 2008
Installed, Configured, and Administered SQL Server 2005 and 2008 in development, test, and production environment
Imported and exported data from Excel and BCP to SQL Server Database
Created Jobs for database maintenance

We provide IT Staff Augmentation Services!

Sql Server Dba Resume

MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship