Senior PostgreSQL Database Administrator / Database Engineer

tastylive; Chicago (IL); Hybrid; USD 150,000 - 180,000; Full time

Benefits offered by this job

Performance Bonuses

Stock Purchase Options

401k Plan

Paid Vacation Days

Paid Sick Days

Pet Insurance

Wellness & Mental Health Programs

Charitable Donation Matching

Daily catered lunch when in the office

Full kitchen with snacks and beverages

Shuttle to/from Metra

Job summary

tastylive in Chicago seeks a Senior PostgreSQL Database Administrator/Database Engineer to own health, performance, and durability of high-throughput Postgres clusters on bare metal, VMs, and AWS RDS. This hands-on role involves query analysis, index tuning, failover drills, code reviews, and thorough documentation.

You will manage Patroni-based clusters, backups with pgBackRest/Barman, cross-environment operation, and major migrations with minimal downtime, while contributing to incident

Qualifications

• Deep PostgreSQL expertise with the query planner and EXPLAIN analysis.
• Hands-on indexing across B-tree, GIN, GiST, BRIN, and covering/indexing concepts.
• Experience with Patroni-managed clusters and real failover scenarios.
• Ownership of backup/restore programs (pgBackRest, Barman) including production restores.
• Experience operating Postgres at scale in self-managed and AWS RDS environments.
• Strong Linux fundamentals and performance tooling.

Responsibilities

• Own performance for high-volume OLTP Postgres workloads and tuning.
• Design, deploy, and operate highly available clusters with Patroni and regular testing.
• Manage backup and recovery end-to-end with verification of RTO/RPO.
• Handle Postgres in on‑prem and Amazon RDS environments and migrations.
• Plan major version upgrades and large migrations with minimal downtime.
• Review application code and migrations in Ruby and Java for N+1 queries and unsafe DDL.
• Build observability: metrics, slow queries, lock analysis, capacity forecasting.
• Automate routine operations; contribute to runbooks and docs.
• Lead on-call incident response and postmortems to prevent recurrence.
• Create developer-facing guidance and upgrade playbooks.

Skills

PostgreSQL expertise

Query planner

Indexing strategies

Replication

Patroni

Backups

Linux basics

Ruby & Java

Documentation

Incident response

Tools

Patroni

pgBackRest

Barman

Job description

Location: Chicago, IL — Hybrid

About the Role

As a Senior PostgreSQL Database Administrator / Database Engineer, you'll own the health, performance, and durability of high-throughput Postgres clusters running both on bare metal / on-prem VMs and on Amazon RDS. This is a hands‑on role: you will read query plans, tune indexes, run failover drills, review application code, and write high-quality documentation.

This is not a ticket‑queue DBA position. You will work inside the development process — reviewing migrations before they ship, pairing with application teams on data access patterns, assisting with performance troubleshooting, and contributing to incident resolution and process improvement.

What You'll Do:

• Own performance for high-volume OLTP Postgres workloads: query plan analysis, index strategy, statistics and autovacuum tuning, connection pooling, partitioning, and schema design review.
• Design, deploy, and operate highly available clusters using Patroni, including replication topology, failover and switchover procedures, and regular testing.
• Own the backup and recovery program end to end — backup tooling, retention, PITR, and, most importantly, routine restore verification with documented RTO/RPO.
• Manage Postgres in both on‑prem and Amazon RDS for PostgreSQL environments, including the operational differences between them (parameter groups, extension availability, failover behavior, upgrade paths).
• Plan and execute major‑version upgrades and large migrations with minimal downtime.
• Review application code and database migrations written in Ruby (Rails/ActiveRecord) and Java (JDBC), catching N+1 queries, unsafe DDL, missing indexes, and lock‑taking migrations before they reach production.
• Build and maintain observability for the database tier: metrics, slow query capture, lock and wait‑event analysis, and capacity forecasting.
• Automate routine operations. Manual runbooks are a starting point, not a destination.
• Participate in an on‑call rotation: lead incident response, write postmortems, and file follow‑up tickets to prevent recurrence.
• Write and maintain internal documentation: runbooks, architecture decision records, upgrade playbooks, and developer‑facing guidance on using Postgres well.
• Assist in sizing and future scaling of on‑prem server hardware.
• Participate in disaster recovery planning and exercises.

Who You Are:

• You have deep PostgreSQL expertise with the query planner — you can read EXPLAIN (ANALYZE, BUFFERS) output and explain why the planner chose a plan, not just that it was slow.
• You have hands‑on indexing strategy experience across B-tree, GIN, GiST, BRIN, partial, expression, and covering indexes, including the write‑amplification cost of each.
• You understand replication — physical and logical replication, replication slots, lag diagnosis, and the failure modes of each.
• You must have production experience with Patroni‑managed clusters, including having handled a real failover.
• You must have proven ownership of a backup and restore program (pgBackRest, Barman) — including having performed a production restore under pressure.
• You have experience operating Postgres at meaningful scale in both self‑managed (on‑prem/VM/bare metal) and managed RDS environments.
• You must have strong Linux fundamentals: filesystem and I/O behavior, memory and hugepages, systemd, networking, and performance tooling.
• You have a software development background: creating, reviewing, and merging pull requests as part of a mandatory peer review process, and writing runbooks and design documentation.
• You have working proficiency in Ruby and Java, with enough Python literacy to read, review, and modify it confidently.
• You must be an excellent written communicator. Clear incident summaries, review comments, and design proposals are a core part of this job, not an afterthought.
• You have excellent documentation practice — a demonstrated habit of leaving systems better documented than you found them.

Preferred Qualifications:

• Experience with connection poolers (PgBouncer) at scale.
• Infrastructure‑as‑code and configuration management (Terraform, Ansible, SaltStack, Puppet, etc).
• Experience with logical replication‑based zero‑downtime migrations.
• Contributions to Postgres or its ecosystem tooling.
• Familiarity with our internal tooling, including [gascan].

Company Perks + Benefits:

• Performance Bonuses
• Stock Purchase Options
• 401k Plan
• 20 Paid Vacation Days (plus anadditionalpaid vacationdaythe month of your birthday!)
• 10 Paid Sick Days
• Pet Insurance
• Wellness & Mental Health Programs
• Charitable Donation Matching
• Daily catered lunch when in the office
• Full kitchen with snacks and beverages
• Shuttle to/from Metra

Base Salary Range:$150,000-$180,000 The actual salary offered will be based on the candidate's level of experience and qualifications.

Discretionary Performance Bonus: 8-12% of base salary based on individual and company performance.

About IGNA+ tasty
IG North America is home to tastytrade,tastylive &tastyfx—a family of brands built to democratize trading and empower individual investors. Founded in Chicago by the creators ofthinkorswim,acquiredby London-based IG Group in 2021, we combine startup innovation with the backing ofaFTSE 100 fintechoperatingacross five continents serving over 1.3m customers and handling billions of dollars in transactions – built on scale, trust, and proof.

From our headquarters in Chicago's Fulton Market, our team builds award-winning trading platforms, produces live financial education content daily, and creates technology that makes complex markets accessible. tastytrade is our retail brokerage for self-directed investing and trading, withtastylive providing content to educate our customers. tastyfx is the fastest-growing forex broker in the US.tastycryptoprovides self-custody digital wallets for decentralized finance.

We'rea lean, collaborative team that values autonomy, pragmatism, and impact. Whetheryou'rebuilding technology, creating content, serving customers, or supporting operations,you'llwork alongside people who are passionate about disrupting traditional finance and genuinely care about helping traders succeed. Our culture rewards initiative, embraces experimentation, and measures success by the value we create for our users.The bar is high – bring a curious and forward-thinkingmindsetandwe'llgive you the platform to define what comes next. Join us at IG|tasty – the future gets built here.
Location:Our office is in the West Loop - Chicago's growing center of tech, great cuisine, and high-end bars.

*Don't meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they have every single qualification. Our team is dedicated to building a diverse, inclusive, and authentic workplace, so ifyou’reexcited about thisrole,but your experiencedoesn’talign perfectly, we encourage you to apply anyway. You may be just the right candidate for this or other roles!