|
Setup 'Security Strategy', 'Maintenance Plans', 'Backup Policy', 'Resource & Capacity Planning' for Client data center. Perform day to day database activity like daily backup, recovery, performance tuning, consistency checks for Servers, monitor the health of each database and success of each backup. Create Procedures and Triggers and keep each system tuned for optimum performance.
Set-up and manage Users for SQL Server, manage security for new user and existing users, maintain logins, role management/permissions for users.
Import and Export Data, manage the replication environment and troubleshoot any SQL Server problems and restore the database when necessary.
|
