MSSQL DBA L3 Professional

Job Description

Job Description:

At least SQL DBA experience, 6+ years required
Thorough Knowledge of Windows Operating System, Networks and Active Directory
. Knowledge of creating and maintaining standby / replication setup
. Strong in SQL fundamentals
. Knowledge of using Enterprise Manager and Query Analyzed for basic administration
. Knowledge of configuring and setting up maintenance activities for DB
. Knowledge of SQL statements tuning and DB Tuning
. Knowledge on DB structures (filegroups, Indexes - clustered /non clustered/fillfactor)
. Knowledge on Memory structures (configurable parameters)
Knowledge of complete /differential / transactional backups and their recovery scenarios
. Knowledge on High Availability configuration like replication and log shipping , cluster setup
. Knowledge of DTS and bcp and other data load tools across same and different RDBMS
Knowledge on database design and storage recommendation and NTFS file systems & capacity planning
. Knowledge in making scripts for automations , writing procedures and functions
. Knowledge of ITIL processes & Transition Management
. Excellent communication Skills
Prior experience in a 24x7 environment desired
Strong analytical and troubleshooting skills.
Provide on-call support as and when required