Database Administrator (DBA) - AWS RDS Aurora PostgreSQL Specialist

HOPERUN SOFTWARE SINGAPORE PTE. LTD.; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

A tech company in Singapore is seeking a skilled Database Administrator (DBA) with strong expertise in AWS RDS Aurora PostgreSQL. The role involves ensuring database stability, performance optimization, and conducting health monitoring for mission-critical applications. The ideal candidate should have over 5 years in PostgreSQL management and specific experience with AWS configurations. This role is pivotal for maintaining the performance of the company's critical databases.

Qualifications

• 5+ years of experience managing PostgreSQL databases in production.
• 3+ years of hands-on experience specifically with AWS RDS Aurora PostgreSQL.
• Strong proficiency in AWS services like CloudWatch and VPC configurations.

Responsibilities

• Monitor database health and performance using CloudWatch.
• Analyze PostgreSQL error logs for identifying issues.
• Conduct performance analysis and optimization of databases.

Skills

PostgreSQL management

AWS RDS Aurora PostgreSQL

Database performance tuning

AWS services

Problem-solving

Job description

Overview

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.