Role Microsoft SQL Server Database Administrator – L2Required Technical Skill Set Microsoft SQL Server 2000, 2005, 2008 R2 & 2012 AdministrationDesired Experience Range 6-8 yearsLocation : Pune, ChennaiNotice Period : 0-45 Days candidates OnlyVirtual Drive Date : 03-Oct-25
Desired Competencies (Technical / Behavioral Competency)
Must-Have
- 3 - 6 years of experience in Microsoft SQL Server Database Administration. Associate should have L2 capabilities in different Versions of Microsoft SQL Servers.
- Installation of database software
- Database Builds
- Incident Management
- Change Management
- Problem Management
- Database maintenance ( Index re- build, table re-org )
- User Access Management
- Database startup / shutdown
- DBCC checks
- Database re-org activities
- Altering database / T-log files
- Analyzing the database blocking
- Analyzing session wait events
- Perform database backup / restores
- Migrating the database objects from Dev / QA to Production
- Database refresh / cloning
- Database upgrades
- Database patching
- Knowledge Management - Creation of SOPs for regular activities, KEDB
- Knowledge on SOX / PCI Compliance reporting
- DR Drill support
- SQL Native Tools, SQL Lite Speed