"Advanced Database Administration, Performance Optimization & Migration Strategies in Enterprise Data Warehousing"

In this presentation, I will walk through my extensive experience as an Application DBA working across Teradata and Oracle platforms for major enterprise clients. I will cover key aspects of performance tuning, SQL optimization, data modeling, access management, security remediation, and large-scale database migrations. The presentation highlights my hands-on work with footprint reduction, ETL pipeline integration, Hadoop ingestion, user access governance, and capacity management. I will also discuss how I optimized thousands of SQL queries, reclaimed large volumes of space, enforced audit standards, and supported mission-critical production workloads. This session aims to demonstrate how strategic DBA practices, automation, and strong analytical thinking can improve performance, reduce risk, and enhance overall data platform reliability.
Who is this presentation for?
This presentation is intended for: Database Administrators (DBAs) Data Warehouse Architects & Engineers ETL Developers and Data Engineers Application Developers working with large datasets Technology leaders overseeing data migration or modernization projects Teams handling data governance, access management, and audit compliance Anyone interested in understanding enterprise-level DBA responsibilities and performance tuning
Prerequisite knowledge:
5. Prerequisite Knowledge To get the most value from this presentation, the audience should have: Basic understanding of RDBMS concepts (tables, indexes, joins, statistics) Familiarity with SQL Some exposure to data warehousing concepts such as facts, dimensions, ETL, CDC Awareness of database environments (DEV/QA/PROD) and migration practices Optional: knowledge of Teradata, Oracle, or ETL tools like DataStage/Informatica
What you'll learn?
By the end of this presentation, you will learn: How I optimized SQL queries and improved database performance in large-scale systems Techniques for footprint reduction, space reclamation, and resource optimization Best practices in Teradata statistics management, indexing, and skew mitigation How to migrate databases, schemas, and functional IDs during platform upgrades The process of securing platforms through access remediation and role normalization Approaches to ETL integration, Hadoop ingestion, and pipeline development Strategies for handling production failures, spool space issues, and high-CPU queries How to work effectively with cross-functional teams and support business requirements Real-world examples of audit remediation, security governance, and data compliance How to design, monitor, and maintain enterprise-level data warehouse systems

My name is Guruprasad Nookala, and I am an Application DBA with over 12 years of IT experience specializing in Teradata, Oracle, ETL, and Data Warehousing. I have worked extensively on performance tuning, database optimization, access management, migration projects, and large-scale data warehouse environments. I possess strong expertise in SQL tuning, Teradata utilities, ETL development, data modeling, capacity management, footprint reduction, and security remediation. I hold a Master of Computer Applications degree and have worked with major clients such as JP Morgan Chase & Co., Southern California Edition, and British Telecom. I am passionate about building optimized data systems, improving performance, enforcing governance, and supporting critical business operations.