Langsung ke konten utama
Kembali ke Lowongan

Senior Database Administrator (PostgreSQL)

  • Gaji tidak dicantumkan
  • Diposting bulan lalu · lewat Lever

Tingkatkan kinerja database trading dan analitik BTSE dengan PostgreSQL

Anda akan mengelola dan memantau database PostgreSQL di AWS untuk memastikan kinerja optimal dan uptime tinggi. Bertanggung jawab untuk merancang, mengotomatisasi, dan memelihara kluster PostgreSQL yang handal. Kerja sama dengan tim SRE, DevOps, dan engineering untuk meningkatkan skalabilitas dan integrasi CI/CD.

Kenapa Menarik?

Mengelola dan memantau sistem database PostgreSQL yang beroperasi 24/7 untuk lebih dari 100 klien korporat di seluruh dunia.

Tanggung Jawab Utama

  • Mengembangkan otomatisasi untuk pengaturan, konfigurasi, dan pemantauan database PostgreSQL
  • Melakukan pemeliharaan rutin database seperti vacuuming, reindexing, dan analisis statistik
  • Mengidentifikasi dan mengoptimalkan kueri SQL lambat untuk meningkatkan efisiensi
  • Membangun arsitektur database yang tahan lama dan memiliki ketersediaan tinggi
  • Mengimplementasikan strategi backup, pemulihan, dan pemulihan bencana untuk menjamin integritas data
  • Memantau sistem produksi 24/7 dan berpartisipasi dalam tanggapan insiden

Persyaratan

  • Pengalaman 4+ tahun dalam mengelola database PostgreSQL di lingkungan produksi
  • Kemampuan dalam optimasi kueri SQL dan strategi indexing
  • Pengalaman dalam merancang sistem yang tahan lama dan fault-tolerant

Skills Wajib

postgresqlawssqldatabase managementautomationinfrastructure as code

Konteks Indonesia

Overlap Jam Kerja:
Fleksibel — atur jam kerjamu sendiri
Lihat selisih gaji remote (USD) vs lokal →
Lihat Deskripsi Asli dari Lever PostingsTampilkan selengkapnya

Deskripsi asli dari Lever Postings

About BTSE:   BTSE Group is a global leader in fintech and blockchain technology, anchored by three core business pillars: Exchange, Payments, and Infrastructure Development. Serving over 100 corporate clients worldwide, we provide white-label exchange and payment solutions. Our offerings encompass everything from exchange infrastructure hosting and development to custody, wallets, payments, blockchain integration, trading, and more. We are looking for talented professionals in marketing, operations, customer support, and other departments. The roles offered may be on-site, remote, or hybrid, in collaboration with our local partner.   About the Opportunity:   We are looking for an experienced Database Administrator with deep PostgreSQL expertise and hands-on experience automating database deployment, monitoring, and performance tuning on Data Center  and AWS. You will be part of the core infrastructure team responsible for scaling and maintaining BTSE’s mission-critical database systems that power our trading and analytics platforms. This role offers the opportunity to design, automate, and optimize high-availability PostgreSQL clusters while ensuring reliability, minimal downtime, and strong observability across production environments operating 24/7. Responsibilities 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. Requirement 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 Haves Familiarity with observability and alerting stacks (Prometheus, Loki, Grafana, CloudWatch). Exposure to additional database systems such as ClickHouse or TimeScale Postgres. Experience building internal automation or self-healing tools for query analysis and database management. Perks & Benefits Competitive total compensation package Various team-building programs and company events And many more! Apply and let us tell you more! #LI-PP1

Kurang cocok? Lowongan serupa yang sedang buka

Lihat 5 lowongan serupa →

Pemberi kerja tidak menyatakan keterbukaan lokasi — cek langsung lowongannya

Perusahaan
BTSE
Gaji
Tipe Lowongan
Purna waktu
Lokasi
Remote · Countries not stated
Kategori
Level
Senior
DipostingTerakhir dicek 6 hari lalu
17 Sep 2026

Bagikan lowongan ini

Bantu temanmu nemu kerja remote berikutnya.

Merekrut? Cari talenta gratis

Jelajahi lebih lanjut

Data & laporan pasar

Riset gaji & permintaan skill dari data lowongan kami sendiri.