Professional Summary:

• Having Seven+ years of hands-on experience as SQL Server DBA in Production support.Expertise in Database Administration on production servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008
• Maintaining 4000+ of SQL Servers with multi instances, with different environments (RTE, DEV, Preprod and Production). Proficiency in installing MS SQL Server 2000, 2005, 2008 and 2008R2.
• Administering, maintaining policies and procedures for ensuring the security and integrity of the company's databases and systems.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Performing SQL Server service pack and Windows Service pack upgrades.Hands on experience in configuring database Mirroring and log shipping.
• Continuously monitoring and updating the Backup and Recovery strategy via different backup tools like TDP and RedGate tool.
• Implementation of Database maintenance plans for Database consistency & Integrity. Creation and maintenance of databases, creating roles and assigning to the particular users and managing user permissions based on the client requirements.
• Handling blocking/locking incidents in order to avoid the performance issues. Implementing and restricting the security on server and database level.
• Administering SQL Server High Availability and Disaster Recovery strategies.Expert in data transformation services like SSRS.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked on Clustering and server consolidation. Troubleshooting production issues and raising high availability. Handling multiple SQL Instances on Cluster environment for server consolidation projects built on SAN.
• Maintained individual service accounts for SQL Server services with different Security groups to raise security mark.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and application support. Experience in using DBCC commands to improve server performance.
• Weekly activity of implementation of scripts in the databases in different regions. Providing 24X7 production support to critical databases.
• Proven ability to quickly learn new technologies and apply them in business solutions.

Technical Skills:

Databases : SQL Server 2000,2005, 2008 and SQL Server 2008R2

Languages : C, C++,Java, .NET & SQL , Visual Basic, HTML, XML.

Operating Systems : Windows server 2003, Windows Server 2008, Windows NT/95/98/XP.

Technologies : ASP.Net, Web services, .Net Frame work 2.0/3.0, Teradata.

Front End Tools : MS Office 97/2000/XP, MS Outlook 97/2000.

Database Tools : Profiler, Query analyzer, SSRS, SSIS, SSAS.

Managing Tools : HP Service Managar 9.3, Service center, Maximo, Managenow

Backup Utilities : Tivoli-TDPSQL, RedeGate Tool.

Professional Experience:

Confidential

SQL Server DBA

Responsibilities

• Installing MS SQL Server 2005, 2008, and 2008R2 (Database Engine, Analysis services, Reporting services in standalone & Cluster Environments as per the client requirement.
• Installing SQL Server service packs.
• Creating and configuring Databases based on the specifications sent by the client.
• Continuously monitoring and updating the Backup and Recovery strategy.
• Maintaining the Database Consistency with DBCC commands.
• Implementation of Database maintenance plan for Database consistency & Integrity
• Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, Space availability in Storage Devices.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Used log shipping for synchronization of databases.
• Recovered the System and User databases from suspect mode.
• Handling blocking/locking incidents if any.
• Working with customers on Application rollouts and server migrations.
• Creation of LOGINS, ROLES and granting rights, assigning permissions and mapping user databases as per the client’s request.
• Performing SQL Server service pack and Windows Service pack upgrades
• Scheduling JOBS (Daily, Weekly, Monthly) as per the client request.
• Performing Database Restoration (Native backup, Tivoli TSM - TDP) in different environments like Prod, PreProd, Dev, RTE.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Meet the SLA (Service Level Agreement) established.
• Automated messaging services on server failures, for task completion and success
• Executed procedures resquested by the application team to accomplish short-term business goals.
• Configured SQL server Reporting Services (SSRS).
• Deploying new code base release to UAT and Production Environments.
• Configuring TDP Nodes and installed TDP-SQL in standalone and Cluster environments.
• As part of the DBA team, providing 24x7 productions supports to the clients.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, .net, VB and, RedGate & Tivoli TDP as backup utilities, Ticketing tool – Manage Now.

Confidential

Client: NESTLE

SQL DBA

Responsibilities

• Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Continuously monitoring and updating the Backup and Recovery strategy.
• Maintaining the Database Consistency with DBCC commands.
• Implementation of Database maintenance plan for Database consistency & Integrity
• Checked Database Health and consistency by using DBCC Commands and DMVs.
• Installing MS SQL Server 2005, 2008, and 2008R2 (Database Engine, Analysis services, Reporting services in standalone & Cluster Environments as per the client requirement.
• Installing SQL Server service packs.
• Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, Space availability in Storage Devices

Environment: SQL Server 2008 R2/05/00, Windows 2003,2008, .net, VB and, RedGate & Tivoli TDP as backup utilities, Ticketing tool – Service Manager, Service center.

Confidential

Role: SQL DBA

Responsibilities:

• Performed daily tasks including backup and restore by using Tivoli TDP, SQL Server Management Studio.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved scheduled jobs to re-index and update statistics in databases.
• Experience in using DMV for finding out long running queries
• Having Experience on Data center servers and handling 1.4 TB databases.
• Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS)
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
• To set up SQL Server configuration settings for better server management.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, .net, VB and, RedGate & Tivoli TDP as backup utilities, Ticketing tool – Manage Now.

Confidential

Role: SQL DBA

Responsibilities

• Continuously monitoring and updating the Backup and Recovery strategy via TDP and RedGate tool.
• Daily routine DBA tasks like handling user’s permissions and space issues on production and pre-production servers and handling maintenance Jobs.
• Weekly activity of implementing scripts in the databases.
• Scheduled and monitored all maintenance activities including database consistency and backups.
• Performed all basic database activities like creation, backup, restore between servers.
• Checked Database Health and consistency by using DBCC Commands and DMVs.
• Worked on blocking/locking incidents in order to avoid the performance issues.
• Worked on critical change activities on production servers.
• Worked with customers on Application rollouts and server migrations.
• Provided 24x7 production support for SQL Server databases achieve maximum performance and uptime in production environment.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, .net, VB and, RedGate & Tivoli TDP as backup utilities, Ticketing tool – Maximo.