Database Administrator (DBA)

TROYTECH INTERNATIONAL CONSULTING PTE LTD; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

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

Responsibilities

• 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

Skills

SQL proficiency

DB2 LUW

PostgreSQL

Shell scripting

Cloud familiarity

Monitoring tools

Education

Bachelor's degree in IT/CS

Diploma in IT

Tools

IBM Db2 monitoring tools

Prometheus/Grafana

AWS CloudWatch

pgAdmin

Job description

Job Summary

Responsible for ensuring the availability, performance, security, and integrity of IBM Db2 and PostgreSQL databases in production and non-production environments. Collaborate with application, infrastructure teams, and vendors to maintain stable, recoverable databases that meet SLAs.

Responsibilities

• Install, configure, upgrade, and patch IBM Db2 and PostgreSQL database instances across on-premises, virtual, and cloud platforms such as AWS RDS and Aurora PostgreSQL
• Monitor database health, capacity, and performance; respond promptly to alerts to maintain system stability
• Manage database users, roles, privileges, and access controls to enforce security policies
• Perform routine database maintenance including reorganization, statistics updates, vacuuming, reindexing, and storage management to optimize performance
• Support L2 and L3 incident resolution and conduct root cause analysis to prevent recurrence
• Analyze and tune slow-running queries, indexes, execution plans, and configuration parameters to improve database efficiency
• Collaborate with developers on schema design, query optimization, and data model adjustments to support application requirements
• Plan database capacity and recommend scaling or archiving strategies to meet future demands
• Apply database security measures such as hardening, encryption (at rest and in transit), and audit logging to comply with policies
• Remediate vulnerabilities and apply security patches in accordance with organizational standards
• Support audit processes by providing required documentation and evidence for compliance
• Review and execute database changes and deployments following change management procedures
• Support data migration, version upgrades, and cloud migration activities to ensure seamless transitions
• Maintain runbooks, standard operating procedures, and comprehensive database documentation for operational consistency
• Coordinate with vendors, including IBM, on support cases and licensing issues to resolve technical challenges
• Report database performance, availability, and capacity metrics during service review meetings to inform stakeholders

Preferred competencies and 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