SQL Server DBA Resume , DC - Hire IT People

SUMMARY:

MCTS - Microsoft Certified Professional in Administering Microsoft SQL Server 2012 Database.
Microsoft SQL Server Database Administrator with over five years of Experience (SQL DBA).
Expert in Installation, Configuration, Maintenance and Administration of SQL Server 2005-2014.
Experience in troubleshooting using SQL Tools, Performance Monitor, execution plans, Trace, statistics, index tuning wizard and optimizing the queries, tracing long running queries and deadlocks.
Configure and manage database backups and recoveries.
Experience in using SQL Server Native tools (Profiler, PerfMon, DMVs, DMFs) and 3rd party DBA tools and applications (Idera & Spotlight ).
Strong functional knowledge of T-SQL, Store procedure, Constraints, Triggers and Views.
Experience in migrating project from SQL Server 2008 to SQL Server 2012.
Proven ability to work in both a team environment and independently.
Ability to support 24x7 mission critical production environment to achieve business goals and objectives, with in team on-call rotation, and perform off hours work as needed .
Quick learner and result- oriented individual with strong analytical aptitude and effective interpersonal and communication skills.

TECHNICAL SKILLS:

Software: MS SQL Server 2005, 2008/R2, 2012, 2014

SQL Server Tools: PerfMon, DMV s, DMF s,Profiler, Query Analyzer, Export & Import, Replication

Operating System: Windows server 2012/2008/R2 & Windows

Third party Tools: Idera & Spotlight

PROFESSIONAL EXPERIENCE:

Confidential, DC

SQL Server DBA

Environment: SQL Server 2005/2008/2008 R2/2012/2014

Responsibilities:

Oversaw daily activities for SQL Servers including security management, storage space, backups and restores.
Installed & Configured SQL Server 2008-2012 on windows 2008 and 2012 servers and applied service packs and security fixes for all individual servers & Clusters.
Worked on Production, Staging and Dev environment.
Monitored SQL server performance using profiler to find performance issues or deadlocks.
Designed and implemented comprehensive backup plan and disaster recovery strategies.
Troubleshot databases issues for clients during implementation, maintenance, upgrade, and migration processes.
Worked in migrating packages from DTS to SSIS and Deploying SSIS Packages.
Used Index tuning wizard to redesign and created the indexes for better performance.
Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
Owning, tracking and resolving databases related incidents and requests.
Participated in capacity management, expansion and growth planning.
Actively contributed to the configuration, layout and performance tuning of the production server.
Analysis of Hardware (Disk I/O, Memory, Processors) And Wait states.
Attended and actively participated in weekly meeting.

Confidential

SQL Server DBA

Environment: SQL Server 2005/2008

Responsibilities:

Provided technical support for the day to day SQL Server activities of the company.
Supported after hours on-call and respond in timely manner.
Worked on compliance with best practice with regard to database security, recoverability and auditing.
Reviewed and resolved Backup issues.
Performed tuning with application teams to isolate and resolve performance issues.
Maintained database security.
Automated tasks using job schedulers.
Setup of log shipping, Mirroring, Replication, AlwaysOn, Disaster Recovery planning and procedures.