SQL Server DBA with ( 4 to 6) years experience.
Installation, Administration and Maintenance of SQL Server Instances.
• Setup Test, Dev, Staging and Production Environments.
• 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.
• Design database Backup and Restoration Strategy.
• Once created the database Backups, monitor those backups are being performed regularly.
• From time to time recover the databases to a specific point of time, as per the requests.
• Setup High-Availability as part Disaster Recovery Strategy for the Databases.
• Troubleshoot various problems that arise in a day-to-day work and fix the issues.
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning
(Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.)
• Apply Service Packs.
• ITIL/SQL Server Certifications
