Sr SQL Server DBA/Developer

CURRICULUM VITAE Anand.N

Ph no: +91-888*******

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

OBJECTIVE

To work in a competitive and challenging environment contributing to the best of my ability towards the growth and development of a progressive organization and to fully utilize my innovative skills to pursue a rewarding career.

Profile Summary:

I am having 3.8 years of experience in IT industry in Microsoft technologies as a SQL server Administrator. Working as a DBA for Microsoft account in production team.

Technical Skills:

Microsoft Technologies: SQL server 2000, SQL server 2005.

Databases: MS SQL Server 2000, MS SQL Server 2005.

Tools & Utilities: Enterprise Manager, Query Analyzer, SQL Server Management Studio, SQL profiler, SQL Server Business Intelligence Development Studio.

Web Server: IIS 6.0, IIS 7.0

Languages: C, C++, SQL,T-SQL.

Operating Systems: Windows 98/2000/XP/2003/2008, MS-DOS, windows server 2000/2003/2008

Roles and Responsibilities executed:

Extensive Experience with SQL Server 2000& 2005.

Experience in Installation, Configuration, Maintenance of Microsoft SQL Server.

Extensive experience in implementation and maintaining of Mirroring, Replication, Log Shipping.

knowledge in SQL Clustering.

Excellent experience in creating, managing and troubleshooting Linked Servers.

Provide input into repair plans and Participate in post mortem meetings, root cause analysis and unplanned outages.

Excellent experience in Implementing Database maintenance plans, Configuring SQL Mail, Optimizing SQL Server Agent, and Managing Operators.

Proactive Monitoring of databases for 24 X 7 availability.

Developing successful Backup strategies based on recovery model.

Optimizing and Automating SQL Server Administration.

Managing Transaction Log files.

Hands on experience in migrating databases from one server to another.

Performance tuning Query tuning, database performance tuning.

Performing Database tuning to improve performance.

Projects Profile:

HCL Technologies, Hyderabad

NOV2010 – till date

TITLE : Production Server Management.

CLIENT : Internal

TECHNOLOGIES : Win 2003 Server, SQL Server 2000, 2005.

ROLE : DBA.

• Routine DBA activities like analysis of Space Availability, Backups (transaction log, complete and differential) and Scheduled Jobs.

• Monitoring Snapshot and Transactional Replication and Log shipping between the nine servers and the central server and trouble shooting in necessary conditions.

• Updating Service packs and Security patches for the Servers.

• Testing the Data Backup by restoring as test database in a test server.

• Setting up of full-proof Disaster Recovery Mechanism.

• Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.

• Monitoring of server performance by profiler during peak periods of server utilization.

• Create and re-evaluate Indexes and made needed modifications for better performance.

• Creating and Reviewing Security features for all the servers.

• Documentation of Server Builds specifications and Security features.

• Participating in process, application and database audits.

Wissen Infotech, Hyderabad

JULY 2009 – SEP 2010

Role: DBA

Client: Microsoft

Skills: SQL Server 2000,IIS 6.0,SQL Server 2005,

Operating System: Windows Server 2003, Windows Server 2008

Database: SQL Server 2000, SQL Server 2005

Contribution:

• Login Creation, User Roles and right policy etc

• Backup Data bases

• Performance Monitoring.

• Running various DBCC command at database.

• Making changes in the database with respect to the change document.

• Trouble Shooting all user related issues.

• Managing Database Security.

• Creating new Maintenance Plans.

• Backup Data bases and & Restore them in case of a Disaster.

• Working with the users over the mail and IM for resolving the real-time issues.

• Creating maintenance plans and managing SSIS packages incorporated into the jobs

Wissen Infotech,Hyderabad

MAY2008 – MAY2009

Role: DBA

Client: HSBC

Skills: SQL Server 2000,IIS 6.0,SQL Server 2005,

Operating System: Windows Server 2003, Windows Server 2008

Database: SQL Server 2000, SQL Server 2005

Roles & Responsibilities:

Monitoring the dashboards, acknowledge the alarms and resolve/escalate this to the support teams.

Using Active Directory (Multi-site/Multi-domain) Users and Computers to create/modify/delete users, groups, and contacts.

Understanding the Helpdesk operations and being aware of the latest changes and updates regarding the Process and implementing new procedures without fail.

Troubleshooting permissions, account lock-outs, network connectivity, services and IIS Administration.

Server O/S installation, configuration, upgrade, patching and troubleshooting.

Academic Background:

Completed B.sc From Acharya Nagarjuna University in 2006,Securing 65%

Completed INTERMEDIATE from VIKAS College, in 2003, securing 65%.

Completed 10th from Shanthi Nikethen in 2001, securing 70%

Work Experience:

Present working as a sql dba in Hcl Technologies from nov2010-Till Dtae

worked as a sql server dba for wissen infotech from may 2008-sep 2010

Personal Information:

Date of Birth: 10-05-1986

Gender: male

Marital Status: Single

Contact no: +91-888*******

Email Address: *****.**********@*****.***

Contact this candidate