Minimum 5+ years of experience in database development and support in MS SQL Server
Page 1/ 2
EMAAR RETAIL JOB DESCRIPTION
Strong experience in Database Administration in SQL Server ( 2005 and 2008 and 2012)
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.
Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other
Strong knowledge of backups, restoration, recovery models, database shrink operations,
DBCC commands, Clustering, Database mirroring, Replication.
Expert experience in implementing operational automation.
Strong knowledge of indexes, index management, integrity checks, configuration, patching.
How statistics work, how indexes are stored, how they can be created and managed
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM,SSRS,SSIS) and crystal
SQL Development – ability to write and troubleshoot SQL Code and design (stored
procedures, functions, tables, views, triggers, indexes, constraints )
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Kindly reach us to firstname.lastname@example.org