arvind toorpu

CORE

Cloud Ops DBA manager at Allspring Global

Joined Aug 2024

https://arvindtoorpu.com

About

Hello, I’m Arvind Toorpu, an Oracle Certified Professional (OCP) currently working as a Cloud Ops Database manager at financial firm with over 14 years of diverse experience in architecting, implementing and administering databases. My expertise spans across Oracle, SQL Server, MySQL, and PostgreSQL, among others, in both production and non-production environments. I have worked extensively with various operating systems, including Red Hat Linux, HP-UX, Sun Solaris, IBM AIX, and Windows Server. As a passionate database professional, I specialize in performance tuning, database migrations, high availability architecture, and implementing disaster recovery solutions. Throughout my career, I have led major projects, including the migration of hundreds of databases to cloud platforms like AWS, Azure, and Oracle Cloud Infrastructure (OCI). My roles have ranged from hands-on database management to leading teams in cloud operations, where we’ve configured and optimized complex database environments to meet business needs. I have a strong background in capacity planning and resource allocation, ensuring that database resources are effectively utilized while managing costs through strategic cost management and cost optimization. My expertise in data modeling and query optimization enhances system performance, while my troubleshooting skills enable me to provide 24/7 support, ensuring operational excellence and reliability

Stats

Reputation:	1492
Pageviews:	83.0K
Articles:	25
Comments:	1

Articles
Comments

Articles

Decoding Database Speed: Essential Server Resources and Their Impact

Database performance hinges on CPU, memory, and storage. Monitoring and tuning these resources ensures efficient data ops like a kitchen running at peak speed.

July 15, 2025

· 1,361 Views

Indexed Views in SQL Server: A Production DBA's Complete Guide

Learn indexed views in SQL Server from a seasoned DBA's perspective with practical examples, performance testing, and best practices for database optimization.

July 11, 2025

· 1,170 Views · 1 Like

Exploring Data Redaction Enhancements in Oracle Database 23ai

Oracle Database 23ai enhances data redaction with broader SQL support, allowing safe use of redacted columns in views, GROUP BY, and set operations.

July 9, 2025

· 1,154 Views · 1 Like

Safeguarding Cloud Databases: Best Practices and Risks Engineers Must Avoid

This article explores database security practices in cloud environments, highlighting risks like misconfigurations, insufficient encryption, and excessive privileges.

June 16, 2025

· 1,015 Views

Monitoring and Managing the Growth of the MSDB System Database in SQL Server

The msdb system database in SQL Server is crucial for managing and maintaining tasks such as job scheduling, alerts, and database mail. Learn more about it.

June 16, 2025

· 1,363 Views

Secure Your Oracle Database Passwords in AWS RDS With a Password Verification Function

Enforce strong password policies for Oracle databases on AWS RDS using built-in or custom verification functions via the rdsadmin package.

June 10, 2025

· 1,024 Views · 1 Like

Data Storage and Indexing in PostgreSQL: Practical Guide With Examples and Performance Insights

Explore how PostgreSQL handles large data using TOAST and improves query speed with indexes like B-tree, GIN, and BRIN, cutting query times by over 90%.

June 6, 2025

· 2,574 Views · 5 Likes

Resolving Parameter Sensitivity With Parameter Sensitive Plan Optimization in SQL Server 2022

Learn how SQL Server 2022's Parameter Sensitive Plan Optimization (PSP) solves parameter sniffing by caching multiple execution plans for parameterized queries.

May 30, 2025

· 2,805 Views · 1 Like

Memory-Optimized Tables: Implementation Strategies for SQL Server

Through practical implementation guidance and real-world examples, learn how this in-memory technology can deliver 5- 30x performance improvements for OLTP workloads.

May 28, 2025

· 2,854 Views · 2 Likes

Performing and Managing Incremental Backups Using pg_basebackup in PostgreSQL 17

PostgreSQL 17 adds incremental backups with pg_basebackup and pg_combinebackup, saving time and storage by capturing only changed data since the last backup.

May 14, 2025

· 2,403 Views · 1 Like

SQL Server Index Optimization Strategies: Best Practices with Ola Hallengren’s Scripts

This guide covers the effective implementation of Ola Hallengren's SQL Server Maintenance Solution for index optimization, especially in Availability Group environments.

April 25, 2025

· 6,343 Views · 2 Likes

Optimizing Data Storage With Hybrid Partitioned Tables in Oracle 19c

Learn how to implement Hybrid Partitioned Tables (HPT) to streamline data management, boost query performance, and cut storage costs.

April 8, 2025

· 3,182 Views · 2 Likes

Lessons from Migrating an Oracle Database to AWS RDS

Migrating an on-prem Oracle database to AWS RDS brings cost savings and automation but comes with performance tuning limits, upgrade challenges, and DBA restrictions.

April 2, 2025

· 3,784 Views · 2 Likes

Understanding SQL Server Query Store: A Comprehensive Guide

In this article, we will explore what the Query Store is, its benefits, scenarios for its use, and steps to implement it with examples.

April 1, 2025

· 4,232 Views · 6 Likes

Unlocking Oracle 23 AI's JSON Relational Duality

Oracle 23ai combines AI with JSON and relational duality, allowing easy querying and updates across both formats. Learn how this integration streamlines data management.

March 19, 2025

· 2,721 Views · 2 Likes

How to Backup SQL Server RDS to an S3 Bucket

Learn how to back up your SQL Server RDS database directly to an Amazon S3 bucket using msdb.dbo.rds_backup_database, with detailed examples.

February 13, 2025

· 3,795 Views · 2 Likes

Data Management With PostgreSQL Partitioning and pg_partman

PostgreSQL table partitioning divides large tables into smaller segments to boost query performance, simplify maintenance, and enable scalable data management.

February 7, 2025

· 2,879 Views

Copy SQL Execution Plan from One Database to Another in Oracle 19c

In this step-by-step guide, we will cover SQL Plan Management (SPM), exporting or importing plans, and fixing execution plans for consistent query behavior.

January 13, 2025

· 4,520 Views · 3 Likes

Exploring the New Boolean Data Type in Oracle 23c AI

Oracle 23c AI introduces native support for the boolean data type, enabling straightforward representation of true, false, and null values in SQL and PL/SQL.

December 19, 2024

· 4,427 Views · 1 Like

Managing Orphaned Users in SQL Server: A Comprehensive Guide

Effectively managing orphaned users within SQL Server is imperative for ensuring database security and efficient administration.

December 18, 2024

· 4,725 Views · 1 Like

The Importance of Data Compression in Oracle Databases

Learn the benefits, drawbacks, techniques, and real-world applications of data compression in Oracle Databases to optimize storage and boost performance.

December 4, 2024

· 2,542 Views · 1 Like

How to Efficiently Manage Inactive (IDLE) Oracle Database Sessions

Learn how to manage inactive Oracle sessions using DCD, IDLE_TIME, and Resource Manager to optimize overall database performance and prevent resource issues.

November 18, 2024

· 2,652 Views · 1 Like

How to Run a MySQL Database in a Docker Container

Learn how to set up a containerized MySQL database with Docker, including steps for running, accessing, connecting from your host, and cleaning up the container.

November 12, 2024

· 1,851 Views · 3 Likes

Cost Optimization Strategies for Managing Large-Scale Open-Source Databases

Explore some options that can be adapted to achieve effective management of large-scale open-source databases while keeping the costs in control.

November 5, 2024

· 14,711 Views · 3 Likes

Amazon Redshift Workload Management (WLM): A Step-by-Step Guide

Amazon Redshift's WLM feature lets you define how queries are prioritized and resources are allocated. This guide walks through setting up WLM step by step.

October 14, 2024

· 2,885 Views · 3 Likes

Comments

Cost Optimization Strategies for Managing Large-Scale Open-Source Databases

Nov 21, 2024 · arvind toorpu

The decision ultimately depends on the specific use case and the volume of data that needs to be processed. From my perspective, it seems we may not yet be fully production-ready, particularly for large-scale databases. However, containers could still be a viable option for smaller-scale databases. Organizations universally expect their data to be retrieved at high speeds and with consistency, and while containers offer potential benefits, their suitability must align with these expectations.