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