Sql Server Manager

Experience Summary - SQL Sever Admin & ETL Expert

. 10+ years of experience in Installing, configuring, administering,

Clustering and securing SQL server.

. Implementing and administering database replication between SQL Server

databases.

. Experience in Implementation of Failover Clusters across the servers

. Implementation of Always on feature for SQL Server 2012

. Data analyzing, deploying and dynamic configuration of SSIS Packages

. Involved in Production Support and monitoring the data loads.

. Creating jobs to automate repetitive tasks in SQL Server.

. Analyzing and resolving the dead lock issues.

. Collecting the list of Long running queries and Tuning the queries

. Implementation of table Partitions

. Gathering the list of huge tables and compressing where ever required

. Implementing Auditing

. Regular analysis and resolving the issues for a server with 7 Node

Clustering

. Work on the SQL SERVERS with huge configuration and huge Data Loads

which involves transactions for every minute

. Analysis of SSIS packages and tuning them

. Implementing SQL server security as per the requirements.

. Monitoring and Setup maintenance plans like backup\restore database.

. Gathering the stats for Data VS Log growth analysis and implementing

best Practices

. Shrinking the large growing databases on scheduled basis and disk

space management.

. Troubleshooting performance issues and fine-tuning queries and stored

procedures.

. Administering the Microsoft Internet Information Services (IIS) 6.0.

. Configuring SMTP services in the IIS.

. Installation of Windows 2003 Server

. Troubleshooting issues related to IIS, .Net framework, File\Folder

security and SQL server.

. Creating and configuring Basic and Dynamic Disk and different types of

Volumes, and Disk Quotas.

. Involved in different Tools setup in the Servers (HP QualityCenter9.2,

VSS, Rational Test manager, MS project, Perforce

Technical Expertise

Elements Particulars

Primary Skills SQL DBA, SSIS and DTS.

Operating Systems Windows Server2000, Windows

Server2003, Windows Server2008,

Windows Server2012, XP, Linux,

Windows2007 and 2008.

Languages & Dev Tools SQL, TSQL, PLSQL, .Net, VB Scripts,

HTML,Spotlight, Embarcadero.

Databases & connectivity SQL SERVER 2000/2005/2008/2012 and

Oracle 9i/10g, OLEDB, ODBC

Testing and other Tools Mantis, PVCS, Rational Test manager

and HP Quality Centre

Education

Bachelor of Engineering from Anna University - Chennai India

Contact this candidate