This presentation will share and focus the real-life problem solving tips, tricks & best practices on Very Large Databases (VLDB) that learned from the real-life scenarios. Will be sharing with the audience the experience and interesting facts on how we managed to resolve some of the very complex/challenging data warehousing problems that yield us a huge performance improvement in data loading, daily batch schedule and other jobs. This presentation will also highlight on the common best practices of a data warehousing database like, how to improve/faster database statistics gathering, whats new in 12c partitioning, choosing and managing different index types/partitioning methods, database configuration/parameters, backup/recovery policies etc.
Syed Jaffar Hussain has over 20 years I.T. experience that includes more than 15 years of production Oracle database administration. Oracle has honored him with the prestigious Oracle ACE Director role, and named him DBA of the Year for 2011, both for his excellent knowledge and contributions to the Oracle community. He is an Oracle Certified Master (OCM) for Oracle Database 10g--a status granted only after passing extenstive challenges in a hands-on environment. He is also an Oracle Database 10g RAC Certified Expert. Syed Jaffar co-authored of the Oracle 11g R1/R2 Real Application Clusters Essentials, Expert Oracle RAC 12c books, currently co-authoring Oracle Exadata Expert's Handbook and he blogs regularly at http://jaffardba.blogspot.com