Database Reliability Engineer — SaaS Infrastructure (SG)

Longport Technology HK Limited; Singapore; In loco; SGD 90.000 - 140.000; Tempo pieno

Descrizione del lavoro

Longport Technology HK Limited seeks a Database Reliability Engineer to own the operations and scaling of multi-region SaaS databases in Singapore. You will ensure high availability, data integrity, and efficient query performance across PostgreSQL, MySQL, Redis, and analytics engines.

In this hands-on role, you design and implement HA/DR drills, optimize capacity, review schemas, and automate provisioning with Terraform and related tooling while collaborating with SRE and engineering teams in

Competenze

• 3+ years of production DBA experience with PostgreSQL and/or MySQL.
• Experience with HA and backup/recovery solutions (e.g., Patroni, MHA, Redis Sentinel).
• Hands-on knowledge of cloud databases (AWS RDS/Aurora) including Multi-AZ deployments.
• Ability to read and write English documentation and participate in meetings.
• Familiarity with multi-region SaaS data platforms and tenant isolation is a plus.

Mansioni

• Operate the databases of our multi-region SaaS clusters day to day: deployment, upgrades, backup and recovery, monitoring and alerting, and incident handling.
• Help design and deliver multi-tenant SaaS data solutions: tenant isolation (dedicated instance / database / schema), automated tenant onboarding (provisioning, password rotation), and per-tenant backup and recovery.
• Own multi-AZ high availability and DR drills within each region, meeting RPO/RTO targets for core systems.
• Run capacity planning and performance tuning: slow-query governance, indexing and execution plans, connection pooling; participate in P0/P1 incident response and post-mortems.
• 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.
• Review schema designs and SQL with engineering teams, gate production changes, and share on-call duties with SRE.

Conoscenze

PostgreSQL

MySQL

HA/backup recovery

AWS RDS/Aurora

English communication

Strumenti

Terraform

Bytebase

SaaS data platforms

ClickHouse

Kubernetes

Descrizione del lavoro

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.