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