Prathyusha Reddy Email and Phone Number

Installation, Configuration and Administration of SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 and 2022.Working on Standard Database Maintenance tasks, Backups and Recovery Plans.Database Refreshes from Production to Stage and Development environments as per the requirement.Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.Handling creation of new SQL Server databases as per client/application team request.Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.Efficiently manage the relationship with customers and thoroughly document casesCollaborate on cross-team and cross-product technical issues by working with resources from other groups to resolve customer issues. Collaborate with Tech Leads and escalation resources, when appropriateParticipate in case triage meetings to share knowledge with other engineers and develop efficient customer solutionsConsistently share best practices with team members. Act as technical resource for broad and complex issues.Maintain strong working knowledge of pre-release products and take ownership forproduct improvement in key product areasManaging backups on a daily basis and recovery (as per request).

Installing, configuring, managing, monitoring and troubleshooting SQL Server.Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.Configured Mirroring, Replication, Log-shipping and Clustering setup betweendatabase servers/instances.Monitoring Clusters and troubleshooting Clustering Issues, performing failovers.Troubleshooting performance issues and tuning the database for betterperformance.Running SQL Server trace to troubleshoot the data issues reported by users.Monitoring issues related to database locks/blockings/deadlocks.Configuring SQL Server Reporting Server, Database Mails to send notification foralerts.Resolving Tickets which include creating and maintaining databases, monitoringDisk Space, database integrity,Migrate application content from an old server to a new server with betterhardware to improve performance.Migrating servers from SQL 2012 to 2014, 2017 and 2019.Resolving technical Database issues and supporting 24/7 to resolve incidents from vendors and handling on-call on Weekly basis and involved in monthly maintenance activities.

Supported L1 activates Like Monitor the Queue, assigning the task and mail supportEngaged in SQL Patching and disaster recovery measures.Installation and maintenance of SQL 2019,2017,2016,2014,2012 and 2008R2.Refreshing UAT environment with Production data monthly.Backup and restoring the databases from production to test environment.Provided 24/7 Production support for the database and application issues.Administration of SQL server by creating user logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.