Senior Database Administrator, PostgreSQL

• Design, deploy, and maintain PostgreSQL clusters in AWS environments using Infrastructure as Code (IaC) tools
• Develop automation for provisioning, configuration management, and monitoring of PostgreSQL databases
• Perform regular database maintenance including vacuuming, reindexing, and analyzing statistics to ensure peak performance
• Identify, analyze, and optimize slow SQL queries and workloads to improve efficiency and throughput
• Build resilient, high-availability database architectures that minimize downtime during upgrades, maintenance, and failovers
• Implement robust backup, recovery, and disaster recovery strategies to guarantee data integrity and uptime
• Support and monitor 24/7 production systems, participating in incident response and root cause analysis when needed
• Collaborate with SRE, DevOps, and engineering teams to improve scalability, performance, and CI/CD integration for database operations
• Maintain and optimize BTSE’s mission-critical database systems powering trading and analytics platforms

• 4+ years of experience managing PostgreSQL databases in production environments
• Strong knowledge of SQL query optimization, indexing strategies, and PostgreSQL performance tuning
• Proven ability to design and maintain highly available, fault-tolerant systems with minimal or zero downtime
• Experience supporting mission-critical 24/7 systems in production, with on-call or incident response participation
• Hands-on experience with AWS services such as EC2, RDS, EBS, S3, and IAM
• Solid understanding of PostgreSQL replication, PITR (Point-in-Time Recovery), and HA solutions (Repmgr, Patroni, ProxySQL, or similar)
• Experience automating infrastructure using Terraform, Ansible, or similar tools
• Proficiency in Linux systems administration and scripting (Bash, Python, or Go)
• Nice to have: Familiarity with observability and alerting stacks (Prometheus, Loki, Grafana, CloudWatch)
• Nice to have: Exposure to additional database systems such as ClickHouse or TimeScale Postgres
• Nice to have: Experience building internal automation or self-healing tools for query analysis and database management

• Competitive total compensation package
• Various team-building programs and company events