SQL DBA

Paul .D Mobile Number: +91-950*******

Email ID: *************@*****.***

Objective:

Seeking a challenging position in a progressive organization that gives me challenges and opportunities to enhance my knowledge and hone my skills in accordance with latest trends and part of a team that dynamically work towards the growth of the organization and contribute to the success in the MS SQL Server Database Administrator.

Summary

About 7+ years of extensive experience as a MS SQL DBA which involves supporting business critical production servers automate DBA activities, performing Installations efficiently solving issues within Service Level Agreement.

Experience installing, Upgrading, configuring, Migration and performance tuning in MS SQL Server 7.0,2000 ,2005 and 2008.

Experience in production support for Large Scale SQL server databases.

Excellent experience with MS-SQL server databases in terms of creating database and objects.

Experience in SQL server and Back up recovery with Sound Knowledge and experience in Transact SQL (T-SQL) coding, Administration SQL Server 2000,2005 and 2008.

Strong communication and interpersonal skills.

Fast learner, self motivated, with a high degree of attention and commitment to work.

Professional Qualifications

Course Institution Year of Passing Aggregate

B.E.,

(Computer Science) M.S. University, Thirunelveli

2000 – 2004

First Class 76%

HIGHER SECONDARY N.N. Hr. Sec. School, Vadakangulam

1999 – 2000

First Class 80%

SECONDARY N.N. Hr. Sec. School, Vadakangulam 1997 – 1998 First Class 82%

Certification

Certification : NIIT Microsoft Training Course.

Center : NITT Technologies PVT LTD (Bang lore).

Course : SQL server administration and designing Course.

Certification : IBM MAINFRAME Training Certification

Center : MAPLES@ESM Technologies PVT LTD (Chennai).

Course : Mainframes Application Programming, DB2 UDB

Computer Skills:

RDBMs : Sqlserver (7.0-2000-2005-2008)

Utilities : pl/sql, t-sql, sqlprofiler, DTS

Operating Systems : WINDOWS 9X/2000/2003/2008/NT

RDBMS Tools : Desktop DBA

Remedy Tools : EARS 5.2

Remote Client Acces : Tivoli Remote Control, Terminal Server Client, Netfinity Tools,Landesk Client, DamWare, Tool Console, Net Support Manager.

Backup Tools/Utilities : TDP Client for SQL, BMCBacktrack

Hardware : Proficiency in hardware components, configuration of

components and experience in all kinds of installations.

Professional Experience

MPHASIS on HP company 10 JUNE ’10 t0 ‘till now

Working as a SQL DBA regular employee

Company Address : MPHASIS on HP company ,

DLF,1B,3rd floor, # 1/124 Shivaji Garden , Manapakkam,

Chennai – 600089 India

Designation : SQL Database Administrator

IBM Global Services India Pvt. Ltd 02 JUL ’07 to 30 MAY’2010

Working as a SQL DBA as IBM regular employee

Company Address : IBM India Pvt Ltd ,

DLF IT Park, 1/124 Shivaji Gardens,

Nandambakkam Post, Ramapuram, Chennai - 600 089 India

Designation : Operations Senor Lead Specialist

Maples@Esm technologies pvt ltd 16 Feb ’06 to 02 JUL ‘07

Worked as a SQL DBA for IBM as Contractor thro’ Maples@ESM Technologies Pvt Ltd

Company Address : IBM India Pvt Ltd.

Embassy Golf Links Business Park,

Block D, Koramangala Intermediate Ring Road,

Bangore - 560071

Designation : SQL Database Administrator

Tyco&Hoffincons InfoTech pvt ltd 17 JAN ’05 to 05 AUG ‘05

Working as a VB and SQL Developer as regular employee

Company Address : Tyco, Hofincons Infotech & Industrial Services Pvt. Ltd.

6th Floor, Gee Gee Universal,Door No 2,18/1&2,McNichols Road,Chetpet, Chennai – 600031

Designation : Application developer

Role’s and Responsibility:

DBA Support as SQL Server

Installing, Configuring, Managing SQL server 7.0,2000,2005 amd 2008.

Installing, Configuring, Managing Replication,Log shipping and Cluster.

Monitoring Database & providing 24X7 Support to critical application database

Monitoring & configuring Jobs, Maintenance plans etc.

Performance monitoring, user creations and Configuring permissions depending on the requirements

Backup and restoring Databases

Resolving issues based on requests by help desk tool within SLA

Setup and maintain Project documentation and standards

Disaster Recovery planning & Implementation (Planned & Unplanned)

Nature of Regular works as an SQL DBA

Ensure that all services are up and running.

Ensure network connectivity to the server.

Check the Windows NT Event Viewer for error messages.

Check for adequate disk space for growing database files and log files.

Check SQL Server jobs for failures.

Check SQL Server logs for error messages.

Backup the SQL Server transaction log.

Monitor Windows 2000 and SQL Server counters in System monitor to ensure optimal performance.

Track Locking, blocking, deadlocks, long-running queries, and high-resource queries.

Perform full / differential database backups of all system and production databases on Weekly and Monthly basis.

Remove extra space from log and data files on Weekly basis.

Perform a complete restore of all monthly system and Production database backups on Test Machine.

Perform DBCC CHECKDB on all restored system and Production databases.

Monitoring the transactions in SQL Server using traces and stores them into tables to check the abnormal transactions and Locks.

Creating Reports as per requirement of the users and give rights to them.

Thro’ DTS from SQL to Excel - Data Imported on daily basis to update the reports.

Responsibilities

Working knowledge of SQL Server 7.0,2000,2005 and 2008.Enterprise Manager, SQL Server Profiler, SQL Server Agent, and SQL Server Surface Area Configuration.

Installing and Configuring Instances of SQL Server,SQL cluster and SQL services.

Maintained all and T-SQL stored procedures, functions, triggers and scripts

Execution Plans / Debugging

Experience in writing/maintaining Scripts in support of DBA duties

Troubleshooting various database issues and T-SQL queries

Optimized SQL Statements

Strong knowledge in Backup and Recovery

DTS, database design, creation, performance tuning, rights management, administration

Managed and maintained data distribution in all production and non-production databases and replication servers.

Performed and managed database administration to ensure database availability and enable the proper database monitoring

Generating Scripts for Tables, Stored Procedures, Functions, Triggers etc.

Ensure SQL Services status

Allocating and Altering Space requirement of Data and Log files

Designing Backup and Restore Policies

Identifying and Resolving Abnormal Database Status

Identifying and Resolving Blocking related issues

Troubleshooting Log Shipping

Automating Admin activities using T-SQL

Responsible for Resolving Data Transfer related queries

Maintain and Audit Database Security

Provide assistance to resolve user queries

Monitoring SQL Server Jobs

Special Achievements

IBM Bravo award

Database Admin Tasks sip

Efficient handling of Clients request within duration

Involved more RFS work’s

Brought up the server from Total system Crash. (Disaster Recovery)

Went to client side (U.S) to collect new SQL server account details for IBM(2008)

Passport Details

Passport No : F1381181

Date of Issued : 29/11/2004

Date of Expiry : 28/11/2014

Place of Issue : TIRUCHIRAPPALLI

Passport Status : ECNR

Personal Details

Father’s Name : G.Devaraj

Date of Birth : 05th April 1983

Sex : Male

Citizenship : Indian

Marital Status : Married

Permanent Address : No 307, S\O Devaraj, Radhapuram road,

Vadakangulam,

Tirunelvel Dist,

TamilNadu,

India

Pin: 627116.

I hereby declare that all the particulars furnished above are true to my conscience and submitted after thorough introspection. Thank you.

Your‘s sincerely,

(D.Gnana Raja Paul)

Contact this candidate