Abdul samath .A

acdi09@r.postjobfree.com

****-888-***-****

[pic]

Executive Summary

Around 9 years of experience in Microsoft SQL Server database management

and development plus Performance tuning.

. Excellent backend skills in creating SQL objects like Tables, Stored

Procedures, Views, Indexes, Rules, Defaults, user defined data type and

functions.

. Expert in T-SQL programming skills. Expert in Query optimization &

performance tuning. Used SQL profiler, Execution Plan, Performance

monitor and DBCC commands.

. Experience in Database backup and disaster recovery procedures.

. Experience in Transactional replication & Log shipping.

. Has the ability to work in a fast paced environment, Good team player and

can work independently. Helped the developers on technical issues.

Technical Summary

Web technology - ASP.Net, IIS

Database - SQL Server 2000, SQL Server 2005 and SQL Server 2008 R2

Tools - Crystal Reports.

Academic Summary

MBA (2 yrs), Annamalai University, TamilNadu, India (2006 - 2008)

MCom (2 yrs), Annamalai University, TamilNadu, India (2003 - 2005)

BCom (3yrs), Annamalai University, TamilNadu, India (2000 - 2003)

Certifications

Microsoft Certified IT Professional (MCITP) - (SQL Server 2005) - Scored

81%

Microsoft Certified Technology Specialist (MCTS) - SQL Server 2005

Microsoft Certified Professional (MCP) - (SQL Server 2000) - Scored 91%

Transcript ID: 808808

Access Code: 6375912A

Experience Summary

July 2005 to Aug 2008 - Web developer cum Support Data base (sql 2000), EDS

Pvt Ltd.,

Client Acer Computer M.E Ltd.

Dubai. UAE.

Sep 2008 to Aug 2012 - Production support (Data base developer SQL 2008),

SeventyMM Pvt Ltd., India.

Sep 2012 to till now - SQL Developer cum DBA (SQL Server 2008 R2, SQL

2012 Denali)

Blue Star InfoTech Ltd., Bangalore, India.

Significant Projects Summary

Blue Star InfoTech, Bangalore India

Sep 2012 - till now.

Project Name is Travco

Travco is leading global hotel wholesaler. Our core business is supplying

hotel accommodation to the travel trade. By cooperating with thousands of

international hotels we are able to offer an outstanding selection of

global accommodations. Our clients can book hotels in 5 seconds through our

advanced online booking application systems, and providing multilingual

options for 9 languages to global clients.

We are handling past 20years data of 3star & 5star hotel bookings and

contracts from Agent to Customers and Agent to Subagent in all over world.

I have involved the migration operations from different structured data

base to SQL server and have done Optimization lot more procedures,

functions, which all are developed for past three years for this product.

I have good knowledge in DMV, DMF, SSIS and SQL System Objects (System

tables, System views, procedures and functions).

Environment : SQL Server 2008 R2, SQL Server 2012

Role : DBA, SSIS, SSRS Developer and migration data.

Duration & Team Size: 1.6 Year and 27 Members

SeventyMM Pvt Limited, Bangalore India

Sep 2008 - Aug 2012.

Admin and guide is a CRM application mainly used for customer supports and

Online shopping (E-commerce) Module. Our applications support 10 lakhs

customer's records and frequently update, insert bulk and modifying the

customer packages.

Environment : SQL Server 2005 & SQL Server 2008 R2

Role : DBA, SQL server 2005, 2008 Developer and Production

Server database support.

Duration & Team Size: 3.6 years and 30 Members

Responsibilities

. Responsible for installation and configuration of SQL server 2005 & 2008

database on the servers.

. Developing SQL scripts for maintaining administration tasks.

. Based on the business needs created Transactional replication in

database.

. Estimating of table sizes and record sizes.

. Trouble shooting problems by using SQL server Profiler.

. Solved critical production problems and performed point in time recovery

plans.

. Implemented database standards and naming convention for the database

objects.

. Data base objects like Tables, Stored Procedures, Views, Rules, Defaults,

user defined data types and functions for this project.

. Experienced in resolving deadlock and blocking issues for concurrent

users.

. Developed database backup scripts and automated this process -

Maintenance Plan

. Provided 7 X 24 production supports for the database and application

issues.

. Interacting with the users and troubleshooting the problems involved with

the development of stored procedures.

. Created and maintained Users department, Users role and User groups.

. Focuses on Index tuning and fragmentation of the Index pages with the

help of alter index script and finalize based on the average

fragmentation >30 then doing "Rebuild" and < 30 then doing "Reorganize"

and automated from the maintenance plan in sql server objects.

. Rewrote and tuned long running SQL queries to cut execution time, ease

database load and improved scalability.

Easy design system Pvt limited

Client: - Acer Computer M. E Ltd., (Dubai, UAE)

July 2005 - Aug 2008.

CSS Logistics - Customer Support Service.

Few months worked in ASP .Net coding with html pages for CSS (Repair centre

and Call centre application)

Then moved to create and alter stored procedure as well as do reports in

Crystal Reports.

Environment : ASP.Net, VB.Net, Crystal Reports 9.2, SQL Server

2000, Infragistics Controls

Role : Web developer, SQL server developer and Production

server database support.

Duration & Team Size: 3 years and 16 Members.

Responsibilities

. Partly involved install, configure and upgrade MS SQL Server with the

help of Upgrade tool.

. Involved performance tuning.

. Used MS Visual Source Safe 6.0 as a version control system.

. Developed the Master Admin pages (ASP.Net) with third party control

Infragistics grid.

. Generated Dynamic reports using Crystal reports.

. Responsible for developing GUI screens with the help of dream viewer.

. Defined relationship between tables and enforced the referential

integrity constraints. Created clustered and non clustered Indexes.

. Monitored User accounts, User permissions user roles and user groups.

. Created and Monitored the Jobs which is failed then sent a mail thru sql

server mail.

Personnel Details

Date of Birth: 30th June 1975.

Gender: Male

Marital Status: Married

Nationality: Indian

Languages Known: English, Hindi, and Tamil

Permanent Address: 12G/1, Rettai Voykkal Street, Tennur, Trichy - 620 017,

Tamil Nadu, India

Contact this candidate