SQL DBA Walkin at TCS Chennai on 18th September 2011

WALK-IN AT TCS CHENNAI FOR SQL DBA ON 18TH SEPTEMBER 2011


Walk-in at TCS Chennai on 18th SEPTEMBER 2011

Walk-in interviews for SQL DBA on 18/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 

  • 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

WALK-IN AT TCS CHENNAI FOR SQL DBA ON 18TH SEPTEMBER 2011

Walk-in at TCS Chennai on 18th SEPTEMBER 2011

Walk-in interviews for SQL DBA on 18/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 

  • 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

Leave a Reply

Your email address will not be published. Required fields are marked *