Database Administrator (DBA)

Company Overview

TroyTech International Consulting Pte Ltd is a Singapore & APAC consulting firm founded in 1998. As an IBM premier partner, it delivers SOA, EAI, JEE support, web & mobile solutions, and consulting in business integration with IBM & open source technologies.

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 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 and recovery, replication, HA/DR, and performance tuning
• Experience with Linux (RHEL preferred) and shell scripting
• Preferred certifications: IBM Certified Database Administrator (Db2), PostgreSQL certification (e.g., EDB), AWS Certified Database Specialty, ITIL 4 Foundation