Interview @ tcs velachery for SQL DBA on 26/04/2011
Experience:3 - 8 Years
Location:Chennai
Education:UG - Any Graduate - Any Specialization,Graduation Not Required
PG - Any PG Course - Any Specialization,Post Graduation Not Required
Industry Type:IT-Hardware & Networking
Role:System Admin
Functional Area:IT-Other
Desired Candidate Profile
Kindly carry the following Documents for the interview:
Resume.
Three months payslip.
Two passport size photo.
Print out of confirmation mail copy.
Eligibility Criteria:
BE/B.Tech/MCA/M.Sc/MS with minimum
3 years of relevant experience post Qualification IT- Experience.
Bsc Graduates with minimum 4+ years of relevant experience post qualification IT Experience.
Only Full Time courses would be considered.
Consistent academic records Class X onwards
Not more than 4 years break in Career / Academics or Non - IT Experience.
Venue:
Tata Consultancy Services
165 / 1A, 2& 4 Velachery
Taramani 100 Feet Road, Velachery
Chennai - 600 042.
Job location : Chennai
Thanks & Regards,
Priyadharshini B.
Job Description
SQL DBA
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)
Keywords : Hands on experience
Experience:3 - 8 Years
Location:Chennai
Education:UG - Any Graduate - Any Specialization,Graduation Not Required
PG - Any PG Course - Any Specialization,Post Graduation Not Required
Industry Type:IT-Hardware & Networking
Role:System Admin
Functional Area:IT-Other
Desired Candidate Profile
Kindly carry the following Documents for the interview:
Resume.
Three months payslip.
Two passport size photo.
Print out of confirmation mail copy.
Eligibility Criteria:
BE/B.Tech/MCA/M.Sc/MS with minimum
3 years of relevant experience post Qualification IT- Experience.
Bsc Graduates with minimum 4+ years of relevant experience post qualification IT Experience.
Only Full Time courses would be considered.
Consistent academic records Class X onwards
Not more than 4 years break in Career / Academics or Non - IT Experience.
Venue:
Tata Consultancy Services
165 / 1A, 2& 4 Velachery
Taramani 100 Feet Road, Velachery
Chennai - 600 042.
Job location : Chennai
Thanks & Regards,
Priyadharshini B.
Job Description
SQL DBA
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)
Keywords : Hands on experience
2 comments:
Hi, How can I avail this opportunity..! Please send to my email id any information the process of selection and please guide me through.
hi if u have recuriment for dotnet please send information to my email id...dis is my mail id m.megalai266@gmail.com
Post a Comment