OpenTable

Senior PostgreSQL Database Engineer (Hybrid)

OpenTable
Apply
9 days ago
Toronto, CanadaSenior

Responsibilities

  • Lead the design, architecture, and lifecycle management of PostgreSQL environments for high availability, disaster recovery, and scalable performance.
  • Automate database provisioning, major-version upgrades, monitoring, and credential rotation.
  • Partner with Product and Data Engineering teams on database design, schema optimization, query performance, and safe migrations.
  • Drive multi-region cloud database strategy while balancing performance, security, cost, and operational excellence.
  • Serve as a senior escalation point during production incidents, perform root-cause analysis, and implement reliability improvements.
  • Mentor engineers, document reusable operational patterns, and raise technical standards across teams.

Requirements

  • At least 7 years of experience administering, engineering, and operating PostgreSQL or equivalent complex database systems in production.
  • Deep knowledge of PostgreSQL architecture and internals, including query planning, locking, write-ahead logging, replication, vacuuming, and connection management.
  • Experience designing, implementing, and operating high-availability, disaster-recovery, and failover solutions for critical database infrastructure.
  • Proficiency in SQL and at least one programming or automation language such as Python, Go, or Bash.
  • Hands-on experience building database automation with infrastructure-as-code or configuration management tools.
  • Preferred experience with PostgreSQL on public cloud platforms, Kubernetes, or containerized environments.
  • Preferred experience with Grafana, Prometheus, OpenTelemetry, Redis, MongoDB, OpenSearch, or distributed databases.
  • Preferred experience improving developer productivity through self-service database provisioning and platform automation.

Benefits

  • Hybrid Toronto work arrangement with an expectation of working in the office two days per week.
  • Work from almost anywhere for up to 20 days per year.
  • Company-paid therapy sessions through SpringHealth and a company-paid Headspace subscription.
  • Annual company-wide week off, paid parental leave, paid vacation, birthday time off, paid volunteer time, and 20 days of paid time off.
  • Development Dollars, leadership development, and access to thousands of on-demand e-learning courses.
  • Travel discounts, employee resource groups, private health and dental insurance, life and disability insurance, and retirement benefits.

Tech Stack

BashGoGrafanaKubernetesMongoDBPostgreSQLPrometheusPythonRedisSQL

Categories

OpenTable

About OpenTable

1,001-5,000 employees
Contact me