Database Administrator

• Working in a emerging startup with breakthrough technologies
• Involved in end-to-end solutions

About Our Client

An innovation‑driven technology lab building end‑to‑end, solutions that empower utilities with reliable, secure, and data‑driven energy distribution. Its AI‑enabled applications for meter reading, workforce management, and harmonics analysis are emerging as transformative tools for major utilities worldwide.

Job Description

• Manage PostgreSQL clusters end‑to‑end: deployment, configuration, patching, maintenance, and automation.
• Ensure high‑volume data ingestion (100-250GB/day) and reliable ETL/streaming workflows.
• Implement robust backup, recovery, and disaster‑recovery workflows (pgBackRest, WAL‑G, PITR, failover tests).
• Maintain performance and health through VACUUM operations, autovacuum tuning, bloat cleanup, and resource optimization (I/O, memory, WAL).
• Optimize SQL and database architecture, support developers, and design partitioning and indexing strategies.
• Handle large datasets (1TB-2TB+) with pruning, compression, archival, and tiered storage automation.
• Configure replication, PgBouncer connection pooling, HA setups, and continuous monitoring via Grafana/Prometheus.
• Respond to incidents, conduct RCAs, and implement preventive improvements.
• Integrate database provisioning and migration workflows into CI/CD using Ansible, Terraform, Helm, Flyway/Liquibase.
• Enforce strong security practices, logging, auditing, and compliance controls.

The Successful Applicant

• Extensive hands‑on experience working with PostgreSQL as the primary database.
• Background in both SQL and NoSQL database technologies.
• Strong proficiency in query optimization, indexing techniques, partitioning methods (time‑based, range, list), MVCC, WAL mechanisms, replication and failover processes, PITR, backup strategies, and logging
• Solid Linux system administration and shell scripting capabilities.
• Experience handling high‑volume data ingestion (around 250GB/day) and managing long‑term rolling datasets.
• Familiarity with cloud‑hosted PostgreSQL services such as AWS RDS/Aurora and Azure Database for PostgreSQL.
• Practical experience with monitoring and observability tools like Prometheus, Grafana, ELK, and SigNoz.

What's on Offer

Working in an emerging startup wiht breakthrough tehcnologies

Involved in end-to-end solutions

Contact

Jayden Yap (Lic No: R22110369/ EA no: 18C9065)

Quote job ref

JN-022026-6957121

Phone number

+65 6416 9897