Walkins in Chennai TCS for SQL DBA 18 Sep
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
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:
Discuss This Walkin
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 |


