Number of Applicants
:000+
• Strong experience in Database Administration in SQL Server 2008/2008R2/2012/2014/2016/2017/2019
• 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 and always on.
• Should be strong in encryption, Log shipping with encryption, Backup encryption and TDE.
• Experience in implementing operational automation.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
• Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
• Solid acquaintance with windows server, security delegation, SPNs, storage components.
• Documentation skills for processes and procedures ( creating KBs, runbooks etc )
• SQL Database Operational support to tech users
• 24/7 Shift
Share this job with your friends
Copyright © 2024 Grabjobs Pte.Ltd. All Rights Reserved.