Ikya Human Capital Solutions Pvt Ltd
  • Chennai, Noida
  • 10-15 lakh
  • 4-9 years
  • Views
  • 15 Sep 2016

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

Good understanding of MS SQL Architecture,Filegroups, Partitioning, Schemas, Snapshots, C38Memory etc.
- Installation and Configuration of SQL Server Pre-requisites.
- SQL Server Datbase Basic Administration and Latest Features.
- SQL Server user account management
- Test and Apply Patches and Service Packs
- Migrate Databases.
- Database Resource Management and Task Scheduling.
- Capacity Planing in terms of Growth of Database.
- Experience in basic Performance Tuning and Monitoring.
- Availibility Management for Databases.
- Handling of daily issues ( Blockings, Long running transaction, Deadlocks etc)
- Good understanding of Transact SQL.
- Automating SQL Server tasks (SQL Jobs, Windows scripts, etc.)
- Troubleshoot issues related to TempDb ,Transaction Log and System Databases
- Instance / Database monitoring/ C39 configuring DB Mail/ SQL Mail and Alerts & Operators
- Good knowledge of Index Management & Statistics
- Basic Knowledge of SSIS, SSRS.
- Knowledge and troubleshooting Issues related to HA (Replication, Logshipping, Mirroring, Clustering)
- Scheduling Database Backups, taking Full and Transaction Log Backups.
- Implementing SQL Server Database Security Policy,Auditing

Competencies/Skill sets for this job

Dba Sql Server Server Database Security Transaction Sql

Job Posted By