JD :
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
