Senior Database Administrator
at Jobr
Singapore, remote, senior, 4+ years
seen 46d ago
- S3
- ProxySQL
- Infrastructure as Code
- PostgreSQL
- Go
- Prometheus
- Repmgr
- Grafana
- Terraform
- EC2
- EBS
- AWS
- Python
- RDS
- TimeScale Postgres
- Loki
- ClickHouse
- Patroni
- Bash
- SQL
- IAM
- Linux
- CloudWatch
- Ansible
About the role
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 DGTL'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.
What you would do
* 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.
What they are looking for
* 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).
Read from jobr.pro, last seen 4d ago.