Database Administrator — SaaS Infrastructure (SG)

Longport Technology HK Limited; Santo Niño 1st; On-site; PHP 3,943,000 - 5,914,000; Full time

Job summary

Longport Technology HK Limited in Singapore seeks a Database Administrator — SaaS Infrastructure to own the data layer of our multi-region clusters (US/SG/JP), ensuring high availability, data consistency, and compliance.

You will operate, upgrade, backup, and monitor databases (PostgreSQL, MySQL, Redis) and help design multi-tenant solutions, with opportunities to grow into financial-grade data architecture.

Qualifications

• 3+ years of production DBA experience with PostgreSQL and/or MySQL.
• Experience with HA and backup/recovery solutions (replication, Patroni, MHA, Redis Sentinel).
• Solid performance tuning: slow-query analysis, indexing, execution plans.
• Experience with AWS RDS/Aurora and Multi-AZ deployment.
• Working English; Mandarin a plus.

Responsibilities

• Operate databases of multi-region SaaS clusters: deployment, upgrades, backup/recovery, monitoring, incidents.
• Design and deliver multi-tenant SaaS data solutions with tenant isolation and onboarding.
• Own multi-AZ high availability and DR drills across regions.
• Run capacity planning and performance tuning; participate in on-call incidents.
• Use tooling (Terraform, Bytebase) to automate market onboarding.
• Review schema designs and SQL; gate production changes with SRE.

Skills

PostgreSQL

MySQL

HA/Backup

Performance tuning

Cloud AWS

RDS/Aurora

Scripting (Python/Go/Shell)

Kubernetes

ClickHouse

TimescaleDB

Tools

Terraform

Bytebase

Job description

Database Administrator — SaaS Infrastructure (SG)

About the Role

Our databases power order management, market data, clearing and settlement, risk controls, and customer asset systems — with high demands on availability, data consistency, and multi-jurisdiction compliance. We are looking for a DBA to join our Singapore team and take ownership of the operations and build-out of the data layer of our multi-region SaaS clusters, with plenty of room to grow into financial-grade data architecture and multi-market compliance practices.

What You Will Do

1. Operate the databases of our multi-region (US/SG/JP) SaaS clusters day to day: deployment, upgrades, backup and recovery, monitoring and alerting, and incident handling — mainly PostgreSQL, MySQL, Redis, plus analytics engines such as ClickHouse.
2. Help design and deliver our multi-tenant SaaS data solutions: tenant isolation (dedicated instance / database / schema), automated tenant onboarding (provisioning, password rotation), and per-tenant backup and recovery.
3. Own multi-AZ high availability and DR drills within each region, meeting RPO/RTO targets for core systems.
4. Run capacity planning and performance tuning: slow-query governance, indexing and execution plans, connection pooling; participate in P0/P1 incident response and post-mortems.
5. Use and improve our database platform tooling (Terraform, Bytebase, self-service query tools) to make launching a new market or onboarding a new tenant increasingly automated.
6. Review schema designs and SQL with engineering teams, gate production changes, and share on-call duties with SRE.

What We Are Looking For

1. 3+ years of production DBA experience with PostgreSQL and/or MySQL, including independently handling live incidents.
2. Hands-on experience with mainstream HA and backup/recovery solutions (e.g., replication, Patroni, MHA, or Redis Sentinel), including real failover or recovery drills.
3. Solid performance tuning skills: slow-query analysis, index design, reading execution plans, diagnosing locking and connection-pool issues.
4. Working experience with AWS RDS/Aurora (or equivalent cloud databases), including Multi-AZ deployment and cloud backup/recovery patterns.
5. Working English: able to read and write documentation and join meetings in English; Mandarin is a plus.

Nice to Have

1. Financial industry experience — database operations at a broker, exchange, payments, or banking system; familiarity with order, market-data, or settlement data models is a bonus.
2. SaaS / multi-tenancy — involvement in designing or operating multi-tenant data platforms.
3. Larger-scale experience — systems with 100k+ QPS or TB+ data volumes.
4. Database internals — deep understanding of MVCC, transaction isolation, and replication; able to analyze issues at the protocol or source-code level.
5. Engineering skills — Python/Go/Shell scripting for ops tooling; Kubernetes experience.
6. Time-series / analytics — production experience with ClickHouse or TimescaleDB.