Responsible for the installation, configuration, maintenance and administer SQL SERVER.
Monitoring, optimizing and analyzing systems performance and setting user privileges with the database environment.
Setup and troubleshoot Replication and Log Shipping.
Performing Database activities like maintenance, performance monitoring and tuning, troubleshooting
Performing routine DBA tasks like backup, restore, system health check etc.
Proactive monitoring Disk space, data and log space.
Support and managing disaster recovery solution like Replication, Log Shipping and AlwaysOn etc.
Using development tools like Data Transformation Services (DTS)/ SQL Server Integration Service (SSIS)
Using SQL Server Reporting Services
Scheduling & monitoring Jobs and Alerts using SQL Server Agent.
Planning and Preparing Backup/Recovery plan like Full backup, Differential backup and Transaction log for point in time recovery.