Docstoc

chandru DBA

Document Sample
chandru DBA Powered By Docstoc
					Chandrasekar                                      Mobile: +91-9943071895
                                                  Email: mchandrumsc826@gmail.com

Career Objective:
    Seeking a challenging position, utilizing my abilities developed through my experience
       and education with an opportunity for career growth based on my merit and to
       promote the growth of the organization.


Professional summary:

       Having 1.8 years of experience in implementation and administration of
        database systems using MSSQL 2005/2008 and Windows Xp

       Involved in SQL Server technologies like Backup & Recovery, Log Shipping,
        Clustering, Indexing, Reorganization and Replication.

       As SQL Server DBA I have extensive knowledge in database Maintenance,
        Automation and High Availability.

       Monitoring SQL Server agent jobs, Performance Tuning (with Profiler) and Query
        optimization.


Professional Experience:

       Presently working as a Junior DBA for Prithiv Technologies., Chennai since June
        2010 to till date.
Educational Qualifications:

       M.Sc from Bharathidasan University with an aggregate of 68%(2008-2010)
       B.Sc from Alagappa University with an aggregate of 59%(2003-2006)
       HSC from State Board of education with an aggregate of 72%(2001-2003)
       SSLC from State Board of education with an aggregate of 79%(2000-2001)


Technical Skills:

Operating Systems            : Windows XP
Languages                    : C++,C#
Databases                    : MS SQL Server 2000 & 2005




                                                                                          1
PROJECT PROFILE:

Project#1

Project Name         :      www.rightchoicemarketing.in
Environment          :      Windows Xp, ASP.Net, SQL Server 2000/2005.
Role                 :      Production DBA
Tenure               :      Sep 2011 to till date.
Team size            :      6
Description:
        Rightchoicemarketing.in, is a pioneered online shopping company and today is
one of the fastest growing shopping destinations on the Internet. With a wide range of
products, thousands of merchants and millions of reviews from the shoppers,
Rightchoicemarketing.in empowers consumers to make informed choices and, as a
result, drives much higher conversion to sale and value for merchants.
Rightchoicemarketing.in is one of the largest and most comprehensive online shopping
networks on the web. it helps shoppers find the best value for virtually anything they want
to buy from thousands of online retailers.

Roles & Responsibilities:

      Set up, configure and administer MS SQL 2000/2005 database server for
       development, test & production.
      Worked in cluster (A/A) environment in SQL Server 2005.
      Backup client databases and perform database restore and run consistency checks
       from SQL Server and application
      Database backups and restore management
      Created Database Maintenance jobs to perform Full, differential & transaction log
       Backups and scheduled them with the SQL server job scheduler.
      Monitor the status of Maintenance jobs – schedule to run daily and on weekends
       (tasks like rebuilding indexes, Shrink Database).
      Configuring and managing Alerts
      Created DB objects like Indexes, Stored procedures using T-SQL and maintain them.
      Managing Log shipping, Mirroring.
      Implemented Transactional Replication.
      Performance tuning using SQL Profiler and Query optimization techniques.
      Maximum database size is 470 GB
      Database Transformation Services for Import as well as Export of Data to & from Other
       Applications being used by the Organization Applying security patches using batch jobs.




                                                                                          2
Project#2

Project Name         :      www.sharpya.in
Environment           :     Windows xp, ASP.Net, SQL Server 2000, 2005
Role                  :      Production DBA
Tenure               :      June 2010 to Aug 2011
Team size             :     5



Description:

Sharpya is an information database site which provides reliable and useful information on
the essential things for people in all categories like children, students, youth, job seekers,
career planners, investment lookers, housewives, part time job seekers and retired.
Registered Members can participate in the discussion forums thereby can get answers for
their queries from the other expert members in the portal.
There is lots of Knowledge database in “K-Sharpya” by which members can be benefited for
finger tips of the information for their needs. “Mane Adige” is the information database on
the house made food recipes. Members can gain points for their contributions in the site and
these points will promote the members for the higher levels. The active members will be
treated as promoters of the site and will be benefited appropriately. Members can refer
resourceful persons as members to the site and can earn more points. There are many
sections in the site like Schools, olleges, Universities, Old Question papers etc., will be
useful for the students and academicians.

Roles & Responsibilities:
      Database Backups & Restoration, Backup Strategies, Scheduling Backups.
      Creation of Logins, Roles and Granting rights.
      Granting the users to access the Applications.
      Automation of Maintenance jobs.
      Create user database
      Regular checking of the database consistency using DBCC commands to minimize
       complexity
      Create database maintenance Plans
      Database fine tuning and indexing
      Create ODBC SQL Server data sources
      Monitor SQL Server performance and activity




                                                                                             3

				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:75
posted:5/3/2012
language:English
pages:3