Staff PostgreSQL SRE - Remote, High-Scale Reliability

Multi Media LLC; Northern (KY); Hybrid; USD 195,000 - 228,000; Full time

Benefits offered by this job

Fully Remote Optional

Health Insurance

Vision Insurance

Dental Insurance

Life Insurance

Disability Insurance

Unlimited PTO

Year-end Company Closure

401k with 5% matching

12 Paid Holidays

Lunch stipend

Employee Assistance Program

Employee Recognition

Job summary

Multi Media, LLC is seeking a Staff Database Engineer to own the reliability, availability, and recoverability of Chaturbate's large PostgreSQL environment. You will operate across multiple production clusters with terabytes of data and billions of rows to ensure high performance and minimal downtime.

You will work within the Site Reliability Engineering team to prevent incidents, strengthen recovery capabilities, and improve backup/restore procedures.

Qualifications

• 10+ years operating PostgreSQL in large-scale production environments.
• Deep knowledge of PostgreSQL reliability, including replication, failover, backup, recovery, and high availability.
• Experience preventing, diagnosing, and resolving complex production database incidents.
• Experience planning and safely executing PostgreSQL upgrades, migrations, and maintenance.
• Strong understanding of PostgreSQL internals, including WAL, autovacuum, indexing, locking, query planning, and connection management.
• Experience supporting high-volume workloads, large data sets, or rapidly growing databases.
• Strong Linux knowledge and an understanding of how infrastructure affects database performance and reliability.
• Ability to automate operational work through scripting, configuration management, or infrastructure tooling.
• Experience building monitoring, alerting, runbooks, and reliable incident-response practices.
• Strong communication and judgment, with the ability to work effectively across SRE and product engineering teams.

Responsibilities

• Own the day-to-day reliability and operational health of Chaturbate’s PostgreSQL environment.
• Identify and proactively address database reliability, performance, and scalability risks before they impact production.
• Improve high availability, replication, backup, restore, and disaster recovery capabilities.
• Lead the response to database incidents and implement improvements that prevent recurrence.
• Plan and execute PostgreSQL upgrades, migrations, and maintenance with minimal service disruption.
• Monitor and tune database performance across high-volume, latency-sensitive, high-write workloads.
• Build better observability, alerting, automation, and operational runbooks in partnership with SRE.
• Plan for continued growth in data volume, storage, compute, WAL generation, replication bandwidth and latency needs.
• Review database architecture for new products and significant engineering changes, providing guidance on schema design, queries, migrations, scalability, and operational risk.
• Develop operational standards, automation, and best practices for PostgreSQL across the engineering organization.
• Document the environment and help SRE engineers build stronger PostgreSQL knowledge.
• Participate in an on-call rotation for critical database incidents.
• Analyze query execution plans, indexing strategy, autovacuum behavior, table bloat, checkpoint tuning, and storage efficiency for multi-terabyte database clusters.

Skills

PostgreSQL reliability

Replication & failover

High availability

Incident response

Upgrades & migrations

Linux proficiency

Automation scripting

Monitoring & alerting

Cross-functional collaboration

Query planning

Tools

Patroni

PgBouncer

Terraform

Ansible

Job description

Multi Media, LLC is seeking a Staff Database Engineer to own the reliability, availability, and recoverability of Chaturbate's large PostgreSQL environment. You will operate across multiple production clusters with terabytes of data and billions of rows to ensure high performance and minimal downtime.

You will work within the Site Reliability Engineering team to prevent incidents, strengthen recovery capabilities, and improve backup/restore procedures.