Wednesday, September 21, 2011

SQL DBA Walk-in | TCS | Bangalore | 24th September 2011

Interview with BangaloreTCS for SQL DBA on 24th Sep Saturday 
Tata Consultancy Services (TCS) - Chennai, Tamil Nadu 
Dear Candidates,

We have planned to have interviews for SQL DBA(3 to 8yrs of total experience) on 24/09/2011 at TCS Bangalore

Job location : Chennai,

Interview location : Bangalore

Candidates should have hands on experience with:
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)

Keywords:
SQL DBA

Desired Candidate Profile

Please check with the criteria,

Eligibility Criteria 1. BE/B.Tech/MCA/M.Sc/MS with minimum 3 to 8 of total years of Experience.

2. Bsc Graduates with minimum 3.6 to 8 and Diploma with 4 to 8 of 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.

Interview Venue : Hotel Monarch.

#54, Brigade Road,

Bangalore -560 001.

Ph:            080-42507000      ,

Interview Date / time : 24th September 2011, Saturday

9:30am - 1:00pm

Contact Person : Julie.

All the very best for your interview!

Regards,

Julie P

Tata Consultancy Services

Ph:- 914466167426

Mailto: julieana.p@tcs.com

Website: http://www.tcs.com 

No comments:

Post a Comment