Setting up new SQL Servers 2005 and 2008, 2012 and configuring the required users. Restoring and copying Production Databases. Creating the User, giving the proper permissions to the users. Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis. SQL Server Administration, service start, pause, stop, failover. Resolving various performance issues and running DBCC commands, SQL Profiler and monitoringtools. Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution. Running Index tuning wizard, implementing Log Shipping.

Setting up new SQL Servers 2005 and 2008, 2012 and configuring the required users. Restoring and copying Production Databases. Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis. SQL Server Administration, service start, pause, stop, failover. Resolving various performance issues and running DBCC commands, SQL Profiler and monitoringtools. Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution. Running Index tuning wizard, implementing Log Shipping.

 MySQL Installation & Configuring MySQL. Implementing Scheduled Backups with the shell scripts. Restoring and Recovery Management when tables / Database Crashes. Working on the table optimisations like Optimize, Analyse and Check. Setup Replication of MASTER – SLAVE and Monitor the Replication. Upgrading the MySQL to Newer Versions as per the requirements. Good knowledge of working with third party Backup tools such as Percona Xtrabackup and Zamanda Recovery Manager. Creating Users & Giving the permissions of databases as per the requirements to the client. Performing the switch over optimisations and creating indexes as per the requirement.

 Setting up new SQL Servers 2000 and 2005 and configuring the required users.  Restoring and copying Production Databases.  Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.  SQL Server Administration, service start, pause, stop, failover. Resolving various performance issues and running DBCC commands, SQL Profiler and monitoringtools.  Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.  Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.  Running Index tuning wizard, implementing Log Shipping.