Things to remember for IT professionals in todays competitive era.
Anyone who is going to shape career in IT must evaluate themselves to fir for the industry demand.
SQL Database Administrator
Strong experience in Database Administration in SQL Server (2008. 2012 & 2012 R2)
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
SQL Development-ability to write and troubleshoot SQL Code and design (stored procedure, functions, tables, views, triggers, indexes, constraints).