PostgreSQL Database Administration

LINKTRIX CONSULTANTS PTE. LTD.Singaporemycareersfuturepublished 11/17/2026
Must-have:AWSCloudSecurity

This role is primarily (80%) focused on PostgreSQL Database Administration hosted in AWS cloud RDS PAAS environment with AWS Cloud Administration (20%) as a secondary supporting function. The role also involves close coordination and collaboration with application and development, system and business analyst IT teams on database-related matters.

  1. PostgreSQL Database Administration hosted in AWS RDS PAAS(Core Responsibility) - Take ownership of the company core system, B2B and B2C Postgres SQL database administration, maintenance, performance tuning, optimisation, security, backup, and recovery of PostgreSQL databases hosted on AWS RDS.
  • Ensure Postgres SQL database availability, reliability, stability, and performance across production and non-production environments.
  • Manage database provisioning, patching, version upgrades, migration, monitoring, and troubleshooting.
  • Support database architecture, high availability, and failover management.
  • Perform database performance tuning, SQL query optimisation, and troubleshooting.
  • Manage database users, roles, permissions, and access controls. - Ensure database stability, security, data integrity, and operational efficiency.
  1. Database disaster recovery, synchronisation, replication, backup, recovery & security - Manage AWS RDS automated backups, snapshots, and database restoration.

Maintain on-premises DR site, synchronization and replication from AWS RDS to local on-premise or co-location site, database backup, recovery, and disaster recovery procedures. - Support high availability, DR failover, and database recovery planning. - Conduct periodic DR, backup and recovery testing.

  1. AWS Cloud Administration (Secondary) - Assist in AWS cloud infrastructure and operational matters related to database. - Assist with AWS infrastructure configuration, troubleshooting, and maintenance.

Requirements:

  • Degree or Diploma in Computer Science, Information Technology, or a related discipline. - Hands-on experience administering AWS RDS PostgreSQL environment.
  • To be stationed at the customer's office.
  • Effective communication to clearly convey technical to both technical stakeholders, application and development team, both in house and external.
  • Strong understanding of PostgreSQL architecture, database performance tuning, SQL optimisation, indexing, and troubleshooting.
  • Experience in database backup, recovery, disaster recovery, HA and failover configuration. - Knowledge of database security, configuration, and operational best practices.

Technical Skills & Additional Advantages -

Primary Database: PostgreSQL AWS Cloud Platform: Amazon RDS

Other Database Technologies: of Oracle, MySQL, MariaDB, MongoDB, and Microsoft SQL Server.

Shortlisted profile will be reach out.