Sai Mahesh Bhagavatula

• Conducted regular performance reviews, identifying areas for improvement and developing action plans to address them.
• Supervised operations staff and kept employees compliant with company policies and procedures.
• Led hiring, onboarding and training of new hires to fulfill business requirements.
• Developed and implemented strategies to maximize customer satisfaction.
• Empowered employees to take ownership of their responsibilities, leading to increased accountability and improved performance outcomes.
• Facilitated smooth collaboration between departments through clear communication channels.
• Increased profit by streamlining operations.
• Handled staff training initiatives aimed at up skilling the workforce to meet dynamic industry demands.
• Enhanced customer satisfaction by establishing clear communication channels and addressing concerns promptly.
• Analyzed and reported on key performance metrics to senior management.
• Analyzed data trends to identify potential bottlenecks in operations workflow, implementing strategies to mitigate risks accordingly.
• Achieved higher employee retention rates by fostering a positive work environment and providing opportunities for professional growth.
• Handled problematic customers and clients to assist lower-level employees and maintain excellent customer service.
• Scheduled employees for shifts, taking into account customer traffic and employee strengths.
• Observed each employee's individual strengths and initiated mentoring program to improve areas of weakness.

• Monitor the Windows azure capacity management (Azure Capacity Infrastructure Support) day to day activities.
• Creation of Virtual Machines using Portal, PowerShell, CLI and ARM Templates
• Preparing custom images and cloning virtual machines.
• Troubleshooting issues related to VM( RDP/SSH)
• Monitoring the VM and analyzing the azure VM logs using Azure Analytics( OMS)
• Working on Azure extension issues.
• Creating Hosted services and Storage services.
• Moving classic resources between RSG- RSG in the same subscription and other subscriptions.
• Migration of VM from one region to another region, Classic to ARM ( both V Net based and service based)
• Migration of VM from on premises Physical Machine.
• Customer Engagement for all the capacity constrained clusters.
• Identify the Manual tasks and automate the needful
• Automation of the Operational Documents
• Project Management/Coordination including tracking issues to closure and status updates
• Daily interaction with customers.
• Lead Daily, weekly, and monthly review meetings
• Collect program metrics and provide status reports weekly.
• Cross group collaboration, work across teams and assess priority and severity of incoming issues
• Manage work items/issues in TFS
• Drive process improvements through continuous process improvement initiatives
• Design and Develop specifications for tracking tools for the end users so that can have better visibility of SLA of each team
• Developing monthly SSRS reports
• Azure Capacity auditing

Ø Installation and Configuration of SQL server 2008 R2, 2005 on windows 2008 and 2003

Ø Creating and configuring user databases.

Ø Scheduling Backups and Restoring databases.

Ø Developing successful Backup strategies based on recovery model.

Ø Having experience on Scheduling Jobs and assign Jobs.

Ø Configure Maintenance plan activity to maintain the database healthy and performance

Ø Managing Security (creating users, logins and roles, granting permissions).

Ø Install patch or service pack for SQL 2000 & SQL 2005.

Ø Disk space Planning and Management in all the servers.

Ø Backup client databases and perform database restore and run consistency checks from SQL Server and application.

Ø Recovery of Database at the time of Database crashes or disaster

Ø Hands on experience on Database replication, Log shipping and database mirroring.

Ø Configure and maintain database replication on publisher, distributor and subscriber

Ø Monitoring SQL server performance using Profiler to find performance and dead locks.

Ø Providing Primary DBA responsibilities for around 12 applications and giving support to more than 24 applications from offshore team.

Ø Check the Windows and Sql server logs for any errors/problems.

Ø Solving the tickets as per the severity.

• Implemented system enhancements to design and develop solutions to address problem reports.
• Collaborated with development teams to design scalable database schemas for new applications, resulting in seamless integration and enhanced functionality.

Ø Shift SPOC / Lead to ensure proper co-ordination with the team and guide / train new joiner and doing Daily Reporting.

Ø Handling a team and drive performance on all CPM of the process.

Ø Handling all technical escalations and Supervisor calls within the Team.

Ø Training the team on troubleshooting and product and process knowledge

Ø Analyze performance of individual agents and give proper feedback.

Ø Provide issue based and product based training to the team.

Ø Took all the team leaders responsibility in his absence.

Ø Prepare support documents and research on issues and come up with resolutions and share it to all other SME’s

Ø Drive FCR (First Call Resolution) and TPR (Total problem resolution) for the team.

Ø Attend to client conference calls on drive client metrics improvement.

Ø Acted as Floor Support on technical process related issues for fellow agents and also functioned as an acting Supervisor on need basis for taking supervisor calls.

Ø Involved in sharing and formulating the best technical resolutions and best-selling practices across the floor.

Ø Installation and Configuration of SQL server 2008, 2008R2 and 2012 on Windows 2008R2 and 2012

Ø Designed and implemented Security policy for SQL Servers

Ø Scheduling Backups and Restoring databases

Ø Developing successful Backup strategies based on Client requirement/ Recovery models

Ø Configure Maintenance plan activity to maintain the database healthy and performance

Ø Managing Security (creating users, logins and roles, granting permissions).

Ø Monitoring SQL server performance (Health Checks , I/O Bottlenecks , Fragmentation levels,

Dead locks)

Ø Maintaining SQL Server Security at Server & DB level

Ø Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels

Ø Disk space Planning & Management of all the servers

Ø Creating Linked Servers, Refreshing the Integration and UAT servers with Production copy of Database.

Ø Backup client databases and perform database restore and run consistency checks for SQL Server and application

Ø Recovery of Database at the time of Database crashes or disaster.

Ø Hands on experience on Database replication, Log shipping and database mirroring

Ø Creating Security Groups ( GS & DS), Users, Admin accounts on Active Directory

Ø Planning Capacity Management for next 5 years to avoid compatibility issues.

Ø Involving in Monthly application deployment and Installation of patches on Sql server

Ø Providing Support & Creating user credentials for more than 10 Applications.

Ø Preparation of Baseline documents for Server Statistics, Weekly Reports and Monthly reports.

Ø Automating the Dash Board process to retrieve information on failed jobs on all the servers.

Ø Configuring DB mail, Triggers to notify (DDL/DML) executions on a Database.

Ø Complete automating on NT so that the tasks are run without user monitoring.