Aurora PostgreSQL Architect: Migrations & Scale

Amazon; Herndon (VA); On-site; USD 125,000 - 208,000; Full time

Job summary

Amazon Web Services seeks a Sr. PostgreSQL Specialist Solutions Architect focused on Aurora PostgreSQL. You will act as the technical authority for PostgreSQL workloads on Aurora and RDS, driving migrations and architecting scalable production deployments.

Lead with deep PostgreSQL expertise, collaborate with customers and AWS teams, publish technical content and participate in events to advance PostgreSQL engagements worldwide.

Qualifications

• 8+ years of experience in software development, cloud computing or data & analytics
• 3+ years of design, implementation, or consulting in applications and infrastructures
• 10+ years of IT development or implementation/consulting in software/Internet industries
• Hands-on experience with Aurora PostgreSQL, RDS for PostgreSQL, or significant hands-on time with AWS database and migration services (DMS, SCT).
• Led migrations to Aurora as the technical owner.
• Experience with Aurora-specific features: storage architecture, fast cloning, Global Database, Performance/Database Insights, and Blue/Green Deployments.
• Experience architecting or operating PostgreSQL solutions at scale (multi-TB databases, tens of thousands of connections, cross-region replication).
• Have software development experience (Python, Java, etc.), and fluency with AI tooling (Kiro, Claude Code, Codex, etc.)

Responsibilities

• Serve as the technical advisor for AWS's key customers running or migrating to Aurora PostgreSQL and RDS for PostgreSQL, providing hands-on architectural guidance from design through production operation.
• Guide customers on Aurora PostgreSQL operational best practices including performance & scaling, high availability & durability, monitoring & observability, maintenance & patching, backup & recovery, security and operational hygiene.
• Design and validate Aurora PostgreSQL architectures that leverage Aurora-specific capabilities including storage auto-scaling, read replica scaling, Global Database, HA/DR, Serverless, ensuring customers realize the full value of the platform.
• Partner with the Aurora service team as the voice of the customer, surfacing recurring pain points, advocating for feature enhancements, and participating in roadmap reviews.
• Engage with customer engineers in whiteboard sessions, architecture reviews, and technical deep dives, providing candid guidance and pushing back diplomatically when a proposed design will not hold up at scale.
• Develop and publish technical thought leadership content including blogs, reference architectures, white papers, and re-usable artifacts, that elevate the broader PostgreSQL community on AWS.
• Advise customers complex database migrations (Oracle, SQL Server, and other engines to Aurora PostgreSQL).
• Present at key industry events including AWS re:Invent, AWS Summits, PostgreSQL community conferences (PGConf, PGDay), and customer-facing workshops.
• Stay current with PostgreSQL community developments (new major versions, extensions ecosystem, community tooling) and translate those advancements into actionable guidance for AWS customers.

Skills

Aurora PostgreSQL

PostgreSQL tuning

Migration experience

Database architecture

Cloud AWS

Tools

RDS for PostgreSQL

AWS DMS

SQL

Job description

Amazon Web Services seeks a Sr. PostgreSQL Specialist Solutions Architect focused on Aurora PostgreSQL. You will act as the technical authority for PostgreSQL workloads on Aurora and RDS, driving migrations and architecting scalable production deployments.

Lead with deep PostgreSQL expertise, collaborate with customers and AWS teams, publish technical content and participate in events to advance PostgreSQL engagements worldwide.