Experience required for the Job: 3 - 8 years
Annual Salary of the Job: 3.80 - 11.85 Lacs
Job Location: Chennai
Dear Candidate,
Dear Candidates,
Greetings from TCS!
We are planning to have interview for SQL DBA L2 (3 - 8yrs) @ Chennai & Hyderabad on 17th July 2011 Sunday
Description:
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)
For further more details ,kindly find the below details :
Job Location : Chennai
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 Venue for Chennai:
Tata Consultancy Services
65/ 1A, Velachery â€" Taramani 100 Feet Road, Velachery,
Chennai - 600 042,Tamil Nadu
Interview Venue for Hyderabad:
Tata Consultancy Services
Kohinoor Park,
Plot No.1, Jubilee Gardens,
Cyberabad,
Hyderabad 500 081
Interview Date / time : 25thth June 2011 ( Saturday)
9:30am - 1:00pm
Contact Person :priyadharshini. B
All the very best for your interview!
Thanks & Regards,
Priyadharshini.B
Tata Consultancy Services
65/ 1A, Velachery â€" Taramani 100 Feet Road, Velachery,
Chennai - 600 042,Tamil Nadu
India
Ph:- 914466167027
Mailto:
priyadharshini5.b@tcs.com Website:
http://www.tcs.com