Interview with TCS Chennai for SQL DBA on 9/10/2011(Sunday)
Tata Consultancy Services (TCS)
3 - 8 Years
Location:
Chennai
Education:
UG - Any Graduate - Any Specialization,Graduation Not RequiredPG - Any PG Course - Any Specialization,Post Graduation Not Required
Industry Type:
IT-Software/ Software Services
Role:
System Admin
Functional Area:
Systems, EDP, MIS
Posted Date:
03 Oct
Job Description
Greetings from TCS!!!
We have immediate opening for SQL Database Administrator.
Experience: 3 - 8 yrs
Interview Location: Chennai
Job Location: Chennai
Job 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)
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)
Interview Date:9th October 2011(Sunday)
Interview Time: 9.30 am - 1.00 pm
Interview Time: 9.30 am - 1.00 pm
Contact Person: Julie
Interested candidate please find the below venue:.
Tata Consultancy Services
165/ 1A, Velachery – Taramani 100 Feet Road,
Velachery,
Chennai 600042
165/ 1A, Velachery – Taramani 100 Feet Road,
Velachery,
Chennai 600042
Regards,
Julie
Julie
Tata Consultancy Services
165/1A, Velachery – Taramani 100 Feet Road, Velachery,
Chennai - 600 042
Contact No:04466167426
Website: http://www.tcs.com
165/1A, Velachery – Taramani 100 Feet Road, Velachery,
Chennai - 600 042
Contact No:04466167426
Website: http://www.tcs.com
No comments:
Post a Comment