Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Database Administrator (DBA) AWS RDS Aurora PostgreSQL Specialist.
Singapore Jobs Expertini

Urgent! Database Administrator (DBA) - AWS RDS Aurora PostgreSQL Specialist Job Opening In Singapore, Singapore – Now Hiring HOPERUN SOFTWARE SINGAPORE PTE. LTD.

Database Administrator (DBA) AWS RDS Aurora PostgreSQL Specialist



Job description

About the Role:

We are looking for an experienced Database Administrator (DBA) with deep, hands‑on expertise in AWS RDS Aurora PostgreSQL .

The ideal candidate is not only proficient in general PostgreSQL operations and tuning, but also has a strong command of AWS RDS‑specific configurations , monitoring , and performance optimization .

This role is critical in ensuring the stability, performance, and scalability of our production databases that support mission‑critical applications in the supply chain and enterprise domain.

Key Responsibilities:

1.

Health Monitoring

  • Review and interpret CloudWatch alarms and Performance Insights dashboards.

  • Monitor database connections , CPU utilization , and storage I/O metrics.

  • Ensure proactive issue detection and alert configuration to maintain database health.

2.

Log Analysis

  • Regularly review PostgreSQL error logs for warnings, errors, and abnormal patterns.

  • Identify and resolve authentication failures or connection issues .

  • Analyze slow query logs to identify and resolve performance bottlenecks.

  • Monitor autovacuum activities and manage table/index bloat effectively.

3.

Capacity Planning

  • Analyze historical trends in storage growth , compute resource utilization , and connection load .

  • Forecast future capacity needs and recommend scaling strategies.

  • Review and optimize backup storage plans to balance cost and availability.

4.

Performance Analysis and Optimization

  • Conduct deep‑dive database performance reviews and tuning exercises.

  • Identify and optimize resource‑intensive queries and stored procedures.

  • Monitor wait events , lock contention , and long‑running transactions .

  • Assess connection pooling strategies (e.g., PgBouncer, RDS Proxy) for effectiveness.

  • Review and fine‑tune PostgreSQL parameters for optimal throughput and latency.

  • Provide monthly performance reports and recommend improvement actions.

Requirements:

Technical Skills

  • 5+ years of experience managing PostgreSQL databases in production.

  • 3+ years of hands‑on experience specifically with AWS RDS Aurora PostgreSQL .

  • Strong understanding of:
    • RDS performance tuning and parameter groups
    • Read replica and failover configuration
    • IAM authentication and encryption (KMS)
    • Backup, snapshot, and PITR strategies
    • Security, compliance, and maintenance best practices
  • Deep expertise in AWS RDS advanced configuration , including parameter groups, option groups, and Aurora‑specific features like serverless scaling and global databases.

  • Proven experience in PostgreSQL tuning and analyzing execution plans, including query optimization, indexing, and vacuuming.

  • Strong proficiency in AWS services : CloudWatch, Performance Insights, IAM for database access, and VPC configurations.

  • Excellent problem‑solving skills and ability to work in a fast‑paced, collaborative environment.

Preferred Qualifications:

  • AWS Certified Database – Specialty (or equivalent hands‑on experience).

  • Experience with Aurora Global Database , multi‑AZ deployment, and cross‑region replication .

  • Knowledge of CI/CD pipelines and infrastructure as code (e.g., Terraform, CloudFormation) for database provisioning.

  • Experience supporting databases in high‑availability enterprise environments .

#J-18808-Ljbffr


Required Skill Profession

Database, Analytics & Bi, Technical Support & Administration



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your Database Administrator Potential: Insight & Career Growth Guide