SUMMARY

• Over 8 years’ experience in IT, 6+ years of experience in Database Administration and Production support using Microsoft SQL Server 2000, 2005, 2008 and 2008R2.
• Hands on Experience in installing, configuring and monitoring SQL Server 2000, 2005, 2008 and 2008R2 standalone instances
• Migration from MS - SQL Server, 2008 and 2008R2, Upgrading service packs and hot fixes on SQL Server instances.
• Installing and configuration of Reporting Services.
• Installation of SQL Server 2008 R2. Upgrading SQL Server 2005 to SQL Server 2008 R2 using In-place and side-by-side methods.
• Active participation with customers in understanding their business process and suggesting optimal database structure, practices and tools on specific projects, ensuring high customer satisfaction rates.
• Experience in Database Backup, Restoration, and Recovery procedures.
• Experience in implementing and maintenance of different types of Replications like Snapshot, Transactional and Merge
• Configuring and maintenance of Log shipping and Data Base Mirroring.
• Performance monitoring
• Experience in using DBCC Commands
• Setting up and Maintaining of SQL Server failover Clusters
• Knowledge on SharePoint (MOSS 2007)
• Planning and Creating Databases as per Microsoft Recommendations.
• Experience in Database Backup, Restoration, and Recovery procedures.
• Setting up processes for regular backups and restore methods, and ensuring the processes are followed.
• Identity Management (IDM).
• Disaster Recovery Planning & Implementation.
• Upgrade experience from SQL Server 2000 to SQL Server 2005, 2008 and SQL Server 2005 to SQL Server 2008 and 2008R2.
• Upgrading service packs and hot fixes on SQL Server instances.
• Knowledge in every aspect and all phases of Software Development Life Cycle (SDLC) and completed SDLC Training in Confidential and Confidential Compliance Wire.
• Supported 24 X 7 production environments.

TECHNICAL SKILLS

Databases: SQL Server 2008R2, 2008,2005, 2000

Operating Systems: Windows XP,2003 and 2008R2

Database Tools: SQL Profiler, Query Analyzer

Other Tools: Lite Speed 5.0 and 6.0,CommVault

PROFESSIONAL EXPERIENCE

Confidential, Silver Spring, MD

Sr. SQL Server DBA

Environment: SQL Server 2000, 2005, 2008 and 2008R2

Responsibilities:

• Active participation with customers in understanding their business process and suggesting optimal database structure, practices and tools on specific projects, ensuring high customer satisfaction rates.
• Installation of SQL Server 2008, 2008R2 and applying the latest service packs/hot fixes.
• Upgrading SQL Server 2000, 2005 to SQL Server 2008R2 either using side-by-side methods.
• Upgrading SQL Server 2005 to SQL Server 2008 R2 using In-place and side-by-side methods.
• High availability through Clustering and Mirroring
• Production database administration of highly critical databases.
• Setting up processes for regular backups and restore methods, and ensuring the processes are followed.
• High emphasis on database security, permissions, user management.
• Planning for the DR and set up the DR for Critical databases.
• Fully understand the SLA commitment and meet the standards.
• Working on day to day Production database issues.
• Supported 24 X 7 production environments.

Confidential, Raritan, NJ

Sr. SQL Server DBA

Environment: SQL Server 2000, 2005 and 2008

Responsibilities:

• Installation and administration of MS SQL Server 2005 and 2008
• Upgrading the server from SQL Server 2000 (MSDE, Standard and Enterprise) to SQL Server 2008 Enterprise.
• Installation of SQL Server 2008 (Slipstream) on Windows Server 2008R2 in Test Environment.
• Performing the all Test cases on SQL Server 2008 on Windows Server 2008R2 in Test Environment.
• Working on migration of Cognos and BI applications databases from shared environment to Dedicated Servers.
• Worked on Complex Project IDM (Identity Management from Novell)
• Prepared and test the standard checklists prepared by Engineering Services Team
• Trouble shooted the performance issues.

Confidential, MD

SQL DBA

Environment: SQL Server 2000 and 2005

Responsibilities:

• Installation and administration of MS SQL Server 2000 and 2005
• Experience in Database Backup, Restoration, and Recovery plans
• Setting up and maintaining of Replication - Transactional & Snapshot
• Configuring and maintenance of Log shipping and Data Base Mirroring.
• Monitoring and trouble shoot the deadlocks
• Creating and Running Maintenance Plans during Maintenance Window.
• Monitoring Backup jobs and Resolve the jobs failures
• User administration and authorizations
• Resolve the space issues on servers by shrinking the log files and data files

Confidential

Software Engineer (DBA)

Environment: SQL SERVER 2005

Responsibilities:

• Upgraded databases in SQL Server 2000 to SQL Server 2005.
• Data base Backups, Restore, and Recovery procédures.
• Implementation and maintaining of Replication and Log shipping.
• Monitoring replication.
• Performance tuning of the database.
• To notify the End Users of the data availability in the central server.
• Scheduling Alerts and Jobs
• Monitoring the jobs schedules and trouble shoot in case of any failure.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.

Confidential, NJ

Software Associate (Junior DBA)

Environment: SQL Server 2005

Responsibilities:

• Maintaining the jobs schedules during the night for the Backup of Databases.
• Scheduled the Full, Differential and Transactional log backups for the user created and system databases
• Created the schedules for Backups and Replication.
• Created Server Logins and Database Roles to define Security.
• Scheduled the Alerts and Jobs Using SQL Server Agent.
• Check the SQL logs for errors and monitoring the disk spaces.
• Supported 24 X 7 production environments.