Tata Consultancy Services (TCS)
SQL Database Administrator
Job Desc:
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 mirrorining logshipping, Database snapsshots and cluster.
Capacity Planning: Anylsis of database growth and recommendations for additional capacity (hardware, memory etc.)
Profile:
Monitoring: Scheduled job monitoring Backup monitoring SQL Server monitoring Replication monitoring
Backup and Recovery: Setting up backups for new databases Recovery of Server Software installation Support
Experience: 3-8 years
Location: Chennai (Madras)