Operational Agility
• Design databases Backup and Restoration Strategy
• From time to time recover the database to a specific point of time, as per the requests
• Setup High-Availability as part Disaster Recovery Strategy for the Databases
Database Maintenance
• Resolve current and upcoming issues on database
• Create users and assign permissions based on the level of database access the user would need.
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc.
• Once created the database Backups, monitor those backups are being performed regularly
• Troubleshoot various problems that arise day-to-day and work the issues.
? Monitoring and Performance Tuning
? Physical Server Level
? Database level(Database settings and options) and query tuning. (Creating and maintain those indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.
• Documenting major changes to the SQL servers.
• Apply service packs.
• Incident management on Service Now.