Walk-in at TCS Chennai for SQL DBA on 18th SEPTEMBER 2011

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

• BE/B.Tech/MCA/M.Sc/MS/Diploma with minimum 3 to 8 of total years of experience post Qualification IT- Experience.
• Bsc Graduates with minimum 3.6 to 8 total years of experience.
• Only Full Time courses would be considered.
• Not more than 4 years break in Career / Academics or Non - IT Experience.
• 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


Interview Date / time : 18th 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.
Tata Consultancy Services
65/ 1A, Velachery – Taramani 100 Feet Road, Velachery,
Chennai - 600 042,Tamil Nadu

Ph:- 914466167426
Mailto: julieana.p@tcs.com