This book dealt with below intention: Improve performance of oracle code by showcasing all possible alternative concepts present in database This intention have arisen based on the burning need of database users I have come across throughout my career with roles like PL/SQL developers, Database Administrators, Designers, Data analysts, Performance tuning analysts, Architects, Students, Professors, Interviewees and any DBMS enthusiast or aspirant for oracle certification. Some of these had extensive experience in what they do and have influenced me writing this book. This book will teach you how you can tune your database application by refactoring your code. Also it provides advices on tuning approach. The audience of this book would like to cover multiple versions of Oracle and the features it offers. Seeking the best approach for a challenge has not been easy in past as it required a large investment of time and effort to go through the vast amount of documentation. This 135 pages book facilitates that investment, by exploring and churning the vast archives of oracle documentation and producing the output in a nutshell which otherwise readers would need to spend time on.
Asim has over 15.5 years of experience in architecting and designing data modelling of complex applications, leading database development, support & consultancy for payment solutions, smart metering solutions for Financial and Energy & Utility business domain, Government program for geo spatial database for automated payment of European subsidy for farming across UK. Prior to joining Logica (Currently CGI UK), he was with Oracle Corporation as a Senior Analyst and was leading the Language Division of Oracle Worldwide Support. He was responsible for design and development of new features of Oracle 11g beta release. He was leading the team responsible for Severity 1 High value issues for some of Oracle's high profile potential customers like Fidelity, NASA, HP, Cisco, Sun, Boeing, Citibank, HSBC, Dell, Lucent, Qantas, and Sun Microsystems.He has published many technical articles and papers, which are available in Oracle support website www.metalink.oracle.com. He has also written many Technical Guide Reference Books - "Oracle SQL and PL/SQL Guide Till 10gR2" published: 2009 available only in India "Basic Oracle SQL & PL/SQL Notebook on high performance" published: 2016 available worldwide "Oracle SQL & PL/SQL Golden Diary on refactoring, interoperability & integration of related concepts" published: 2016 available worldwide He has been interviewed by internal magazine of Logica for his extraordinary performance which led to the launch of the Citibank product in Europe, Amsterdam. The product was highlighted in Business wire Magazine, London. In Short: - Specialized in PL/SQL and SQL development - Improved database deployments and reduced downtime by using different refactoring methods - Spearheaded and coordinate projects to fix database issues impacting development, testing, and deployments. - Engage with stakeholders at all levels (CTO, Senior operation director etc.) - Engage with infrastructure, development and integration teams - Identify key IT risks and issues and prioritise them. - Define, plan and execute strategy across the program - Communicate clearly to all stakeholders - Introduce and monitor
