SUMMARY:

• Around 8 years of experience as a SQL Database Administrator with Banking, Clinical and Financial Sectors.
• Good Experience in installing MS SQL SERVER 2000,2005,2008,2008 R2,2012 updating with hot fix and service packs
• Good experience in implementing High availability solutions like Replication (Snapshot and Transactional), Log shipping, clustering and Mirroring on physical and virtual machines.
• Solid experience in MS SQL 2008 R2/2008/2005/2000 database development and administration in enterprise production environment including server installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security planning and trouble - shooting.
• Good experience on MS SQL Server 2012 server builds and up gradations from lower editions.
• Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/2005/2008 to 2008R2.
• Proficient with client tools SQL Management Studio, Configurations Manager and Upgrade Advisors, BIDS, report builder 2.0.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Good Experience on scheduling database maintenance jobs like DBCC Check DB, Update statistics and Index rebuild jobs and troubleshooting failures.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Experience in writing Stored Procedures, User Defined Functions, Cursors and Triggers.
• Strong understanding of components of SQL Server Architecture and Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping and creating Linked servers and troubleshooting the same.
• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).
• Proficient with database backup and recovery models.
• Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, Blocking, accessibility and efficiency.
• Experience in Troubleshooting all database related issues.
• Expertise in Installs, deployments, certificate renewals, service accounts resets, add patches, performing upgrades / migrations, process job tickets & bugs, test verify backups and recovery.
• Expert in performance tuning and handling blocking situation and dead lock situations.
• Experience in troubleshooting blockings and log space issues and Tempdb issues.
• Experience in Migrating SQL Server 2000 to SQL Server 2005 and higher versions.
• Assist Internal DBA’s with SQL server 2012 builds (100+ SQL Servers) Installation, and configuration
• Storage Management and provisioning Backup/Restore Setup, Process and Documentation using NetBackup
• Server Monitoring, Compliance, Alerts and Notification Setup and documentation
• Set up SQL cluster and Availability groups and Always on technologies

PROFESSIONAL EXPERIENCE

SQL Database Administrator

Confidential

Responsibilities:

• Act as a backup to internal DBA’s assist in test efforts
• Assist with maintenance setup SQL databases, Replication and Link Server setup
• Experience with 2005 new concepts like data partitioning, online indexing, DDL triggers, DMV, DMF, DTA, SSIS and performance dash board.
• Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
• Good experience with Integration, Reporting and Analysis Services.
• Good experience in analyzing the execution plan and index management for better Query Optimization.
• Good experience in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Explicitly used third party tools like Lite Speed, Fog light and BMC Patrol.
• Auditing of database for users transaction, login and database action and removing orphan users
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Actively involved in management of Change Control Requests.
• My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support
• Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2012 2008R2/2008/2005/2000

Programming: T-SQL, VB.NET, C# ASP. NET, C/C++, Java

DBA: Database Administration of MS SQL Server 2012,2008, 2005,2000

Operating System: Windows 2000/2003/2008/XP/VISTA/7, Sun Solaris 9

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, MS Office Suite

Tools: Performance Monitor, Backup Utility, BMC Patrol, SQL LiteSpeed, FogLite