RSSTata Consultancy Services (TCS) SQL DBA Walk-in @ Chennai
About Company
Tata Consultancy Services (TCS) is one of the world’s leading information technology companies. Through its Global Network Delivery Model™, Innovation Network, and Solution Accelerators, TCS focuses on helping global organizations address their business challenges effectively.
TCS continues to invest in new technologies, processes, and people which can help its customers succeed. From generating novel concepts through TCS Innovation Labs and academic alliances, to drawing on the expertise of key partners, it keeps clients operating at the very edge of technological possibility.
Whether TCS is envisioning a business advantage, engineering an IT solution, or executing an outsourcing strategy, it helps its customers experience certainty in their every day business.
TCS reported 2009 -10 global revenues of USD 6.34 billion .
Job Description
Dear Candidates, we are planning to have interviews for SQL DBA on 29/10/2011(Saturday)
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
1. BE/B.Tech/MCA/M.Sc/MS/Diploma with minimum 3 to 8 of total years of experience post Qualification IT- Experience.
2. Bsc Graduates with minimum 3.6 to 8 total years of 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.
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
India
Interview Date / time : 29th Oct 2011, Saturday 9.30am- 1:00pm
Documents to be carried for the interview,
2. Passport size photo
3. A copy of Last month’s pay-slip
4. A copy of this confirmation mail
Contact Person : Julie.
All the very best for your interview!
Regards,
Julie P
Tata Consultancy Services
65/ 1A, Velachery – Taramani 100 Feet Road, Velachery,
Chennai – 600 042,Tamil Nadu
India
Ph:- 914466167426
Mailto:julieana.p@tcs.com
Website: http://www.tcs.com
Tags: Capacity Planning, Performance Tuning, Scheduled Maintenance, TCS