LC

PostgreSQL Database Administration

  • Linktrix Consultants Pte. Ltd.
  • Singapore
  • On-site
  • Contract, Full Time
  • SGD 6k–9k / month
  • Posted 2 days ago
DevOps & CloudDatabase OptimizationRecovery ProceduresPostgreSQLDatabase Tuning

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.

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.

Apply on MyCareersFuture

You apply on MyCareersFuture, where this job was posted. Peter Nowak isn’t the employer and doesn’t check listings.

Get new jobs like this by email

DevOps & Cloud · Singapore

Free. Confirm by email first; unsubscribe anytime in one click.

Similar jobs

PostgreSQL Database Administration at Linktrix Consultants Pte. Ltd. — Singapore | Peter Nowak