Database Reliability Engineer: Db2 & PostgreSQL Specialist

TROYTECH INTERNATIONAL CONSULTING PTE LTD; Singapore; Sur place; SGD 90 000 - 130 000; Plein temps

Résumé du poste

TROYTECH INTERNATIONAL CONSULTING PTE LTD is seeking an experienced Database Administrator to ensure the availability, performance, security, and integrity of IBM Db2 and PostgreSQL databases in production and non-production environments. You will collaborate with application, infrastructure teams, and vendors to maintain stable databases that meet SLAs.

You will install, configure, monitor, and optimize Db2 and PostgreSQL across on‑prem, virtual, and cloud platforms, with a strong focus on

Qualifications

• Diploma or Bachelor's degree in IT, Computer Science, or a related field (or equivalent experience)
• 4-7 years of hands-on DBA experience in production environments
• Strong experience with both IBM Db2 (LUW) and PostgreSQL
• Proven experience in backup/recovery, replication, HA/DR, and performance tuning
• Experience with Linux (RHEL preferred) and shell scripting
• Preferred certifications: IBM Certified Database Administrator (Db2), PostgreSQL certification, AWS Certified Database Specialty, ITIL 4 Foundation

Responsabilités

• Install, configure, upgrade, and patch Db2 and PostgreSQL across on-prem, virtual, and cloud platforms (AWS RDS/Aurora)
• Monitor database health, capacity, and performance; respond to alerts to maintain stability
• Manage database users, roles, privileges, and access controls
• Perform routine maintenance: reorganization, statistics updates, vacuuming, reindexing, storage management
• Support L2/L3 incident resolution and root cause analysis
• Analyze and tune slow queries, indexes, and execution plans
• Collaborate with developers on schema design and data model adjustments
• Plan capacity and recommend scaling or archiving strategies
• Apply security measures: encryption, audit logging, hardening; patch vulnerabilities
• Support audit processes with documentation and evidence
• Review and execute database changes following change control
• Support data migrations and cloud migrations
• Maintain runbooks and comprehensive documentation
• Coordinate with vendors (IBM) on support/licensing
• Report performance/availability metrics during service reviews

Connaissances

SQL proficiency

DB2 LUW

PostgreSQL

Shell scripting

Cloud familiarity

Monitoring tools

Formation

Bachelor's degree in IT/CS

Diploma in IT

Outils

IBM Db2 monitoring tools

Prometheus/Grafana

AWS CloudWatch

pgAdmin

Description du poste

TROYTECH INTERNATIONAL CONSULTING PTE LTD is seeking an experienced Database Administrator to ensure the availability, performance, security, and integrity of IBM Db2 and PostgreSQL databases in production and non-production environments. You will collaborate with application, infrastructure teams, and vendors to maintain stable databases that meet SLAs.

You will install, configure, monitor, and optimize Db2 and PostgreSQL across on‑prem, virtual, and cloud platforms, with a strong focus on