SoSafe

Postgres AWS Database Engineer

SoSafe

full-time

Posted on:

Location Type: Remote

Location: United Kingdom

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AWSPostgresSQL

About the role

  • Administer, monitor, and optimize PostgreSQL databases running on Amazon RDS and Aurora.
  • Perform regular database maintenance tasks, including backup validation, replication checks, patching, and upgrades.
  • Collaborate with developers to optimize SQL and database objects, maintain PL/pgSQL routines, and contribute to data modeling initiatives to enhance performance.
  • Set up and fine-tune database performance metrics, logs, and alerts using AWS CloudWatch, pg_stat_statements, and other tools.
  • Identify and improve slow-running queries.
  • Implement and manage access control, auditing, and security policies in line with organizational standards.
  • Create and maintain database documentation and deployment scripts.
  • Contribute to and follow best practices for schema changes, migrations, and version control of database objects (GitHub experience is a plus).
  • Contribute to DevOps processes, including database CI/CD and automation of schema deployment automation.

Requirements

  • Hands-on experience with PostgreSQL in production environments.
  • Hands-on experience with Amazon RDS for PostgreSQL, including provisioning, parameter groups, backups, and failover.
  • Hands-on experience integrating PostgreSQL with other AWS services (e.g., Lambda, S3).
  • Hands-on experience in writing and debugging SQL queries, developing and optimizing PL/pgSQL routines, managing views and materialized views, implementing and maintaining partitions.
  • Hands-on experience with performance tuning, query planning, and index optimization.
  • Familiarity with PostgreSQL monitoring tools such as pg_stat_statements, auto_explain, and others.
  • Solid understanding of database design, normalization, and data integrity constraints.
  • Experience collaborating with developers to understand application logic and improve data-layer performance.
  • Knowledge of CI/CD practices for database development (e.g., Github Actions)
  • Strong collaboration and communication, with the experience to explain database concepts to both developers and non-technical stakeholders.
  • Proactive problem-solving mindset, with a strong sense of ownership and commitment to identifying issues through to resolution.
  • Comfortable participating in code reviews and providing constructive suggestions to improve database interactions.
  • Willingness to participate in on-call duty.
Benefits
  • Work/Life balance: Flexible hours, 33 vacation days
  • Wellbeing and financial support: Access to Open Up, corporate discounts
  • Connection & community: Virtual events, collaborative team activities, and opportunities for local meet-ups
  • And the list goes on: Tech equipment, referral bonuses, dog-friendly HQ
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
PostgreSQLSQLPL/pgSQLperformance tuningquery planningindex optimizationdatabase designdata integrityCI/CDdatabase automation
Soft Skills
collaborationcommunicationproblem-solvingownershipcommitmentconstructive feedbackadaptabilityproactivityteamworkexplanation of technical concepts