Walkins in Chennai TCS for SQL DBA 18 Sep

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:

Desired Profile 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

Experience 3 - 7 Years
Industry Type IT-Software/ Software Services
Role System Admin
Functional Area System Programming
Education UG - Any Graduate - Any Specialization,Graduation Not Required
PG - Any PG Course - Any Specialization,Post Graduation Not Required
Location Chennai
Keywords Hands on experience
Contact Jasvinder Arora
Tata Consultancy Services
165 / 1A, 2& 4 Velachery Taramani 100 Feet Road
Velachery
CHENNAI,Tamilnadu,India 600042
Website http://twww.tcs.com

- Bookmark / Print or Share this Walkin with your Friends

Would you like to receive Instant alerts in your Mobile / Email when new walkin details posted on Jumbowalkin.com?
Email Alerts: Subscribe to FREE Email Alerts from Jumbowalkin.com!
SMS Alerts: Gmail Users - Click here, Non Gmail Users - SMS 'ON JumboWalkin' to 9870807070

Possibly Related Walk-in Interviews:

» Walkin Multiple Technical position - Chennai » Walk-in for Mainframe on 4-Jun-11(Saturday) - Ch » Walk-in for Coolgen Mainframe on 4-Jun-11 Saturday » Walk-in for Mainframe IMS DB on 4-Jun-11(Saturday) » Walk -in - Sharepoint in Chennai - June 4th 2011

Discuss This Walkin

Name

Mail (will not be published)

Website

View All Walk-in By Skills / City / Company:

Walkin by Skill	Walkin by City	Walkin by Company
Freshers JAVA / J2EE .NET C / C++ / VC++ Database Embedded Systems HR Mainframes Networking OS SAP Testing PHP / MySQL BPO Non-IT	Bangalore Chandigarh Chennai Cochin Coimbatore Delhi Gurgaon Kolkata Mumbai Noida Pune	CSC India CTS HCL Honeywell I-Flex iSOFT KPIT LnT Patni Satyam TCS TechMahindra WIPRO Yahoo