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 02:30

    Room:
    HC-112 LPI

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

    Room:
    CC-201 TUT1

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

    Room:
    CC-202 TUT2

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

    Room:
    CC-234 BAIRS

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

    Room:
    HC-104 openSUSE

  11. ROSECODE
  12. Start Time:
    2018 April 29 03:45

    Room:
    G-103

  13. Don't Fear the Patent Clause!
  14. Start Time:
    2018 April 29 03:45

    Room:
    CC-114

  15. Incident Response with Live Linux Forensics
  16. Start Time:
    2018 April 29 03:45

    Room:
    CC-200

  17. Privacy on the blockchain
  18. Start Time:
    2018 April 29 03:45

    Room:
    HC-108

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

    Room:
    CC-208

  21. Arduino, ESP8266 and 433 Mhz Devices
  22. Start Time:
    2018 April 29 03:45

    Room:
    CC-236

  23. Old Dogs & New Tricks
  24. Start Time:
    2018 April 29 03:45

    Room:
    CC-115

  25. Using osquery via Fleet for Client/Server visibility
  26. Start Time:
    2018 April 29 03:45

    Room:
    CC-235