- Planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.
- Performing day to day Database Maintenance tasks such as Database Monitoring, Backups, Space Management, Resource Utilization for MSSQL,Oracle and PostgreSQL.
- SQL Server Database Maintenance, design a backup strategy to fit available budget, Cluster State Management.
- Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.
Setting up Replication, Mirroring and Log shipping on SQL Server,AlwaysOn.