Senior Database Administrator (PostgreSQL)

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!
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

Work arrangement
Yes