Dylan Petrusma – Database Administrator

Synopsis

I have been working with SQL Server at Youi Insurance since June 2014, first as a BI analyst and now as a DBA. I have experience in writing queries, performance tuning, creating reports, database monitoring, and implementing DevOps in this financial services organisation, and I am always trying to learn more about improving our use of Microsoft SQL Server products.

Experience

Youi Insurance – Data Foundations Analyst/Database Administrator – Sunshine Coast

Feb 2020 – Present

  • In a team of 4, managing 2 production SQL Server instances with a total of 59 databases up to 1TB in size, plus 1 test, 1 development, and 1 DR instance - Managing an SSRS report server and an SSIS server
  • Focus on application DBA work – query tuning, performance bottlenecks on memory and tempdb, data quality, security access controls, and end user education for analysts and non-analysts
  • DevOps development for both the DBA team and the BI team, using Redgate tools, TeamCity, Octopus, and roundhousE
  • Helped reduce our daily ETL errors and agent job errors from 1,000’s a day to less than 20
  • Documenting current processes that run out of the Warehouse that require maintenance, as well as all tips for getting new BI and DBA staff up to speed
  • Azure fundamentals online learning

Youi Insurance – Claims Analyst/Business Intelligence Analyst – Sunshine Coast

June 2014 – Feb 2020

  • From 2018 onwards, assisted the DBA team with query tuning and SQL error troubleshooting
  • Building dozens of reports in SQL Server, SSRS, SSAS Tabular and Tableau
  • DAX coding for SSAS Tabular Cubes - 6 cubes from scratch with Excel frontends
  • Moved the BI team to use git change management for Tableau development
  • Built our first warehouse development DevOps pipeline using git, TeamCity, and Octopus
  • Ran live education classes for Excel, Tableau, and Git
  • Worked under the Head of Procurement, and later the Head of Data & Analytics
  • Completed Youi’s Internal leadership development program

Power to Change – Missionary – Nagoya, Japan

Feb 2013 – Feb 2014

  • Worked with 9 team members from 3 countries d communicated in 2 languages
  • Living overseas meant I was often alone and reliant on self-discipline to work effectively

Qualifications and Education

BrentOzar.com - Fundamental of Index Tuning and Fundamentals of Columnstore - Online – Jun 2021 to Jul 2021

  • Index tuning and maintenance, query engine theory, columnstore index uses

Microsoft Learn – Azure Fundamentals – Online — Oct 2020 to Nov 2020

  • Core cloud concepts, Azure services, workloads, security, and privacy

Tableau – Tableau Desktop Certified Associate – Online — August 2019

  • Mapping, data preparation, Tableau calculations and charts, statistical analytics, data stories

Coursera - Google Cloud Platform Big Data and Machine Learning Fundamentals - Online — Dec 2017

  • Core cloud concepts, GCP services, BigQuery, cloud data migration

Udacity – Nanodegree, Data Analysis – Online — July 2016 to July 2017

  • Statistics, data wrangling, machine learning with Python, visualisation with Tableau

University of Queensland – Bachelor of Science (Honours), Mathematics – Brisbane — Feb 2009 to December 2012

  • First class honours with a final GPA of 6.5
  • Researched and wrote a 27,000-word thesis on hyperplane arrangements in high-dimensional space
  • Learnt and successfully used Perl programming to interface with the geometry software Polymake