philip traunersomewhere at the intersection of computers and humanities
🇦🇹 wiener neustadt, austria
philip-trauner.me/trauner.philip[at]gmail.com
hi 👋

i've been fortunate to have played a role in many disciplines required in bringing products to life.

this has made me a strong generalist, capable of fulfilling the needs of the business, while still being a passionate advocate for the customer.

i'm at my best when coming up with a design, and then working backwards from it layer by layer.

i believe computers should delight, and i look forward to working with folks that share said belief ✨

what i'm also passionate about: #photography #3d-printing #home-automation #music #gaming #star-trek
eq.fm2022—now • founder
companion app for music, with catalog browsing, play history filtering, universal track links, and customizable user profiles
  • product

    prototyping / design / asset management in Figma

    documentation in Notion

  • implementation
    • iOS client
      Swift / SwiftUI app with bits of UIKit

      functionality grouped into Swift packages

      custom combined playback control / navigation interface with state restoration

      accent colors extracted from content

      server-driven UI

      offline data synchronisation with SQLite as database

      type-safe API request abstraction

      background tasks for app refresh

      mobile-first ux paradigms for user customization

      music playback through integration with Apple Music and Spotify player SDK

    • web client
      isomorphic progressive React app implemented in TypeScript

      type-safe API request abstraction with the ability to fulfill requests during server-side rendering

      streaming Apple Music and Spotify play history archive parsing and uploading

      share target support

    • back-end
      TypeScript / NodeJS monolith

      type-safe OpenAPI-specified HTTP API

      strategic use of streaming when delivering server-driven UI to achieve interactivity as soon as possible

      quality of service enforcement for third-party API calls with quotas

      server-side rendering of web client

      use of worker threads for computationally intinsive work

      sliding-window based push notification merging

      uses Redis for ephemeral data, PostgreSQL for anything long-lived, S3 for user content

      hosts Discord bot for interactive alerting

      Prometheus for monitoring

      in-process scheduler with support for multiple running instances

      snapshot testing of third-party API integrations

      periodically ingests RSS feeds for music-adjacent content

    • tooling

      MusicBrainz database PostgreSQL to SQLite conversion to fit fully into working memory for substantial speedup

  • operations

    Ansible playbooks to bootstrap k3s-flavoured Kubernetes

    monitoring with Grafana / Prometheus, alerting with Alertmanager

    backups with WAL-G

CYBERTEC Migrator2021 — 2022 • product engineer
browser-based Oracle Database to PostgreSQL migration environment
  • product design
    design and prototyping in Figma
    applied well understood text editor paradigms to database migration workflows
    envisioned custom controls tailored towards migration processes
  • testing infrastructure
    reduced test harness startup speed from multiple minutes to seconds on aging hardware
  • PostgreSQL parser integration
    compiled standalone parser implementation to WebAssembly to surface diagnostics in code editor
  • distribution infrastructure
    implemented cross-platform bootstrapper in Bash with support for online and offline upgrades
  • front-end / back-end tasks
    implemented features in TypeScript
Lichtensteiner Landesbank2020 — 2021 • consulting
  • partial Docker reimplementation
    built image packaging tooling in Python, and utilized systemd-nspawn as runtime, to comply with strict compliance criteria
  • data ingestion / transformation infrastructure
    implemented rule-based data transformation engine in Python to correct malformed data on-the-fly and import it into PostgreSQL for reporting purposes
Hims & Hers Health, Inc.2018 — 2020 • consulting
  • medical questionnaire builder
    with support for arbitratry branching, built in TypeScript and Kotlin
  • SMS-based doctor / patient communication
    integrated SMS-based messaging into electronic medical records system in PL/pgSQL
  • tooling
    migration verification tooling for database changes in Bash, structured database schema inspection in Rust, command line tools in Python to examine prescriptions
  • back-end tasks
    implemented features in Kotlin and PL/pgSQL
CYBERTEC PostgreSQL International GmbH2018—2022 • software engineer
  • system administration
    self-service tooling and operated internal services
HTBLuVA Wiener Neustadt2013 — 2018 • education
  • rocket lander prototype
    air pressure control loop daemon in Rust and Python with networked sensor data retrieval and browser-based visualization
  • robotics controller Linux distribution
    ported sofware and packaged Debian based distribution for bespoke robotics controller
other stuff
  • •
    nibbler
    proof of concept runtime Python bytecode optimizer that uses constraints supplied by existing syntax features such as type annotations and decorators to speed up code execution passes
Mastodon@philiptrauner@mastodon.socialPixelfed@philiptrauner@pixelfed.socialeq.fm@philip@eq.fmGitHub@philiptrauner@github.com