Database Administrator

Remote

May 16, 2025

Full Time

Application ends: August 16, 2025

Job Description

About the Role

We’re looking for a hands-on Database Administrator who thrives in high-transaction, low-latency environments. You won’t just maintain databases—you’ll own performance tuning, deep-dive into query plans, and proactively prevent outages in systems that process millions of records daily. If you’re the kind of person who monitors cache hit ratios for fun or writes automation scripts before opening a ticket, we want to hear from you.

Key Responsibilities

Query Optimization: Work closely with backend engineers to review and optimize complex SQL queries (PostgreSQL/MySQL), ensuring sub-second response times in production.
Monitoring & Alerting: Implement fine-grained monitoring (e.g., pg_stat_statements, Prometheus/Grafana) to detect anomalies before they become incidents.
Index Strategy: Design, audit, and revise indexing strategies; eliminate redundant indexes, and implement partial or expression indexes where needed.
Replication & High Availability: Maintain and troubleshoot streaming replication, failover, and backup mechanisms (e.g., Patroni, WAL-G, or native MySQL replication).
Schema Management: Collaborate with developers on schema design and migrations using tools like Flyway or Liquibase; enforce version control for database changes.
Disaster Recovery: Own and periodically test backup/recovery plans; be ready to perform point-in-time recovery without hand-holding.
Security: Enforce principle of least privilege across DB roles; audit access logs and be fluent in encryption-at-rest and in-transit configurations.
Capacity Planning: Forecast storage and compute needs; recommend partitioning, archiving strategies, or vertical scaling where appropriate.
Automation: Build and maintain scripts (Python/Bash/Ansible) for repetitive tasks like user provisioning, backups, and log rotation.

Required Skills & Experience

5+ years managing PostgreSQL or MySQL in a production environment with 24/7 uptime expectations
Deep understanding of RDBMS internals: VACUUM, WALs, buffer management, query execution plans
Experience in tuning for OLTP workloads (not just OLAP/reporting)
Proficiency in scripting for automation and troubleshooting (e.g., Bash, Python)
Experience with cloud-native database operations (e.g., AWS RDS, Aurora, or self-managed on EC2)
Familiarity with CI/CD pipelines involving database migrations
Strong grasp of Linux systems and networking as it relates to DB performance

Nice to Have (Not Required)

Experience with TimescaleDB or other time-series extensions
Prior work with hybrid (relational + document) database setups
Familiarity with Terraform, Kubernetes, or DBaaS orchestration
Contributions to open-source DB tools or plugins

Are you interested in this position?

Apply by clicking on the “Apply Now” button below!