Database Reliability Engineer — SaaS Infrastructure (SG)

Longport Technology HK Limited; Santo Niño 1st; On-site; PHP 6,285,000 - 9,428,000; Full time

Job summary

Longport Technology HK Limited is seeking a Database Reliability Engineer to own the data layer for multi-region SaaS deployments (US/SG/JP). The role focuses on operational DBA tasks, high availability, and scalable multi-tenant data solutions within a regulated environment.

You will work with PostgreSQL/MySQL/Redis/ClickHouse, design tenant isolation, and automate provisioning and backups. English communication is required; Mandarin is a plus.

Qualifications

• 3+ years of production DBA experience with PostgreSQL and/or MySQL.
• Hands-on experience with high-availability and backup/recovery solutions.
• Strong performance tuning and query optimization skills.
• Experience with AWS RDS/Aurora and multi-AZ deployments.
• Proficient English; Mandarin a plus.

Responsibilities

• Operate databases across US/SG/JP SaaS clusters daily (PostgreSQL, MySQL, Redis, ClickHouse).
• Design multi-tenant SaaS data solutions and tenant onboarding.
• Own multi-AZ HA and DR drills meeting RPO/RTO targets.
• Perform capacity planning and tuning; assist in incident response.
• Improve tooling with Terraform, Bytebase, and self-service query tools.
• Review schema designs and gate production changes with SRE.

Skills

PostgreSQL / MySQL expertise

Incident response

Performance tuning

English communication

Tools

PostgreSQL

MySQL

Redis

ClickHouse

Terraform

Kubernetes

AWS RDS/Aurora

Job description

Database Reliability Engineer - 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.