Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
Requirements
- SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
- replication issues, log shipping issues, connectivity issues, security issues etc.
- Ability to detect and troubleshoot SQL Server related CPU, memory,I/O, disk space, and other resource contention.
- 3 years of experience as a SQL Server DBA
- experience in database development and support in MS SQL Server environments
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- experience with backups restores and recovery models
- experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues,
- 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 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.