SUMMARY

• Around 6 years of experience in MS SQL Database Administration with Production Support proficiency in SQL Server 2000/2005/2008 /2008 R2/ 2012 and 2014.
• Installation, configuration and maintenance of SQL Server 2005, 2008, 2008 R2/ 2012 and 2014.
• Experience in implementing and managing backups and restoration.
• Knowledge on Log Shipping, Database Mirroring and Replication for database high availability.
• Good Knowledge on SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Hands on experience in Database Backups, Restores, Attach and Detach databases.
• Experience in Database Mail Configuring for SQL server alerts.
• Good experience to apply the patches on cluster environment.
• Experience to create the database and maintenance plans like database backups etc.
• Experience in SQL Server tools, including Management Studio, Query Analyzer, Profiler, Transact SQL and SQL Server Agent.
• Managing Security (Creating users, logins and roles, granting permissions).
• Created Linked Servers between SQL Servers and oracle servers.
• Worked on DBCC and DMV commands to check the database performance.
• Hands on experience in Upgradation and Migration from SQL Server 2000/2005/2008 R2 to SQL Server 2005/2008 and 2008 R2 and 2012.
• Worked on SQL Server Reporting Service and Configuration.
• Experience on deploying the .rdl files into SSRS and apply the patches to the application servers.
• Experience on design the Maintenance plans like backup, cleanup and index re - build and re-organization based on the business needs.
• Knowledge on SSIS Packages and SQL Server Reporting Service.
• Creating ODBC connection for the databases between the servers.
• Knowledge on creating the batch files to take copy of the database backups into storage Servers and Data Center experience.

TECHNICAL SKILLS

Database: MS SQL 2000/ 2005/ 2008 , 2008 R2, 2012 and 2014

Operating System: Windows Server 2003/ 2008 and 2008R2 and 2012 R2

Languages: T-SQL, Shell Script, VB Script

Monitoring Tools: HP NNMI, SCOM, Apex SQL, CA, Symantec, Activity Monitor, Profiler and DTA.

Ticketing Tools: BMC Remedy and HP Service Manager, Co-Desk and Service Now.

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA Consultant

Responsibilities:

• Involved in all aspects of DBA in MS-SQL Server 2K5, 2K8, 2K8R2, 2K12 and 2K14 in recently.
• Designing a data restoration Strategies depending upon the business needs (Full, Simple and Bulk logged Models).
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2008 sp1 server.
• Rebuilding the indexes at regular intervals for better performance.
• Recovering the databases from backups in the disasters.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Implementation of SQL Logins, Roles and Authentication Modes and Creating and scheduling jobs for Database Maintenance.
• Resolve the space issues on servers by shrinking the log files and data files.
• Monitoring and troubleshooting the performance issues like space, files full, locks and deadlocks.
• Checking the servers in the datacenter for the amber alerts for the HD in the servers.
• SQL Server Reporting Service Configuration and knowledge on SSIS Packages and SQL Server Reporting Service.
• Configured the SQL Server Alerts for the jobs failures and customized the scripts for disk space threshold alerts.
• Experience on deploying the .rdl files into SSRS and apply the patches to the application servers.
• Created the batch files to copy of the database backups into storage Servers.

Environment: SQL Server 2005/2008R2/ 2012 and 2014 Enterprise, Windows Servers, Oracle10g, 11g, .NET, SFTP, PeopleSoft 4.3, SCOM 2012 R2 (7.1), SSRS and SSIS.

Confidential

DBA Consultant

Responsibilities:

• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Involved in trouble shooting of databases for its performance.
• Performed daily tasks including backups and Jobs by using SQL Server 2005 tools like SQL Server Management Studio.
• Worked on SQL Server Profiler, SQL Server Agent, and Database Tuning Advisor.
• Checking alerts and resolve issues to take appropriate action as need.
• To analyze the long running slow queries and tune the same to optimize application and system performance.
• Resolve the space issues on servers by shrinking the log files and data files.
• Migration of databases from 2000 to 2005 and 2005 to 2008/2008 R2.
• Performing database refresh across different servers and versions.
• Checking Alerts and resolve issues to take appropriate action as need.
• Worked on database mail configuration for SQL Server alerts.

Environment: SQL Server 2000, 2005, SQL Server 2008/ 2008 R2/ Oracle 10g/ 11g and Windows 2003/2008 R2 Server, HPSM 7.1/ 9.3, NNMI, SCOM 2K12 (7.0). Power Shell.

Confidential

Software Engineer

Responsibilities:

• Database creation, database refreshes, alert monitoring and Backup script creations.
• Maintenance plan for MSSQL server (DBCC, Update statistics,
• Checking the database data files and log files for the available free space. Checking Fragmentation and Resolving Fragmentation issues.
• Configuring database mail for SQL server alerts and customized scripts for alerts.
• Managing Security of the Database and Managing space for data files and log files and Fixing Orphaned users through Stored Procedures.
• Good experience to check the current running transaction, locks and blockings.
• Experience to checking open transactions and fixing the slow running queries.
• Creating the Jobs and scheduling as per the business needs.
• Managing the sys database files and make available space on the disks.
• Implementation of SQL Logins, Roles and Authentication Modes.

Environment: SQL Server 2000/2005/ 2008 and 2008 R2 Standard/ Enterprise Edition, Windows Enterprise Server 2003/2008. SCOM 2K7 (6.1) and Remedy.