DBA as Protector of the Data: Notes from the Field
Presenter: Denise McInerney
The DBA can be the last line of defense guarding the integrity of their company’s data. Taking this responsibility seriously will make you more successful in your job. This session will discuss how the DBA can proactively ensure the data in their transactional system is clean and correct. The presenter will take a comprehensive view of this crucial aspect of the DBA’s job, drawing on many real-life examples. The topics covered will include table design, transactions, change management, and coding standards. She will explain how these distinct topics are actually part of an integrated approach to data protection. The presenter will also describe how pessimism and vigilance can be valuable traits for a DBA.
About the Speaker
Denise McInerney began working as a SQL Server DBA in 1998. Denise's focus is on design and performance tuning of OLTP databases that support web-based applications. She is currently employed as a Staff Database Administrator at Intuit where she designs, tunes and manages databases that support one of the company’s eCommerce web sites.
Denise has been an active PASS volunteer since 2003. She served on the Program Committee for four years, including one year as Program Committee Manager. She has been an organizer of the PASS Women in Technology luncheon and Panel Discussion since 2004 and founded the WIT Virtual Chapter. Denise was the recipient of the PASSion Award in 2007.