Microsoft Sql Server Database Administrator

Years of experience : 7-12 years

Job Location : Pune

• 7-12 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