Vignesh R

Databases : SQL SERVER
1. Setting up new MS SQL Server instances and databases.
2. Maintaining a database server and configuring databases.
3. Managing logins, roles, assigning rights and permissions.
4. Planning, implementing all types of Backup and Restore Operations.
5. Moving Database from one Server to another.
6. Setting up security polices and creating appropriate logins, roles and application roles.
7. Knowledge on up gradation of Database from SQL Server lower to higher version.
8. Manage SQL Server Agent alerts, Agent jobs and Agent operators.
9. Create, Manage and design a log files.
10. Administrating high availability solutions like Log shipping, Mirroring, and Replication.
11. Performing Maintenance tasks like rebuilding, reorganizing indexes, update statistics and checking database integrity at regular intervals.
12. Knowledge on BCP for bulk data uploading.
13. Setting up MSSQL Mail service.
14. Monitoring the database server performance.

Windows server:
1.Installing servers like 2003, 2008(All editions).
2.Setting up Active directory.
3.Knowledge on Domain Controller and Additional Domain Controller.
4.Creating user account and Mail box.
5.Knowledge Organization unit and applying Group policy.
6.Creating FTP and giving access to specific username.

Firewall:
1.Configuring NAT policy.
2.Creating User based policy in the firewall.
3.Backup the firewall settings and restoring the firewall settings.
4.Creating a new content filter policy.
5.Allowing / disallowing particular port in the firewall.

Operating systems, Applications Installing and Troubleshooting :

1.Installing and maintaining visual studio 2010, 2008, 2005, and 2003.
2.Installing and Maintaining SQL Server 2012, 2008, 2005.
3.Installing all windows family (servers and clients), Linux, Cent OS.
4.Configuring IIS (internet information service) in windows Environment.
5.Configuring Wamp server in windows environment.
6.Setting up VPN connections.
7.Troubleshooting with all kind of basic software.

Configuring Mails and Troubleshooting :
1.Configuring outlook express and outlook 2007 and 2010.
2.Creating rule depends upon the needs.
3.Backup the pst file and mapping pst file to an account.
4.Setting password to pst file.