Location : Chennai
Skill- SQL Server
Client TCS
Roll: Contract
JD :
- Having 3+ years of IT Experience as MSSQL Server Database Administration.
- Involved in installation and configuration of MS SQL Server 2008R2 and 2012 in windows environment.
- Applying SQL Server patches.
- Verifying and resolving the SQL Server blocking issues and Finding and fixing the root cause.
- Experience in working with production (24 x 7) and development environments.
- Ability to perform all Database Administration (DBA) tasks like performing database backups and recovery, monitoring logs and hard disk consumption growth rate etc.
- Able to configure jobs for routine activities and troubleshooting them in case of failures.
- Monitoring SQL Server, SQL Server Agent Jobs, Job failures, Database and Log growth, CPU, Memory and Disk Utilization using the in-house built SQL Server monitoring tool.
- Creating database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.
- Creating and Administering the SQL Server Databases.
- Hands on experience in creating Database Objects including Tables, Indexes, Views and Stored Procedures.