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
