RDS PostgreSQL - Software Consultant

Job title: Software Consultant RDS PostgreSQL

Location: Remote

Initial Duration: 15 hours per week for 3 months, if successful would extend

Rate: As low as possible

The Mission

on a mission to secure the world s data. As we continue to evolve the client Security and Cyber resiliency, we are addressing most critical customer use-cases to ensure minimal data loss for our customers in case of disaster.

The Project We are seeking an expert PostgreSQL Consultant to perform a deep review and exploration of RDS PostgreSQL backup and recovery architecture. You will act as the authoritative PostgreSQL subject matter expert, partnering with our engineering team on DB-level and table-level restore strategies, extension compatibility, and platform constraints across cloud managed PostgreSQL offerings. This engagement requires intricate knowledge of PostgreSQL internals, restore workflows, system dependencies and real-world deployment patterns in enterprise environments.

Key Technical Focus:

• PostgreSQL Extensions: Audit how Rubrik's archival pipeline handles common extensions and provide expert guidance on compatibility gaps based on industry-wide usage patterns and known edge cases.
• Granular Restore: Assess and advise on DB-level and table-level restore strategies on AWS RDS, drawing on deep Postgres expertise to identify the most viable approaches within RDS's managed constraints.
• Cloud Managed PostgreSQL Constraints: Identify platform limitations superuser restrictions, parameter groups, shared_preload_libraries, and extension allowlists that affect restore fidelity across AWS RDS, Azure Database for PostgreSQL, and Cloud SQL for PostgreSQL.

Who You Are

• The Postgres Expert: You have hands-on experience as a Postgres DBA. You understand MVCC, WAL, logical replication, and extension internals.
• The Cloud Database Practitioner: You understand the nuances of cloud-managed PostgreSQL what AWS RDS locks down, where the managed layer creates complexity, and how these constraints differ across providers like Azure Database for PostgreSQL and Cloud SQL for PostgreSQL.
• The Problem Solver: When an extension conflicts or an RDS limitation blocks the obvious path, you have a Plan B within hours, not days.
• The Industry Expert: You bring experience advising on PostgreSQL deployments in mission-critical enterprise environments and can translate that into actionable guidance for Client's engineering team.