- Outram Central Region (Singapore) Singapore
Kerja Sepenuh Masa Database Administrator (DBA), Gaji tinggi SGD 7,000 di TroyTech International Consulting Pte Ltd Central Region (Singapore) - Maukerja
Database Administrator (DBA)
TroyTech International Consulting Pte Ltd
Kongsi
Simpan
Lokasi Kerja
Penerangan Kerja
Tanggungjawab
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
TroyTech International Consulting Pte Ltd is a Singapore & APAC based consulting and professional services firm founded by Mr. Troy Chung in 1998, actual President of the firm. TroyTech provides the most complete SOA, EAI, JEE technical support, bleeding edge Web & Mobile solutions, and world- class consulting skills in business integration with IBM & Open Source software solutions.
As an IBM premier partner, TroyTech is reselling software & hardware and is providing consultancy services. Recently entering the Red Hat Independent Software Vendor program, the company is striving to extend its support to the major open source players & technologies.
TroyTech's headquarters & operations are in Singapore with representative offices in Taiwan & Tokyo, and emphases its presence in Financial, Transportation & Government sectors.
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
TroyTech International Consulting Pte Ltd is a Singapore & APAC based consulting and professional services firm founded by Mr. Troy Chung in 1998, actual President of the firm. TroyTech provides the most complete SOA, EAI, JEE technical support, bleeding edge Web & Mobile solutions, and world- class consulting skills in business integration with IBM & Open Source software solutions.
As an IBM premier partner, TroyTech is reselling software & hardware and is providing consultancy services. Recently entering the Red Hat Independent Software Vendor program, the company is striving to extend its support to the major open source players & technologies.
TroyTech's headquarters & operations are in Singapore with representative offices in Taiwan & Tokyo, and emphases its presence in Financial, Transportation & Government sectors.
Peringatan Penting
Jangan pernah kongsikan maklumat bank atau kad kredit anda semasa memohon pekerjaan. Elakkan membuat sebarang pembayaran atau mengisi survey yang tidak berkaitan. Jika ada yang mencurigakan, sila laporkan iklan pekerjaan ini segera.
Lebih Lanjut