Experience Summary

Total *+ years of experience in MS SQL Database Administration and Production Support with proficiency in SQL Server 2000/2005/2008/2008R2/ 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, shrinking the 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 the Disk Space and Memory management and maintaining the daily checkup of Systems.

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 Upgrading and Migration from SQL Server 2000/2005/2008R2 to SQL server 2005/2008 and 2008 R2 and 2012.

Worked on SQL Server Reporting Service and Configuration.

Knowledge on ITIL standards and process, willing to work in shifts.

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 Schedules 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.

Educational Qualification

Master in Business Administration from Dr. MGR University, Chennai.

Technical Skills

Databases:

MS SQL Server 2014, 2012, 2008R2, 2005 and 2000,

Programming:

T-SQL,

DBA:

Database Administration of MS SQL Server 2014, 2012, 2008, 2005 and 2000 and Knowledge on MySQL.

Operating System:

Windows 2012/ 2008/2003 Advanced Server,

Tools:

HPSM, NNMI, ApexSQL, Symantec, SCOM, Remedy, CA, coDesk.

Professional Experience:

Job Title: Senior Consultant

Organization: Virtusa POLARIS (Formally, Polaris Financial Technology Ltd, Chennai

Duration: July 2014 to till date…

Roles & 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 Schedules 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.

Job Title: SQL Server DBA

Organization: Cognizant Technology Services [Payroll of Scorg International Consulting], Pune.

Duration: Dec 2012 to April 2014

Roles & Responsibilities:

Extensively worked on DBCC commands and Dynamic Management Objects.

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.

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.

Title: SQL Server DBA Support

Organization: Hexaware Technologies Pvt Ltd, Chennai.

Duration: Jan 2012 to Nov 2012.

Roles & Responsibilities:

Database creation, database refreshes, alert monitoring and Backup script creations.

Checking the database data files and log files for the available free space.

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.

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.

Fixing Orphaned users through Stored Procedures.

Managing the sys database files and make available space on the disks.

Implementation of SQL Logins, Roles and Authentication Modes.

Checking Fragmentation and Resolving Fragmentation issues.

Thanks,

C. Venkat Rama

Contact this candidate