Oracle Autonomous Database in Enterprise Architecture

Utilize Oracle Cloud Infrastructure Autonomous Databases for better consolidation, automation, and security

Bal Mukund Sharma

Krishnakumar KM

Rashmi Panda

BIRMINGHAM—MUMBAI

Oracle Autonomous Database in Enterprise Architecture

Copyright © 2022 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

Group Product Manager: Gebin George

Senior Editor: Kinnari Chohan

Technical Editor: Jubit Pincy

Copy Editor: Safis Editing

Project Coordinator: Prajakta Naik

Proofreader: Safis Editing

Indexer: Hemangini Bari

Production Designer: Ponraj Dhandapani

Marketing Coordinator: Sonakshi Bubbar

First published: December 2022

Production reference: 1251122

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham

B3 2PB, UK.

ISBN 978-1-80107-224-3

www.packt.com

It is worth mentioning that the team at Packt Publishing has been the persistent driving force behind the successful publishing of this book.

There were several obstacles that arose during the pandemic that made the fate of this book appear gloomy. But we really appreciate how the Packt Publishing team pulled through and worked hard from the beginning to the completion of the book, extensively collaborating and coordinating with multiple stakeholders.

We would like to convey special thanks to our reviewers who have been very instrumental in getting the book to its final form, including refining the overall structure.

And last but not least, we will always be grateful to our families, who have always been the motivation of our lives.

- Bal, Krishna, and Rashmi

Contributors

About the authors

Bal Mukund Sharma is a technology specialist specializing in Oracle Cloud Infrastructure, databases, and engineered systems. He has experience across industries including Telecom, healthcare, financial services, and insurance. Bal is currently working as a senior cloud practice manager with Oracle and has worked in roles such as product manager, technical delivery manager, lead DBA, content architect, software engineer, and QA engineer. He helps customers with OCI-infrastructure implementation, networking, and SecDevOPS practices, along with technologies such as high availability, engineered systems, and autonomous databases. He has been very successful in helping several customers, such as banks and Telcos, to adopt the right database and cloud strategies and complex technology implementations across the world.

Besides this, Bal enjoys cooking for friends and family.

Krishnakumar KM is a cloud architect. He holds a master’s in business administration from Anna University. He started his career in 2004 as a DBA and has experience working in industries including banking, Telecom, and financial services. He has been working with Oracle for 12+ years. He is passionate about innovating, deploying, debugging, and designing cloud solutions for customers. He has extensive knowledge of computing, networks, storage, and virtualization theory and architecture. He is a part of beta testing database products and has written Oracle knowledge-base articles. He has delivered presentations through various channels, including Oracle OpenWorld. He actively participates in Oracle-related forums, such as OTN communities. He has also co-authored books on Oracle database upgrade and migration methods and Oracle database high availability.

Rashmi Panda is a database enthusiast with a keen interest in Oracle Database technologies. He has spent around 18 years in different roles, including as a developer and database administrator and consulting roles. He enjoys working with customers, providing guidance in adopting better deployment solutions to address their business transformation needs in their growth roadmap. Besides databases, he has garnered excellent experience in the data integration arena, which involves performing PoC and demos on OGG, ODI, and EDQ to meet the extensive and complex data integration needs of customers. Whether on-premises, cloud, or a hybrid kind of deployment, he has been successful in creating customer solutions in designated platforms that adhere to the customer’s data security requirements.

About the reviewers

Venkata Ravi Kumar, Yenugula (YVR) is an Oracle ACE Director and Oracle Certified Master (OCM) with 25 years of experience in the banking, financial services, and insurance (BFSI) verticals. He has worked as a vice president (DBA), senior database architect, senior specialist production DBA, and Oracle engineered systems architect.

He is an Oracle Certified Professional (OCP) from Oracle 8i/9i/10g/11g/12c/19c and also an Oracle Certified Expert (OCE) in Oracle GoldenGate, RAC, Performance Tuning, Oracle Cloud Infrastructure, Terraform, and Oracle Engineered Systems (Exadata, ZDLRA, and ODA), as well as Oracle Security and Maximum Availability Architecture (MAA) certified.

He has published over 100 Oracle technology articles, including on Oracle Technology Network (OTN), OraWorld Magazine, UKOUG, OTech Magazine, and Redgate. He has spoken twice at Oracle Open World (OOW), San Francisco, US.

He has designed, architected, and implemented the core banking system (CBS) database for the central banks of two countries – India and Mahé, Seychelles. Oracle Corporation, US, awarded him the title Oracle ACE Director and published his profile in their Oracle ACE Program.

They also published his profile on their OCM list and in their Spotlight on Success stories.

Dipanjan Biswas has more than 24 years of experience in the IT industry. He has played technology and delivery leadership roles in large IT consulting organizations, niche solution providers, and start-ups. He has led enterprise data platform implementations for multiple Fortune 500 customers in the pharma, retail, and banking domains. He has architected an enterprise fraud and risk management system for one of the world’s largest payment network providers.

He loves listening to music and reading books.

Sonali Malik is a mother, an engineer, a techie, a tech community leader, a mentor, and a chief architect with over 20 years of experience in Oracle Database technologies, cloud services, cloud consulting, and the IT industry. As a master principal cloud architect for strategic clients, Sonali specializes in Oracle Cloud Infrastructure and platform services, software delivery networks, cloud security, and Oracle products, along with other cloud platforms and on-premises technologies. Sonali has garnered substantial industry experience. In the past, she held technical and managerial positions in various organizations. She has an extensive history of customer advocacy with an understanding of how to suggest and help with making innovative technical decisions, get client consensus, and deliver commitments.

When she is not working, she spends her time pursuing hobbies such as dancing, reading books, cooking, traveling, and spending time with her family and friends. She also volunteers at different organizations that support diversity and inclusion.