Senior Database Administrator (PostgreSQL)

Job description

**About BTSE:** 彼特思方舟 is a specialized service provider dedicated to delivering a full spectrum of front-office and back-office support solutions, each of which are tailored to the unique needs of global financial technology firms. 彼特思方舟 is engaged by BTSE Group to offer several key positions, enabling the delivery of cutting-edge technology and tailored solutions that meet the evolving demands of the fintech industry in a competitive global market. **BTSE Group** is a leading global fintech and blockchain company that is committed to building innovative technology and infrastructure. BTSE empowers businesses and corporate clients with the advanced tools they need to excel in a rapidly evolving and competitive market. BTSE has pioneered numerous trading technologies that have been widely adopted across the industry, setting new benchmarks for innovation, performance, and security in fintech. BTSE’s diverse business lines serve both retail (B2C) customers and institutional (B2B) clients, enabling them to launch, operate, and scale fintech businesses. BTSE is seeking ambitious, motivated professionals to join our B2C and B2B teams. **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!