Company Name : TCS
Skills Required : SQL DBA
Experience Required : 3 - 7 Year(s)
Job Location : Chennai
Walkin Date : 18 September 2010
Walkin Time : 09:00 a.m - 07:00 p.m
Job Description : Monitoring:

Scheduled job monitoring

Backup monitoring

SQL Server monitoring

Replication monitoring

Backup and Recovery:

Setting up backups for new databases

Recovery of databases from backups

Install and upgrades:

SQL Server Software Installation Support

SQL Service pack and patches Update

Database creation and file group allocation

Linked Server Creation and issues

Sql Server upgradation.

Performance Tuning:

Trace Analysis

Query Optimization and Query Execution plan Analysis

Database parameters tuning

Security:

SQL Login, database user creation and granting access

Schema creation and granting access

Managing user privileges

Scheduled Maintenance:

Re-Indexing

Update Statistics

Shrink Database

Removal of trace files/old log files

Miscellaneous:

Addressing database space issues

Incident management and Change Management

Database shutdown / restart for any scheduled maintenance tasks not related to database (like OS/SAN maintenance activities)

Permanent fixes for repetitive problems

Non-Production environment refreshes(backup/restore)

Troubleshooting space issues like transaction log full,data file full,clearing the drive space

Troubleshooting deadlock and blocking issues.

Database mirroring, Log shipping, Database snapshots and clusters.

Capacity Planning:

Desired Profile SQL DBA Monitoring: Scheduled job monitoring Backup monitoring SQL Server monitoring Replication monitoring Backup and Recovery: Setting up backups for new databases Recovery of databases from backups Install and upgrades: SQL Server Software Installation Support SQL Service pack and patches Update Database creation and file group allocation Linked Server Creation and issues Sql Server upgradation. Performance Tuning: Trace Analysis Query Optimization and Query Execution plan Analysis Database parameters tuning Security: SQL Login, database user creation and granting access Schema creation and granting access Managing user privileges Scheduled Maintenance: Re-Indexing Update Statistics Shrink Database Removal of trace files/old log files Miscellaneous: Addressing database space issues Incident management and Change Management Database shutdown / restart for any scheduled maintenance tasks not related to

Walkin Venue :

Jasvinder Arora
Tata Consultancy Services
165 / 1A, 2& 4 Velachery Taramani 100 Feet Road
Velachery
CHENNAI,Tamilnadu,India 600042