Pavani Reddymasu

· Identifying and fixing resource intensive queries.

· Assisting Architects with architectural guidance to ensure new solutions are designed correctly for both on premise and cloud environments for SQL Server’s

· Responsible for the day-to-day team management as well as support and administration of the full SQL Server technology stack including engineering and all SQL Server database related projects.

· Configure, maintain, and document database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

· Led migration projects from on-premises SQL Server to Azure SQL Database and AWS RDS, ensuring minimal downtime and data integrity.

· Building and maintaining PowerBI Dashboard to monitor SQL machines.

· Analyses database usage trends and highlighting proactively any possible issues to avoid unplanned outages.

· Refine and automate regular processes, track issues, and document changes.

· Assist developers with complex query tuning and schema refinement.

· Build and maintenance of PowerShell repository like Dbatools more specific to Imdex SQL environment and standards to do database daily task with ease and elegance.

· Performing database Daily health checks build on recommendation from Microsoft and likes of Brent Ozar’s and other SQL Guru’s.

· Designed and implemented high availability solutions using Always On Availability Groups and Failover Clustering.

· Developed and optimized complex T-SQL queries, stored procedures, and functions to enhance application performance.

· Automated routine DBA tasks with PowerShell scripts, improving operational efficiency and consistency.

· Oversaw SSIS package development and maintenance for ETL processes, and SSRS report design for business intelligence solutions.

Core Projects:

· Automation

Build PowerShell repository to automate regular processes.

Build PowerBI Dashboard for on prem and cloud SQL monitoring leveraging performance counter ,DMV’s and Query Store Data

· Cloud Migration

o Designing and building the Azure SQL Server landscape as well as assessment of existing on-premises landscape to determine the appropriate migration approach and target configuration for each database/application.

Offering 24/7 on-call support driven by tight SLAs for issues ranging from instance down, index corruptions, log shipping delays, replication,Always On sync issues, etc. in MS SQL Server environments.

· MS SQL Cluster and Server installation (MS SQL 2005, 2008, 2008R2, 2012,2014,2016,2017,2019 and 2022), upgrades and downgrades

• Good working experience on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
• Experience in managing Very Large databases (VLDB) and troubleshooting problems
• Implemented Extended Events to replace custom scripts for monitoring & troubleshooting issues
• Scripting PowerShell to automate logshipping ,database/Server level activities like monitoring disk space, Status of services etc.,
• Experience in Windows Azure, migrating database to Azure
• Experience in Migrating SQL Server databases to Amazon RDS
• Performing SQL Server query and performance tuning (IO stats, memory and CPU bottlenecks, etc.)
• Extensive experience in Troubleshooting and Query Tuning complex SQL Code, Stored Procedures, Triggers, Views etc., by analyzing wait stats, Execution plan & updating statistics
• 
  

· Setting up SQL Server maintenance tasks (backups, indexing, DB consistency checks, update statistics, etc.)

· Setting up replication, log shipping ,database mirroring and Always on Avalability features in MS SQL instances

· Monitor, investigate and resolve poorly performing queries on customer servers.

· Monitor and resolve issues (performance, database consistency, security etc) found on customer servers

· Experience working with SSRS and SSIS.

· Analysis, problem solving and solution design

· Installation/configuration of SQL Server in standalone and failover clustered environments

· Predictive analysis and proactive management to reduce high severity incidents

· Patch management, disaster recovery planning and implementation

· Liaising with customers offering best practice recommendations, root cause analysis and meeting SLAs

Core Projects:

· SQL Server Rationalisation

o Tasked with the responsibility to lead the technical implementation of a global SQL Server rationalization project with the aims of eliminating legacy versions (2008 and earlier) as well as consolidating implementations to reduce license cost.

· Cloud adoption

o I was tasked with the role of designing and building the Azure SQL Server landscape as well as assessment of existing on-premise landscape to determine the appropriate migration approach and target configuration for each database/application.

· With over 1500 SQL Servers in dozens of locations globally my role as part of a small team of 12 SQL Server DBAs was to provide the business with L2/L3 support as well as design/engineering services.

· As part of the senior engineering team , I provided guidance and mentoring to the remainder of the operational team based in India ,USA and Australia.

· Designed and implemented a full range of SQL Server configurations including high availability through Always on Availability Groups, Failover Cluster Instances and Mirroring as well as implementations of other SQL Server components including Replication, Integration Services, Reporting Services (Native and PowerBI) and Analysis Services.

· Assisted application teams with a range of services from design/development through to performance tuning and upgrades.

· Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.

· Evaluating data modelling, database administration, and database backup and recovery tools and make recommendations.

· Setting up and monitored transactional replication, Database mirroring on Production and QA servers.

· Responsible to Monitor and troubleshooting Log Shipping.

· Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.

· Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008.2012.

· Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

· Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

· Checking Database Health by using DBCC Commands and DMV’S.

· Handle the task of developing/managing different Application Modules and databases in addition to appropriate coding to facilitate online transaction, interaction and application by citizens

· Generate reports efficiently and effectively by making use of appropriate tools on a scheduled and timely manner.

Core Projects:

· Disaster Recovery

o Undertaking yearly offsite DR exercise from initial planning through to execution.

· SQL Server Upgrade/migration

o In excess of 100 SQL server upgrades through either migration to new servers, side-by-side installation, or in-place upgrades. Typical source versions SQL Server 2000 through to 2008R2 with target versions 2012 and 2014.

· Patching

o Ensuring all SQL Servers met company standards with regards to patch currency. Prior to commencement 5% of servers were compliant with latest available patches – ensured by completion that 100% compliance with latest service packs/cumulative updates had been achieved.