Db2 & PostgreSQL Database Administrator (On-Prem/Cloud)

OPUS IT Services Pte Ltd; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

OPUS IT Services Pte Ltd seeks an experienced DBA to ensure the availability, performance, security, and integrity of production and non-production databases, primarily IBM Db2 and PostgreSQL. You will support application and infrastructure teams, manage backups, and lead change and migration activities.

You will monitor health, tune performance, and implement security measures while working with vendors and internal stakeholders to meet SLAs in a global, hybrid environment.

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 IBM Db2 (LUW) and PostgreSQL.
• Backup and recovery, replication, HA/DR, and performance tuning experience.
• Linux (RHEL preferred) experience and shell scripting.
• Preferred certifications: IBM Db2 DBA, PostgreSQL certs, AWS Certified Database, ITIL 4 Foundation.

Responsibilities

• Administration & Operations: Install, configure, upgrade, patch Db2 and PostgreSQL on-prem, VM or cloud.
• Monitor health, capacity, performance; act on alerts.
• Manage users, roles, access controls.
• Routine maintenance: reorg, runstats, vacuum, reindexing, storage.
• Support L2/L3 incidents and problem management including root cause analysis.
• Performance & Optimisation: Analyse slow queries, indexes, execution plans.
• Work with developers on schema design and data model changes.
• Plan capacity; recommend scaling/archiving strategies.
• Security & Compliance: Apply hardening, encryption, audit logging; remediate vulnerabilities.
• Change, Release & Migration: Review and deploy DB changes; support migrations.
• Vendor & Stakeholder Coordination: Coordinate with IBM and report performance in reviews.

Skills

SQL expertise

Shell scripting

Monitoring & alerting

Cloud & container knowledge

ITSM & change mgmt

Troubleshooting & communication

Incident management

Education

Diploma or Bachelor’s degree in IT/CS

Tools

IBM Db2 (LUW)

PostgreSQL

Prometheus

Grafana

CloudWatch

pgAdmin

Job description

OPUS IT Services Pte Ltd seeks an experienced DBA to ensure the availability, performance, security, and integrity of production and non-production databases, primarily IBM Db2 and PostgreSQL. You will support application and infrastructure teams, manage backups, and lead change and migration activities.

You will monitor health, tune performance, and implement security measures while working with vendors and internal stakeholders to meet SLAs in a global, hybrid environment.