ASHOK KUMAR SRIGIRI

Installation and configuration of MS SQL Server 2008, 2008 R2, and 2012.

Resolving tickets, which include creating and maintaining databases, monitoring disk space, ensuring database integrity, identifying missing indexes, and handling blocking.

Implement and maintain database security as per business rules and requirements.

Implemented database mirroring with synchronous mode.

Maintained and monitored alert/schedule to ensure a smooth replication process.

Updating service packs and security patches for the servers.

Creating and reviewing security features for all the servers.

Configuring and monitoring the transactional replication.

Troubleshooting blocking, space issues.

Ensuring data consistency in the database through DBCC commands.

Installation and configuration of Always On, and performing the DR activities.

Installation of an active-passive cluster and performing the failover activities.

Installing and maintaining Always On availability groups.

Deploying the packages to MSDB or the file system.

Implemented database mirroring with synchronous mode.

Maintained and monitored alert/schedule to ensure a smooth replication process.

Updating service packs and security patches for the servers.

Creating and reviewing security features for all the servers.

Configuring and monitoring the transactional replication.

Troubleshooting blocking, space issues.

Organization: Scalability Engineers.

Client: Core Card and Goldman Sachs.

Role: SQL Server DBA.

Implemented database mirroring with synchronous mode.

Maintained and monitored alert/schedule to ensure a smooth replication process.

Updating service packs and security patches for the servers.

Creating and reviewing security features for all the servers.

Configuring and monitoring the transactional replication.

Troubleshooting blocking, space issues.

Ensuring data consistency in the database through DBCC commands.

Installation and configuration of Always On, and performing the DR activities.

Project Name: HEC ECS (Managed Cloud)

Client: SAP Labs.

Role: SQL DBA (Associate Consultant)

Creation of user databases and ensuring file group creations as per requirements.

Create various database objects, and create users with fixed roles and levels of security.

Schedule and maintain routine jobs, alerts, and maintenance plans.

Checking the status of the backup, troubleshooting failed backups, and restoration of databases.

Managing backups on a daily basis, restoring and implementing disaster recovery procedures, and recovering the databases from backup in disaster situations.

Verifying that all instances are up and running, as per the checklist.

Maintained and developed failover databases using database mirroring.

Have an understanding of the clustering environment and monitoring through the cluster administrator.

Performing the failover and failback operations in the cluster environment.

Monitoring SQL performance using a profiler to find performance issues and deadlocks.

Performing a daily health check of SQL Server and preparing a report based on it.

Monitoring the disk space of all the servers and freeing up space for cleanup.

Reviewing SQL Server and SQL Server Agent error logs.

Moving database files from the source to the destination place.