TCS Walkin interview For SQL DBA on 10th July 2011 @ Sunday,Chennai

Job Description:

Position : 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 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)

Desired Profile :

Job Location : Chennai
Experience band : 3 - 9 Years

Interested Candidate can forward their profile to Priyadharshini5.b(at)tcs.com

Please check with the criteria,

Eligibility Criteria :
1. BE/B.Tech/MCA/M.Sc/MS/Diploma with minimum 3 years of experience post Qualification IT- Experience.
2. Bsc Graduates with minimum 3+ years of relevant experience post qualification IT 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.

Documents to be carried for the walk-in
1. Passport size photograph
2. Last 3 Month payslip.
3. Resume
4.CLASS 10 MARK SHEET
5.CLASS 12- MARK SHEET
6.UG MARKSHEETS & DEGREE CERTIFICATES
7.PG MARKSHEETS & DEGREE CERTIFICATES
8.PREVIOUS EXPERIENCE CERTIFICATES or Service Certificate for all the Previous Employment
9.COPY OF RELIEVING LETTER (Current Company if applicable)
10.ADDRESS PROOF (RATION CARD / TELEPHONE BILL / ELECTRICITY BILL)
11.CITIZENSHIP PROOF (PASSPORT / VOTERS ID / RATION CARD / DRIVING LICENCE)
12.COPY OF PAN CARD

Kindly carry printout of confirmation mail.
Interview Date / time : 10th July 2011 (Sunday), 9:30am - 1:00pm

Interview Venue :
Tata Consultancy Services
65/ 1A, Velachery � Taramani 100 Feet Road, Velachery,
Chennai - 600 042,Tamil Nadu

Contact Person : Priyadharshini. B

914466167027