SQL Server DBA Resume

SUMMARY

Over 8+ years of IT experience as SQL Server Database Administrator in DEV,STG and PROD environments in SQL server 2012/2008R 2/2008/2005/2000.
Highly experienced in installing, configuring and administering SQL Server 201 2/2008/2005/2000.
Upgraded and migrated several servers and databases from SQL Server 2000/2005/2008 to SQL Server 2005/2008/2008 R2 and 2012.
24/7 On Call Support for Production servers.
Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non - Clustered environments.
Knowledge in IIS (Internet information services).
Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
Experienced in Configuring, Implementing and Maintaining Database Mirroring.
Good Knowledge in implementing Replication using different Replication Models (Snapshot, Merge and Transactional) with different topologies.
Highly experienced in Configuration, Implementation, Maintenance and monitoring of Log Shipping.
Good experience with Microsoft Team Foundation Server (TFS).
Highly experienced with Business Intelligence in MS SQL Server 2005/2008/2012 in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
Expertise in upgrading SQL servers using in place and side by side.
Experience in capacity planning, performance tuning, and disaster recovery and troubleshot performance issues.
Good knowledge and working experience in Storage Concepts of RAID levels, SAN and SRDF technologies.
Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
Experienced in Extraction, Transformation and Loading (ETL) process using DTS, SSIS.
Created Linked Servers for OLEDB Data Source and Native Data Sources.
Experience in developing management reports using SSRS and Crystal Reports.
Documented Disaster Recovery Plans and Participated In Disaster Recovery Drills.
Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/2005/2008.
Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views.
Strong in analyzing Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities. Extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS

Platforms: Windows Me/XP/NT/2000 server/XP/ 2003/2005/2008 server/Vista

Databases: SQL SERVER 2000/2005/2008/2012 , MS-Access, OracleProgramming Languages SQL, PL/SQL, VB 6.0, VB.Net, C, C#, VBScript

Web Technologies: Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script

Security Tools: Microsoft Baseline Security Analyzer (MBSA), NGSSQuirreL for SQL Server, Scuba by Imperva

Tools: SQL Server Management Studio / Enterprise Manager, SQL NavigatorSSRS, SSAS, SSIS, Enterprise Manager, SCCM, SSMS, Toad, Visual Studio 2005/2008, VERITAS, Quest Lite Speed, Red Gate, Excel Macro 2007/2003, SQL Assistant.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship