Walk-In @ "TCS" : SQL DBA : Bangalore : On 24 Jul 2011

Experienced Walk-In : SQL DBA @ Bangalore

TCS Eligibility Criteria :

• BE/B.Tech/MCA/M.Sc/MS/Diploma with minimum 3 years of experience post Qualification IT- Experience.

• BSc Graduates with minimum 3+ years of relevant experience post qualification IT 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.

• Kindly register yourself in www.careers.tcs.com and generate EP (Employee) Number as its mandatory.

Job Position : SQL DBA

Interview Location : Bangalore, Karnataka

Desired Experience : 3+ Years (Mandatory)

Mandatory Skills : SQL Admin

Job Description :

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.)

Note: You can mention the reference as 'ChetanaS'.

Walk-In Date : On 24th July 2011 (Sunday) : 9.30 AM to 1.00 PM

Walk-In Venue :
Tata Consultancy Services,
SJM Towers, 18, Sheshadri Road,
Gandhinagar,
Bangalore - 560 009

Contact Person : Priyadharshini.B

Documents to be carried for the walk-in :

• A copy of resume

• Passport size photo

• Last 3 months payslips

• A printout of this ChetanaS job posting

• Class 10th & 12th marksheets

• UG & PG marksheets & degree certificates

• Previous Experience Certificates or Service Certificate for all the previous employment

• Copy of Relieving letter (Current Company if applicable)

• Address Proof (Ration Card / Telephone Bill / Electricity Bill)

• Citizenship Proof (Passport / Voters Id / Ration Card / Driving Licence)

• Copy of PAN Card

The following are to be mentioned on the CV and the application form that you fill on the day of the interview :

• EP (Employee Number)

• Source: Priyadharshini Balakrishnan

http://www.ChetanaS.org

Note: To help us expedite the process, kindly register at our Career Portal, create a profile and provide us with your registration number and a copy of your completed application form along with the other documents at the time of interview.

Note: Registered candidates will be given priority for the interview.

..................................................

Procedure to Register Online :

Important :

Request candidate to kindly register yourself in http://careers.tcs.com => Experienced Professionals => Create Your Profile (For New Users) - Login for faster processing of your candidature.

Candidates walking in with printed copy of TCS Application form can avail the fast track channel at the interview venue.

Kindly register yourself in www.careers.tcs.com and generate EP Number (Employee Number - EP2010CN...) as its mandatory.

Kindly carry the following documents for the interview :

• Printed Copy of TCS Application Form, Updated Resume with the TCS Employee Number (EP2010CN...) written on it, Payslip and two passport size Photographs.

• Kindly fill the online application form (Login id and Password is sent to you from TCS Email Id) and carry a copy of the online application form (www.careers.tcs.com => Login page)