PostgreSQL DBA – AWS Cloud Expertise

About the role

HPS is seeking a Database Administrator with solid PostgreSQL fundamentals and a strong interest in AWS cloud services. The DBA will manage mission‑critical, high‑volume transactional databases, working closely with development, architecture, and production teams.

Key responsibilities

• Administer and maintain PostgreSQL instances, including configuration, backups, recovery, and monitoring.
• Analyze and optimise SQL queries, indexes, and execution plans, and resolve performance bottlenecks.
• Work with AWS database services such as RDS/Aurora PostgreSQL, CloudWatch, and Performance Insights.
• Participate in maintenance tasks like VACUUM, AUTOVACUUM, partitioning, and data volume management.
• Document incidents, technical analyses, and operational procedures.

Required profile

• Degree in Computer Science, IT or related field.
• At least 5 years of hands‑on PostgreSQL administration in production environments.
• Strong analytical, problem‑solving and self‑learning attitude.
• Fluent English communication skills.

Required skills

• PostgreSQL administration and query optimisation.
• SQL proficiency.
• Linux/Unix environment knowledge.
• AWS RDS/Aurora PostgreSQL, CloudWatch, Performance Insights.
• VACUUM, AUTOVACUUM, partitioning, replication, high availability and disaster recovery concepts.