Accolades for Database Administration - …

1 Accolades for Database Administration I've forgotten how many times I've recommended this book to people. It's well written, to the point, and covers the topics that you need to know to become an effective DBA.. Scott Ambler, Thought Leader, Agile Data Method This is a well-written, well-organized guide to the practice of Database Administration . Unlike other books on general Database theory or relational Database theory, this book focuses more directly on the theory and reality of Database Administration as practiced by Database professionals today, and does so without catering too much to any specific product implementation.

2 As such, Database Administration is very well suited to anyone interested in surveying the job of a DBA or those in similar but more specific roles such as data modeler or Database performance analyst.. Sal Ricciardi, Program Manager, Microsoft One of Craig's hallmarks is his ability to write in a clear, easy-to-read fash- ion. The main purpose of any technical book is to transfer information from writer to reader, and Craig has done an excellent job. He wants the reader to learn and it shows.. Chris Foot, Manager, Remote DBA Experts and Oracle ACE.

3 A complete and comprehensive listing of tasks and responsibilities for DBAs, ranging from creating the Database environment to data warehouse Administration , and everything in between.. Mike Tarrani, Computer Consultant I think every business manager and every IT manager should have a copy of this book.. Dan Hotka, Independent Consultant and Oracle ACE. This book by Craig Mullins is wonderfully insightful and truly important. Mullins describes the role and duties of data administrators and Database administrators in modern organizations with remarkable insight and clarity.

4 Michael Tozer, Author and former Navy officer This page intentionally left blank Database Administration Second Edition This page intentionally left blank Database Administration The Complete Guide to DBA Practices and Procedures Second Edition Craig S. Mullins Upper Saddle River, NJ Boston Indianapolis San Francisco New York Toronto Montreal London Munich Paris Madrid Capetown Sydney Tokyo Singapore Mexico City Many of the designations used by manufacturers and sellers to distinguish their Editor-in-Chief products are claimed as trademarks.

5 Where those designations appear in this Mark Taub book, and the publisher was aware of a trademark claim, the designations have Acquisitions Editor been printed with initial capital letters or in all capitals. Greg Doench The author and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibil- Development Editor ity for errors or omissions. No liability is assumed for incidental or consequen- Susan Brown Zahn tial damages in connection with or arising out of the use of the information or Managing Editor programs contained herein.

6 John Fuller The publisher offers excellent discounts on this book when ordered in quan- tity for bulk purchases or special sales, which may include electronic versions Production Editor and/or custom covers and content particular to your business, training goals, Caroline Senay marketing focus, and branding interests. For more information, please contact: Copy Editor Corporate and Government Sales Barbara Wood (800) 382-3419. Indexer Richard Evans For sales outside the United States, please contact: Proofreader International Sales Diane Freed Visit us on the Web: Technical Reviewers Library of Congress Cataloging-in-Publication Data William Arledge Kevin Kline Database Administration : the complete guide to DBA practices and procedures /.

7 Craig S. Mullins. 2 [edition]. Editorial Assistant pages cm Michelle Housley Includes bibliographical references and index. Cover Designer ISBN 978-0-321-82294-9 (alk. paper) ISBN 0-321-82294-3 (alk. paper). 1. Database management. I. Title. Chuti Prasertsith 2013 Compositor dc23 Rob Mauhar 2012029466 The CIP Group Copyright 2013 Craig S. Mullins All rights reserved. Printed in the United States of America. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or trans- mission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise.

8 To obtain permission to use material from this work, please submit a written request to Pearson Education, Inc., Permissions Depart- ment, One Lake Street, Upper Saddle River, New Jersey 07458, or you may fax your request to (201) 236-3290. ISBN-13: 978-0-321-82294-9. ISBN-10: 0-321-82294-3. Text printed in the United States on recycled paper at Edwards Brothers Malloy in Ann Arbor, Michigan. First printing October, 2012. To my wife, Beth, for her unending love, constant support, and beautiful smile.

9 This page intentionally left blank Contents Preface xxxi How to Use This Book xxxiii Acknowledgments xxxv About the Author xxxvii Chapter 1 What Is a DBA? 1. Why Learn Database Administration ? 3. A Unique Vantage Point 4. DBA Salaries 4. Database Technology 6. The Management Discipline of Database Administration 9. A Day in the Life of a DBA 12. Evaluating a DBA Job Offer 14. ix x Contents Database , Data, and System Administration 15. Data Administration 15. Database Administration 19. System Administration 20.

10 DBA Tasks 20. Database Design 21. Performance Monitoring and Tuning 22. Ensuring Availability 24. Database Security and Authorization 24. Governance and Regulatory Compliance 26. Backup and Recovery 26. Ensuring Data Integrity 27. DBMS Release Migration 29. Jack-of-All-Trades 29. The Types of DBAs 31. System DBA 31. Database Architect 32. Database Analyst 33. Data Modeler 33. Application DBA 34. Task-Oriented DBA 36. Performance Analyst 36. Data Warehouse Administrator 36. Staffing Considerations 37.