• Served as a Database Administrator• Handled database backup/recovery and troubleshooting of jobs­ Creating maintenance plans and troubleshooting SQL Server Agent scheduled jobs such as backup, integrity, optimization, and log shipping jobs regularly­ Working on backup and restore by using UI, SQL Server agent, transaction log shipping, and configuring alerts­ Ensuring back-up procedures executed without failure­ Monitoring scheduled jobs• Responsible for database… Show more • Served as a Database Administrator• Handled database backup/recovery and troubleshooting of jobs­ Creating maintenance plans and troubleshooting SQL Server Agent scheduled jobs such as backup, integrity, optimization, and log shipping jobs regularly­ Working on backup and restore by using UI, SQL Server agent, transaction log shipping, and configuring alerts­ Ensuring back-up procedures executed without failure­ Monitoring scheduled jobs• Responsible for database optimization, maintenance, space utilization, and tracing­ Indexing and performance tuning with the help of tuning advisor­ Creating the clustered and non-clustered indexes identifying the missing index­ Tracing all transactions on server, using SQL Profiler­ Handling execution plan • Worked on installation and configuration of SQL Server­ Installing, managing, monitoring, and troubleshooting of MS SQL Server 2000/ 2005/ 2008/ 2008R2/ 2012/ 2014/2016/2017­ Creating logins to the users and giving permissions­ Installing SQL Server software and related products• Implemented database mails, and SQL logins­ Creating operators and profiles­ Assigning roles for the requested users• Migrated objects and servers­ Migrated database objects including all jobs, login, databases, and SSIS packages• Monitored and troubleshot escalated issues­ Monitoring slow running queries and performing the index rebuild as well as reorganizing operation depending on the table fragmentation value­ Monitoring the Windows event logs for finding the error related SQL Server services­ Performing and monitoring the transnational backups through jobs­ Performing the database health check activities using DBCC Checkdb­ Monitoring the instant base solution such as OS, SQL Server, memory related bottle neck issue thru sys.sysperfinfo table­ Identifying and troubleshooting the problem for slow running queries through SQL Profiler after client approval­ Maintaining the incident dairy in the incident management system Show less

.Installation, Configuration, Error handling, Troubleshooting and Optimizing SQL Database Servers.• Event Monitoring, Incident and Request Handling.• Served as a Database Administrator• Worked on the code reviews and object level optimization­ Sharing the best optimizations plans on legacy server for all the code deployed on production­ Creating file groups, partioning, and compression ­ Monitoring the dead locks through sp_who2 procedure and sysprocesses table… Show more .Installation, Configuration, Error handling, Troubleshooting and Optimizing SQL Database Servers.• Event Monitoring, Incident and Request Handling.• Served as a Database Administrator• Worked on the code reviews and object level optimization­ Sharing the best optimizations plans on legacy server for all the code deployed on production­ Creating file groups, partioning, and compression ­ Monitoring the dead locks through sp_who2 procedure and sysprocesses table • Handled database backup/recovery and troubleshooting of jobs­ Creating maintenance plans and troubleshooting SQL Server Agent scheduled jobs such as backup, integrity, optimization, and log shipping jobs regularly­ Working on backup and restore by using UI, SQL Server agent, transaction log shipping, and configuring alerts­ Ensuring back-up procedures executed without failure­ Monitoring scheduled jobs Show less

Code reviews and object level optimization* Shares the best optimizations plans on legacy server for all the code deployed on production* Creating file groups, partioning ,compression * Database optimization, maintenance, Space utilization and Tracing.* Indexing and performance tuning with the help of Tuning Advisor.* Creating the clustered and non-clustered indexes identifying the missing index.• Worked on installation and configuration of SQL Server­ Installing… Show more Code reviews and object level optimization* Shares the best optimizations plans on legacy server for all the code deployed on production* Creating file groups, partioning ,compression * Database optimization, maintenance, Space utilization and Tracing.* Indexing and performance tuning with the help of Tuning Advisor.* Creating the clustered and non-clustered indexes identifying the missing index.• Worked on installation and configuration of SQL Server­ Installing, managing, monitoring, and troubleshooting of MS SQL Server 2000/ 2005/ 2008/ 2008R2/ 2012/ 2014­ Creating logins to the users and giving permissions­ Installing SQL Server software and related products• Implemented database mails, and SQL logins­ Creating operators and profiles­ Assigning roles for the requested users• Migrated objects and servers­ Migrated database objects including all jobs, login, databases, and SSIS packages• Monitored and troubleshot escalated issues­ Monitoring slow running queries and performing the index rebuild as well as reorganizing operation depending on the table fragmentation value­ Monitoring the Windows event logs for finding the error related SQL Server services­ Performing and monitoring the transnational backups through jobs­ Performing the database health check activities using DBCC Checkdb­ Monitoring the instant base solution such as OS, SQL Server, memory related bottle neck issue thru sys.sysperfinfo table­ Identifying and troubleshooting the problem for slow running queries through SQL Profiler after client approval­ Maintaining the incident dairy in the incident management system Show less

Indus towers:-Data entry operatorTo do data entry.support and manage the application.Requirement gathering and help others in order to do analysis.genpact project :-Junior DBAHaving Experience in Microsoft SQLServer Database Administrator on SQL Server 2008R2,2008, 2005, 2000. Experienced in Installing 2008R2/2008/2005/2000, Upgrading and Configuring Microsoft SQL Server. Proficient in Database Backup, Recovery and Disaster Recovery procedures. Manage the SQL… Show more Indus towers:-Data entry operatorTo do data entry.support and manage the application.Requirement gathering and help others in order to do analysis.genpact project :-Junior DBAHaving Experience in Microsoft SQLServer Database Administrator on SQL Server 2008R2,2008, 2005, 2000. Experienced in Installing 2008R2/2008/2005/2000, Upgrading and Configuring Microsoft SQL Server. Proficient in Database Backup, Recovery and Disaster Recovery procedures. Manage the SQL Server user accounts by, Creating logins, database users and assigning roles by using Security Privileges. Creating and maintaining maintenance plans for the databases. SQL Server jobs scheduling and Monitoring jobs on a daily basis. Provide 24x7 DBA production support, work with DBA team for production on call support rotation. Resolve Database related trouble tickets assigned to the DBA group. Show less