Tuesday, September 6, 2011

Interview with TCS for SQL DBA on 11/09/2011 (Sunday) | Chennai


TATA Consultancy Services Ltd Walk-in for SQL DBA @ Chennai on 11-Sep-2011

Dear Candidates, we are planning to have interviews for SQL DBA on 11/09/2011(Sunday)

Job location : Chennai,

Interview location : Chennai.

Candidates should have hands on experience with:
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:
Analysis of database growth and recommendations for additional capacity (hardware, memory etc)

Eligibility Criteria

1. BE/B.Tech/MCA/M.Sc/MS/Diploma with minimum 3 to 8 of total years of experience post Qualification IT- Experience.

2. Bsc Graduates with minimum 3.6 to 8 total years of experience.

3. Only Full Time courses would be considered.

4. Not more than 4 years break in Career / Academics or Non - IT Experience.

5. Candidate who have attended TCS interview in the last 6 months need not apply.

Interested and Eligible Candidates please find the venue details:

TATA Consultancy Services,

65/ 1A, Velachery – Taramani 100 Feet Road, Velachery,

Chennai - 600 042,Tamil Nadu

India

Interview Date / time : 11th Sept 2011, Sunday 9.30am- 1:00pm 


Documents to be carried for the interview,

1.

A copy of resume

2. Passport size photo

3. A copy of Last month's pay-slip

4. A copy of this confirmation mail

5. A copy of all academic mark sheet

6. A copy of all previous relieving letters

Contact Person : Julie.

All the very best for your interview!

Regards,

Julie P

Tata Consultancy Services

65/ 1A, Velachery – Taramani 100 Feet Road, Velachery,

Chennai - 600 042,Tamil Nadu

India

Ph:- 914466167426

Mailto:julieana.p@tcs.com

Website: http://www.tcs.com 

No comments:

Post a Comment