Data Product Management Joining Solved Problems John Bowker
Data Product Management Joining Solved Problems
John Bowker ○ ○ ○ Product Owner - Data Infrastructure 4 years at Xero 10 years in the Gaming Industry Thanks to our Gold Sponsors: SQL Sat Auckland
We help small businesses thrive worldwide 1. 38 M+ 180 subscribers countries 600+ 2000+ add-on solutions employees Thanks to our Gold Sponsors: SQL Sat Auckland
Xero Cloud Data Locations Thanks to our Gold Sponsors: SQL Sat Auckland
Great Things About Data Teams ● ● Infrastructure Knowledge 24/7 On Call Experience ACID work ethic Customer Obsession Thanks to our Gold Sponsors: SQL Sat Auckland
Issues With Data Teams ● ● Not Developers (but can be) Internal vs External Customers Limiting Work in Progress More Ownership than required* Thanks to our Gold Sponsors: SQL Sat Auckland
V 5 or The Great Migration to AWS ● ● ● 22 SQL Clusters 2 AWS Regions 2 Hour Cluster Build Time Infrastructure + Data Migration Team 24/7 On Call Support Thanks to our Gold Sponsors: SQL Sat Auckland
Getting from here to there “Changing the wheels on the bus while we hit the highway and fill up with gas without stopping. ” ● Split the team ○ Continue with Migration to AWS ○ Build the Node Swap process ● Test the process extensively ○ Data loss or interruption to service is unacceptable ● Click the button! Thanks to our Gold Sponsors: SQL Sat Auckland
The Great Migration Part 2 “Changing the wheels on the bus while we hit the highway and fill up with gas without stopping. ” ● Moving to AWS Dedicated Hosts ● 2 nd DR node Thanks to our Gold Sponsors: SQL Sat Auckland
SQL Node Swaps CFN SQL Cluster Config Node Swap Thanks to our Gold Sponsors: SQL Sat Auckland
On Call Lessons Learnt ● Patterns ○ ○ Constantly refine monitoring + alerting Spread the incident info (team members must know!) ● Baseline metrics before setting thresholds ○ Don’t spam everyone! ● Invest time in Runbooks ● Get rid of alerts that make little sense ○ Don’t alert on legacy systems that add little value ● Question your monitoring tool Thanks to our Gold Sponsors: SQL Sat Auckland
On Call Runbooks Thanks to our Gold Sponsors: SQL Sat Auckland
CI/CD Pipeline Test Thanks to our Gold Sponsors: UAT Live SQL Sat Auckland
Solving Problems with Tools and Processes Thanks to our Gold Sponsors: SQL Sat Auckland
Solving Problems with Tools and Processes Thanks to our Gold Sponsors: SQL Sat Auckland
Solving Problems with Tools and Processes Thanks to our Gold Sponsors: SQL Sat Auckland
Product Management Patterns ● ● ● ● GIST Planning (Goals, Ideas, Step Projects, Tasks As PO/PM you are the cheerleader No direct reports means influencing skills Predict the future Factor in needs of team, management and customers You are the voice of the customer There is a time value to money Licensing Fees in the Cloud needs attention Thanks to our Gold Sponsors: SQL Sat Auckland
Thanks to all sponsors Thanks to our Gold Sponsors: SQL Sat Auckland
- Slides: 19