OBJECTIVE:

• IT professional with over 6.6 years “hands - on” experience in managing large-scale databases in production support environment on windows platform. A database administrator with a proven track record of technical skills, who has the ability to work on multiple highly visible projects, is a creative problem solver, and has an aptitude for learning.

SUMMARY:

• Troubleshooting expertise in SQL server issues under production environment.
• Exposure in handling the entire production servers with skills and understanding client’s requirement.
• Good expertise in handling Suspect Modes.
• Experience in High Availability options like Log Shipping, Mirroring, and Replication &Clustering.
• Performing in-place and side-by-side migration in SQL Server 2005.
• Possess experience in translating new ideas into client’s solutions including opportunity identification, providing high availability solutions, delivery, and support.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and client service.

TECHNICAL SKILLS:

Operating System: Windows XP, Windows Server 2003,Windows Server 2008

Database: SQL Server 2000, 2005, 2008 & 2008 R2,2012

PROFESSIONAL EXPERIENCE:

Confidential

Environment: SQL Server 2000, 2005, 2008 & 2008 R2, 2012

DBA

Responsibilities:

• SQL Server 2005, 2008 and 2012 installations, configuration and security settings for standalone servers.
• Implement database administration/ maintenance plans with database backup and restorations.
• Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring, Replication, and Clustering.
• SQL Server upgrade with service packs and hot fixes in Clustered and standalone environments.
• Monitor database usage and growth trends to forecast future storage needs as Capacity planning measure with request of application team.
• Maintaining/Creating logins/users and giving permission to them as per request.
• Working on file moment activities as per request with application teams.
• Performance Tuning - Understanding and recommending based on Execution Plans, Performance monitor and Profiler.
• Optimized the performance of queries by creating indexes wherever necessary.
• Effective usage of DBCC Commands ensuring integrity of the databases.
• Handling blocking/locking issues and troubleshooting accordingly.
• Hardening of database as per audit requirement.
• Successfully done various DR Switchover & Switchback on Log shipping & Database Mirroring.
• Successful migration of SQL Server 2005 to SQL Server 2008, 2012.
• Recommended and Implemented many housekeeping activities (Index Tuning, space management, Improving Execution plan cost, Maintenance Plans).
• Provided stats for bad/over indexed tables which improved space and time for Index maintenance.
• Highlighted I/O bottleneck issue on Production server through Pro-active monitoring.
• Recommended ad hoc queries to merge from Front - end coding to Stored Procedures for reusing cached plans instead of compiling every time.
• Successfully recovered SA password which was locked where no other sysadmin login was available.
• Taken handover and worked on SSRS and SSIS in short period to handle new client requirement .Self-Learned basics of BI tools to monitor and trouble shoot L1 issues.
• Compiled Knowledge Transfer documentation for knowledge sharing.
• Documentation Report/Review - Site Documents, System Study, Backup Policy, Security Policy, Performance Management Document, Patch Management Document, Activity Report, Incident Report, Monthly Service Report etc.
• Design the project plan and plan of actions for miscellaneous projects like Database Migration, Disaster Recovery solutions etc.
• Creating CR’s for every client\Customer-raised request and from users/application team.
• Keeping the track of all critical databases & server related information in Excel sheet.
• Documenting all new resolved tasks/environment details in share point for .
• Maintaining Run Book as a constant practice and updating it continuously.
• Monitoring, Reviewing & approving change records with 100% SLA.
• Providing KT for New joiners about the processes of KMBL
• Always maintains 100% Non-complaint to follow the ITIL processes.I implemented new processes to collect customer feedback for every activity and entire team is following same.

Confidential

Environment: SQL Server 2000, 2005

DBA

Responsibilities:

• Ace Commodity Exchange earlier known as Ahmadabad Commodity Exchange has been in existence for more than 5 decades in Commodity Business, bringing in the best and transparent Business Practices in the Indian commodity space.
• Providing SQL DBA support to ACE and all its application suites on Production as well as development support DBA as SQL server Administrator Support mainly includes L1 & L2 activities. Single point of contact for SQL server administration related tasks. Team maintains about 200 servers.
• The above enclosed CURRICULUM VITAE are for .
• With the above information, May I hope your consideration will merit my application favorably and place me a chance to join your esteem organization.
• Afford an opportunity I shall prove my worth to the best of your satisfaction.