System Administrator - SQL DBA

Ikya Human Capital Solutions Pvt Ltd
  • Chennai, Noida
  • Confidential
  • 5-10 years
  • Views
  • 16 Dec 2016

  • Project/ Program Management IT

  • IT/ Technology - Data Center/ Manage Infrastructure Services, IT/ Technology - Hardware & Networking
Job Description

Good understanding of MS SQL Architecture, Filegroups, Partitioning, Schemas, Snapshots, C38 Memory 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.

Job Posted By