Senior Database Administrator (PostgreSQL)

TL;DR

Senior Database Administrator (PostgreSQL): Managing and optimizing PostgreSQL infrastructure on AWS RDS and Aurora with an accent on performance tuning and database design. Focus on optimizing SQL queries, implementing security policies, and automating schema deployments via CI/CD pipelines.

Location: Must be based in and legally authorized to work in the UK, Portugal, or Ireland

Company

hirify.global is a leading human risk management provider specializing in cybersecurity awareness and behavioral change through an award-winning training platform.

What you will do

• Administer, monitor, and optimize PostgreSQL databases running on Amazon RDS and Aurora.
• Perform regular maintenance including backup validation, replication checks, patching, and upgrades.
• Collaborate with developers to optimize SQL, maintain PL/pgSQL routines, and enhance data modeling.
• Configure performance metrics, logs, and alerts using AWS CloudWatch and pg_stat_statements.
• Implement access control, auditing, and security policies according to organizational standards.
• Contribute to DevOps processes, including database CI/CD and schema deployment automation.

Requirements

• 5+ years of experience operating and scaling PostgreSQL in high-availability production environments.
• Advanced expertise in SQL and PL/pgSQL, complex query optimization, and partitioning.
• Deep experience with Amazon RDS for PostgreSQL, including scaling and disaster recovery.
• Experience designing PostgreSQL integrations with AWS services such as Lambda and S3.
• Strong knowledge of data modeling, normalization, and data integrity at scale.
• Proficiency with monitoring tools like pg_stat_statements and auto_explain.

Culture & Benefits

• Work-life balance with flexible hours and 33 vacation days.
• Wellbeing support through Access to Open Up and corporate discounts.
• Strong community focus with virtual events and local meet-ups.
• Provision of tech equipment and referral bonuses.
• Dog-friendly HQ.