Job Overview

years of experience: 7-12 years

job location: mumbai

• 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