Back to search

Database Administrator

Singapore Permanent SG$10,000 - SG$12,000 per month (SG$120,000 - SG$144,000 per year) Work from Home or Hybrid View Job Description
This role is responsible for managing large-scale PostgreSQL environments, including installation, upgrades, high-ingestion workloads, performance tuning, backup/restore, replication, and disaster recovery.
  • 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

Job summary

Function
IT
Specialisation
IT Data Analysis
What is your area of specialisation?
Technology & Telecoms
Location
Singapore
Contract Type
Permanent
Consultant name
Jayden Yap (Lic No: R22110369/ EA no: 18C9065)
Consultant contact
+65 6416 9897
Job Reference
JN-022026-6957121
Work from Home
Work from Home or Hybrid

Diversity & Inclusion at Michael Page

We don't just accept difference - we celebrate it. We encourage applicants from all backgrounds to apply for this role and are committed to building inclusive, diverse workplaces where everyone can thrive. If you require any support or reasonable adjustments during the recruitment process, please let us know.