I have 8+Years of experience in SQL Server Database Administration (support on a 24x7)
Having onsite experience (USA)
Administration including Planning, Installation, Deployment/Implementation, Configuration of MS SQL Server
2000/2005/2008.
Worked closely with management, development, QA, Release teams and users
Experience in creating databases and monitoring the growth of the databases, as a part of capacity planning
Developing the successful Backup strategies based on Recovery models
Creating and monitoring jobs for automating daily tasks like backups, checking integrity of databases,
updating statistics
Checking the status of Backup troubleshooting the failed backups and Restoration of databases
Creation and maintenance of Databases, Assigning Roles and managing user permissions
Ensuring data consistency in the database through DBCC and DMV commands
Experience on Replication setup and troubleshooting the replication problems
Experience on Log shipping setup, Monitoring and troubleshooting Log shipping Issues
Maintained and developed Fail-Over databases using Database Mirroring
Upgrading experience on databases from 2000, 2005 and 2008
Creating and troubleshooting of Linked Servers.
Migration of databases between the servers (From Development, Testing to Production Environment)
Migrating the oracle Databases to SQL Server.
Applying Service Packs on SQL Server Cluster
Coordinating with the field Onsite Team in