Sql Server Database

RAJESH KUMAR VADIVEL Mobile Number 919-***-****

E-Mail: *************@*****.***

PROFESSIONAL SUMMARY

9+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2016/2014/ 2012, SQL Server 2008 R2, 2008 and 2005.

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

Worked on logical and physical data base modeling with UML and ERWIN tools.

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Log Shipping and Database Mirroring.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2016, 2014/2012 migration from SQL Server 2008 / 2005.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Having Experience on Data center servers and handling 1.4 TB databases.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

Technical Education

Masters in Computers Application Systems Bharidhasan University (2003).

Technical Expertise

Databases:

MS SQL Server 2016, 2014, 2012, 2008, MS SQL Server 2005

Programming:

Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA:

database administration of MS SQL Server 2012,2008, 2005

Operating System:

Windows 2012/2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software:

Windows 2012/2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools:

Backup Utility, SQL Lite Speed, Visio

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Professional Experience

• Working as a MSSQL DBA in HCL America –

Project Name: BB&T (Branch Banking & Trust) from July 2011

Location: Raleigh, North Carolina

Responsibilities:

Involved in working on both production and development engineering support.

Administration support of SQL Server 2000, SQL Server 2005, 2008, 2008R2, 2012, 2014 databases

Created different reports using SQL Server Reporting Services

Involved in Scheduling the SSIS packages to run at different time intervals. Fixing SSIS packages related issues.

Created Linked Servers to manage and interacts data between different servers.

Created Log shipping to move data from one server to another server, and scheduled to move this data at different intervals.

Worked on Profiler, Performance monitor to tune the databases and query

Regular troubleshooting tasks.

Windows administration tasks, users management etc.

Database Administration issues related to Performance Tuning, Analyze execution plans and generate suggestions for performance improvement.

Deployed and managed reports using SQL Server Reporting Services (SSRS).

Installed and managed reports using SQL Server 2005 /2008 Reporting.

Worked on DTS, Import and Export utility for copying / moving data from one server to another server.

Maintained views, stored procedures and indexes.

Used SQL Profiler to capture the activities of the databases and used the trace file for Database Tuning.

Installation of SQL Server 2014 / 2012 / 2008R2 / 2008 / 2005 on Windows Server Clustered environment.

Created the new database and database objects like views, indexes, stored procedures, functions, and advanced queries.

• Worked as a MSSQL DBA in Tata Consultancy Services (TCS) –

• Project Name: A C Nielsen from March 2010 till July 2011

Location: Chennai, India

Responsibilities:

Administration support of SQL Server 2000, SQL Server 2005 &2008 databases

Regular troubleshooting tasks.

Windows administration tasks, users management etc.

Database Administration (Performance Tuning, Maintaining Users etc.).

Upgrading of SQL Server Instances from lower version to higher version.

Installing MSSQL Server 2000, 2005 & 2008 Client and Patch installations

Also refreshing Database as per the requirements of the clients.

Creation of Database Maintenance Plans and running DBCC statements.

• Worked as a ASSOCIATE CONSULTANT - SYSTEMS in HCL from May 2006 till March 2010

Project Name: Armstrong World Industries

Position: Database administrator for Oracle and SQL Server Database Systems.

Worked as MSSQL and Oracle database administrator for global client Armstrong World Industries in Lancaster, United States.

Location: Chennai, India

Responsibilities:

Administration & 24*7 support of SQL Server 2000 and SQL Server 2005 databases

Regular troubleshooting tasks.

Windows administration tasks, users management etc.

Database Administration (Performance Tuning, Maintaining Users etc.).

Backup and Recovery Operations (including backing up databases to tape etc.).

Database Restore using VERITAS Net Backup Client and also having knowledge about VERITAS Net backup Client

Installing & applying service packs on Clustered / Non-clustered environment of SQL Server 2005.

Installation & configuration of SQL Server 2000/2005 Editions.

Involved in incident and problem management process support through remedy software, HP Service Desk and meeting the SLA needs of the customer.

Also involved in documentation of processes and procedures.

Responsible for managing and supporting all Production, Development and Testing instances of Oracle Version 8i, 9i,10g and MSSQL Server 2000, 2005 & 2008.

Administering Database in various platforms like WINNT 4.0, WINDOWS SERVER 2000 and 2003, HP-UX, and UNIX.

Maintaining (LDB) OLTP databases in 24x7 Production environments.

Monitoring and troubleshooting various databases remotely, for database located in the US.

Involved in Oracle server, client, and patch installations.

Install and configure Database as of Oracle’s Optimal Flexible Architecture (OFA).

Upgrading of SQL Server Instances from lower version to higher version.

Installing MSSQL Server 2000, 2005 & 2008 Client and Patch installations.

Installing new versions of database software and perform maintenance functions of the database.

Creating new Database, perform regular backups for the entire database and maintaining the Databases.

Maintaining data integrity and tuning database for optimum performance and availability.

Also refreshing Database as per the requirements of the clients.

Creation of Database Maintenance Plans and running DBCC statements.

Having knowledge about MSSQL Replication and all high availability concepts.

Monitor usage of the databases and perform database tuning.

Table space Monitoring (Grid Control) and User Administration.

Creation of RMAN backup scripts.

• Worked as a SENIOR TECHNICAL ENGINEER (ACTING TEAM LEADER) in SUTHERLAND GLOBEL SERVICES from March 2004 – April 2006

Location: Chennai, India

I hereby declare that all the above details furnished by me, are true to the best of my knowledge.

Place : USA (V. Rajesh Kumar)

Contact this candidate