Presented by:

6e669a68aee7cfab192e29da07f8a931

Robert Bernier

from Zonar Systems

First introduced to hangman on a mini computer playing the William Tell Overture, Robert is a very "old?" school hacker.

Robert discovered Linux after completing several years of much needed therapy overcoming the trauma of programming using punchcards. Eventually, he focused his open source activities on PostgreSQL and has since then worked in everything from mom and pop companies to fortune 50 companies. He has had the singular honor of conducting training at the famed Los Alamos National Laboratory.

After working several years in California's Silicon Valley, he returned to the Pacific Northwest to experience real weather. These days, he is the senior DBA at Zonar Systems, working in the heart of Seattle's downtown core.

The primary task of a developer is to get the product out the door. Sometimes, making deadlines means taking shortcuts. Eventually, all those quick and easy tricks become so convoluted and complex that this house of cards risks collapsing with the first stiff breeze. In other words Technical Debt has been created and must now be managed.

Over time, the possibility of slowing down, even reversing one's success risks becoming a self-inflicting nightmare. A different path needs to be charted and navigated before it's too late.

Enter the new guy... a new kind of DBA.

This presentation describes a modern view of the DBA in an environment that has grown heavy and unwieldy as TECHNICAL DEBT becomes ever more expensive. We'll see how he can play a new and ambitious role resolving these issues with a perspective unique to the database administrator.

Valuable Methods and techniques covered includes:

  • Figuring out what's going on
    • Monitoring the system
    • Developing metrics that everyone understands
    • Correcting bottlenecks to critical issues
    • Performance tuning (and the law of diminishing returns)
  • Streamlining the infrastructure
    • The QA/DEV/PROD development cycle
    • Working better with what you have (having money doesn't help)
    • Improving the infrastructure (sometime money does make a difference)
  • Documentation
    • Leveraging what you write
    • The art of creating, assigning and documenting tasks
  • Empowering the DEV
    • RDBMS Mentoring
    • Best Practices, Dos and Don'ts
    • Guiding developers into the world of DEVOPS
    • Preparing and supporting the ON CALL developer

SLIDES/REPO: https://gitlab.com/fV6Dcb8VGcpyI/picking_up_the_pieces.git

Date:
Duration:
45 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2018
Language:
Track:
PostgreSQL
Difficulty:
Medium

Happening at the same time:

  1. Linux Professional Institute: Exam Lab - Session 1
  2. Start Time:
    2018 April 29 09:30

    Room:
    HC-112 LPI

  3. Making Chiptunes on a Raspberry Pi
  4. Start Time:
    2018 April 29 09:30

    Room:
    CC-201 TUT1

  5. Improving Arduino Education
  6. Start Time:
    2018 April 29 09:30

    Room:
    CC-202 TUT2

  7. Build and Program Your First Arduino Robot
  8. Start Time:
    2018 April 29 09:30

    Room:
    CC-234 BAIRS

  9. openSUSE Mini-Summit
  10. Start Time:
    2018 April 29 09:30

    Room:
    HC-104 openSUSE

  11. Using osquery via Fleet for Client/Server visibility
  12. Start Time:
    2018 April 29 10:45

    Room:
    CC-235

  13. ROSECODE
  14. Start Time:
    2018 April 29 10:45

    Room:
    G-103

  15. Don't Fear the Patent Clause!
  16. Start Time:
    2018 April 29 10:45

    Room:
    CC-114

  17. Arduino, ESP8266 and 433 Mhz Devices
  18. Start Time:
    2018 April 29 10:45

    Room:
    CC-236

  19. Hybrid multi-cloud infrastructure as code using Terraform
  20. Start Time:
    2018 April 29 10:45

    Room:
    CC-208

  21. Old Dogs & New Tricks
  22. Start Time:
    2018 April 29 10:45

    Room:
    CC-115

  23. Privacy on the blockchain
  24. Start Time:
    2018 April 29 10:45

    Room:
    HC-108

  25. Incident Response with Live Linux Forensics
  26. Start Time:
    2018 April 29 10:45

    Room:
    CC-200