Sql Server Developer
Resume:
Abdul samath .A
***********@*****.***
[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