DATABASE ADMINISTRATOR

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

Responsible for the availability, performance, security, andintegrity of the system’s production and non-production databases, primarilyIBM Db2 and PostgreSQL. Supports application teams, infrastructure teams, andvendors to ensure databases are stable, recoverable, and meet agreed SLAs.

Key Responsibilities:

Administration & Operations

• Install, configure, upgrade, and patch Db2 and PostgreSQLinstances (on-premises, VM, or cloud, e.g. AWS RDS/Aurora PostgreSQL)
• Monitor database health, capacity, and performance, and acton alerts
• Manage users, roles, privileges, and access controls
• Perform routine maintenance such as reorg, runstats, vacuum,reindexing, and storage management
• Support L2/L3 incidents and problem management, includingroot cause analysis

Performance & Optimisation

• Analyse and tune slow queries, indexes, execution plans, andconfiguration parameters
• Work with developers on schema design, query optimisation,and data model changes
• Plan capacity and recommend scaling or archiving strategies

Security & Compliance

• Apply database hardening, encryption (at rest and intransit), and audit logging
• Remediate database vulnerabilities and apply securitypatches per policy
• Support audits and provide evidence for compliancerequirements

Change, Release & Migration

• Review and execute database changes and deployments throughchange management
• Support data migration, version upgrades, and cloudmigration activities
• Maintain runbooks, standard operating procedures, anddatabase documentation

Vendor & Stakeholder Coordination

• Coordinate with vendors (e.g. IBM) on support cases andlicensing
• Report on database performance, availability, and capacityin service reviews

Qualifications:

• Diploma or Bachelor’s degree in IT, Computer Science, or arelated field (or equivalent experience)
• 4-7 years of hands-on DBA experience in productionenvironments
• Strong experience with both IBM Db2 (LUW) and PostgreSQL
• Proven experience in backup and recovery, replication,HA/DR, and performance tuning
• Experience with Linux (RHEL preferred) and shell scripting
• Preferred certifications: IBM Certified DatabaseAdministrator (Db2), PostgreSQL certification (e.g. EDB), AWS CertifiedDatabase Specialty, ITIL 4 Foundation

Skills:

• Strong SQL skills and database internals knowledge
• Scripting and automation (Bash, Python, Ansible) for routinetasks
• Familiarity with monitoring tools (e.g. Prometheus, Grafana,CloudWatch, pgAdmin, Db2 monitoring tools)
• Working knowledge of cloud platforms (AWS) and containerisedenvironments
• Familiarity with ITSM tools (e.g. ServiceNow) and changemanagement processes
• Strong troubleshooting skills, attention to detail, andclear communication
• Calm and effective under pressure during incidents