Skills required: Job Description:
Database design and implementation.Installation, configuration and upgrading of Microsoft SQL Server software and related products.
Database tuning and performance monitoring.
Troubleshooting and resolving database integrity, performance, blocking and deadlocking, log shipping, clustering, connectivity, security etc. related issues.
Establish and maintain backups, restores, recovery models, database shrink operations, DBCC commands, Security policies and procedures, index management, and statistics.
Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. ( Profiler, SSMS, DTA, PerfMon, DMVs)
Implement and maintain database security (create and maintain users and roles, assign privileges).
Implement High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Setup and maintain documentation and standards.
Plan growth and changes (capacity planning).