We are looking for a person who:
Has 3+ years of experience in database development and support in MS SQL Server environments.
SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
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.
Strong experience in TSQL code
Knowledge in Database Administration in SQL Server
Knowledge to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
Knowledge in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Knowledge in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Experience on backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and Always on setup
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, PerfMon, DMVs, system sprocs)
Documentation skills for processes and procedures
SQL Database Operational support to tech users
Knowledge of scripting language like Powershell, batch scripts
Job Location :- Bangalore
30 freelancers are bidding on average ₹28425 for this job