Banner Image

Services

  • 7 + years of experieas as SQL Database a

    $300/hr Starting at $250 Ongoing

    Dedicated Resource

    Professional Summary •7+ years of experience as a Database Administrator with proficiency in SQL Server different versions like 2000, 2005, 2008 and 2008R2,Sql 2012(Including 1 (year on site Experience...

About

7+ years of experience as a Database Administrator with proficiency in SQL Server different versions like 2000, 2005, 2008 and 2008R2,Sql 2012

Professional Summary
• + years of experience as a Database Administrator with proficiency in SQL Server different versions like 2000, 2005, 2008 and 2008R2,Sql 2012(Including 1 (year on site Experience ).
• Experienced in managing and monitoring very large databases, production database
• Migration activities like SQL server migration from SQL server 2000 to SQL server 2005 to SQL server 2008.
• Maintaining standard operating procedures for all kinds of databases activities and documenting the same in a repository.
• Designing and managing backup strategies, disaster recovery solutions, log shipping and mirroring for database high availability.
• Experienced in SQL Server 2005/2008 possessing knowledge of Database Mirroring, Snapshots, Log Shipping, replication and clustering.
• Configuring data log files and file groups.
• Responsible for DB refreshing and recycle databases as per client request.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Maintaining the database consistency with DBCC at regular intervals.
• Monitoring SQL server performance using profiler to find performance and dead locking and blocking.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Export or Import data from other data sources like files.
• Expertise in Backup and Restoration of Database.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Installing, configuring and administering SQL Servers with service packs.
• Implemented application and database security policies.
• Involved in trouble shooting of database and application pr