SUMMARY

• Over 4+ Years of experience in Database Administration in Production environment,
• Skilled in installing SQL Server, creating teh database and maintaining and performing all database activities,
• Proficient on Installing and Configuring teh SQL Server 2005,2008 & 2008R2,2012 and 2014,
• Experience in maintenance, administration, monitoring on SQL Server,
• Expertise in planning and implementing MS SQL server Security and database permissions,
• Creating and Administering teh SQL Server Databases like data and log file placements and managing teh growth parameters and database options,
• Provided after hours and 24/7database maintenance and support,
• Configuring and maintaining all types of Database Backups and Recovery operations,
• Weekly and On - Demand Refresh of Databases from Production to Test Environment,
• Troubleshooting and Resolving Disc Space issues, Data and log file space issues and implementing permanent solutions,
• Having good experience on suspect databases as well as shrinking databases,
• Identifying and Resolving Blocking and Deadlock issues by using System Stored Procedures, DBCC, Activity Monitor and Profiler,
• Identifying and Resolving fragmentation and performance related issues,
• Configuring and monitoring SQL Jobs and doing Job Failure Analysis,
• Performing Database Maintenance Activities like rebuilding/reorganizing indexes and update statistics, checking database integrity and clean up history on regular intervals,
• Experience in tools like Performance Monitor, Profiler, Import and Export wizard and Copy database wizard
• Experience in usage of DBCC commands and DMV’s for troubleshooting,
• Hands-on experience configuring and troubleshooting high availability solutions like Transaction Replication, Database Mirroring, and Log shipping,
• Performing SQL Server Cluster installation and also activities like adding nodes and patching and failover and failback activities,
• Having extensive knowledge on Always On high availability solution,
• Performing teh Active/Active and Active/Passive clustering for failover and Failback operations in teh cluster environment and adding teh new Disks and troubleshooting activities,
• Experience in adding teh nodes and adding storage in teh respective servers in SQL Server 2005,2008R2 and 2012,
• Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run teh databases efficiently,
• Performing teh Cluster installation and adding teh nodes in teh respective servers in SQL Server 2000,2005,2008R2&2012,
• Ability to TEMPeffectively multitask, meet deadlines, quickly adapt to different project environments and ability to work wif different team sizes across geographical locations,
• Experience in SQL Server migration activities,
• Worked closely wif management, applications development staff, and users on database solutions to business problems,

TECHNICAL SKILLS

Operating System: Windows XP, Windows Server,

Database: SQL Server 2005, SQL 2008R2, 2012 and 2014

Programming Languages: T-SQL.

SQL Server Tools: SSMS, Enterprise Manager, SQL Profiler.

Tools: Red gate

PROFESSIONAL EXPERIENCE

Projects Executed,

Confidential, USA,

Responsibilities:

• Managing database Servers across multiple Data Centres for Production, Test, UAT, and development databases.
• SQL Server 2005 and 2008 &2012 installations, configuration for stand-alone and clustered servers.
• Responsible for optimum running of business applications and availability of teh Databases.
• Database backup/restoration, performing re-indexing, de-fragmentation, optimizing teh database performances.
• Monitoring teh performance of SQL Servers to tune workload.
• Involved in Performance Tuning/ Backup and Restoration/Maintenance of Databases.
• Creating and Maintaining scheduled jobs/ plans for native and LiteSpeed backups.
• Creation of Logins and assigning permissions fixing teh orphan users.
• Performing DB restores from Prod to Test environment.
• Working on Data Centre Consolidation and Migration activities.
• High availability solution: SQL Server Clustering, Replication, Log Shipping and Database Mirroring.
• Working on Incident management, Incident trend analysis, Incident reduction, Configuration Management.
• Working on Change management, Change assignment, and Change co-ordination wif other teams.
• Migration and up gradation of servers and databases.
• Repetitive issues analysis and proposals for permanent resolutions.
• Perform Server level tuning, performance monitoring, Index Tuning, Query Tuning.
• Closing teh tickets wif in teh SLA time and Monitoring teh SLA.
• Using ITIL best practices (REDGATE) for Incident/Change/Problem Management.

NISSAN MOTORS,

Confidential,

Responsibilities:

• Managing High-end SQL Database Servers across teh multiple Data Centres and multiple domains which host Production, Test, UAT, and development databases.
• SQL Server 2000, 2005, 2008 and 2012 installations, configuration for stand-alone and clustered servers.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Doing database refreshment.
• Troubleshoot performance problems and fine-tuning of databases.
• SQL Server Health checking.
• High availability solutions: SQL Server Clustering, Replication, Log Shipping and Database Mirroring.
• Database backup/restoration, performing re-indexing, de-fragmentation and integrity jobs on teh database to optimizing teh database performances.
• Monitoring teh performance of SQL Servers to tune workload. Involved in teh development/ Performance Tuning/ Backup and Restoration/ Maintenance of Databases.
• SQL Server upgrades wif new service packs and hot fixes.
• Monitoring SQL server scheduled jobs and resolve teh reported issue by verifying SQL logs.
• Monitoring database growth activities & and take proactive steps to avoid Transaction Log & Space Issues.
• Taking Transaction log Backups and scheduled them wif teh SQL Server agent job scheduler.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Working on performance tuning, analysing slow running queries and tuning them.
• Providing on call support.