jobs in LINKTRIX Consultants, Asia Pacific

LINKTRIX Consultants, Asia Pacific Hiring! Full Time PostgreSQL Database Administration in - Ricebowl

PostgreSQL Database Administration

LINKTRIX Consultants, Asia Pacific

Singapore

Share
Save

Working Location

  • Singapore Singapore

Job Description

Responsibilities

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.


2. 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.

3. 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.


Shortlisted candidates will be notified.

Important Information

Never provide your bank or credit card details when applying for jobs. Do not transfer any money or complete unrelated online surveys. If you see something suspicious, Report this Job ad.

Learn More