Senior Specialist SA PostgreSQL, AWS Database

Amazon Web Services (AWS); São Paulo; Presencial; BRL 300 000 - 420 000; Tempo integral

Resumo da oferta

Amazon AWS Services Brazil Ltd is seeking a Specialist Solutions Architect for Aurora PostgreSQL to be the technical authority for AWS's largest customers, guiding architecture, migration, and operation of PostgreSQL workloads on Amazon Aurora and Amazon RDS.

You will collaborate with customers to design production architectures, optimize performance, and drive best practices, while mentoring teams and contributing technical content for the PostgreSQL community.

Qualificações

• 7+ years of infra architecture, database architecture and networking experience
• Expertise in PostgreSQL internals and operational practices: MVCC and vacuum behavior, query planner and optimizer internals
• Experience communicating with executive stakeholders or clients across technical and non-technical audiences
• Experience with database management systems and customer-facing work in a technical sales/engineering context

Responsabilidades

• 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, HA/DR, monitoring, and security
• Design and validate architectures that leverage Aurora-specific capabilities such as storage auto-scaling, read replicas, Global Database, and Serverless
• Partner with the Aurora service team to surface pain points and drive feature enhancements and roadmap alignment
• Engage with customer engineers in whiteboard sessions, architecture reviews, and technical deep dives, offering candid guidance
• Develop and publish technical thought leadership content including blogs, reference architectures, white papers, and reusable artifacts
• Advise customers on complex database migrations (Oracle, SQL Server, etc.) to Aurora PostgreSQL
• Present at AWS events and PostgreSQL community conferences
• Stay current with PostgreSQL community developments and translate into customer guidance

Conhecimentos

PostgreSQL internals

MVCC

Vacuum behavior

Query planner/optimizer

Replication

Ferramentas

Aurora PostgreSQL

RDS for PostgreSQL

DMS

SCT

Descrição da oferta de emprego

Description

Are you a builder that lives and breathes PostgreSQL? Have you spent years tuning vacuum behavior, diagnosing lock contention under heavy OLTP workloads, reasoning about query planner decisions, managing replication topologies, and guiding large-scale migrations from commercial engines like Oracle and SQL Server? Are you the person your organization turns to when a Postgres system is misbehaving at 3 AM and when leadership needs a whiteboard session on where the data platform is headed next? As a Specialist Solutions Architect for Aurora PostgreSQL, you will be the technical authority that AWS's largest and most complex customers rely on to architect, migrate, and operate PostgreSQL workloads on Amazon Aurora and Amazon RDS.

Description

Are you a builder that lives and breathes PostgreSQL? Have you spent years tuning vacuum behavior, diagnosing lock contention under heavy OLTP workloads, reasoning about query planner decisions, managing replication topologies, and guiding large-scale migrations from commercial engines like Oracle and SQL Server? Are you the person your organization turns to when a Postgres system is misbehaving at 3 AM and when leadership needs a whiteboard session on where the data platform is headed next? As a Specialist Solutions Architect for Aurora PostgreSQL, you will be the technical authority that AWS's largest and most complex customers rely on to architect, migrate, and operate PostgreSQL workloads on Amazon Aurora and Amazon RDS.

This is not a generalist database role. You will focus on Aurora PostgreSQL, going deep where others go broad. You will partner directly with customer engineers and CTOs to design well architected production architectures that hold up under real-world pressure and the operational patterns that distinguish battle-tested Postgres practitioners from those with only surface‑level familiarity. You will have experience with migrations (Oracle/SQL Server/on premises Postgres to Aurora). You will collaborate closely with the Aurora service team to surface customer patterns, elevate feature gaps, and drive the product roadmap on behalf of the customers you serve.

Equally important, you will operate as a thought leader and force multiplier across the broader Specialist SA organization, mentoring teammates, publishing technical content, presenting at AWS re:Invent and AWS Summits, and establishing repeatable frameworks that raise the bar for PostgreSQL engagements worldwide.

• 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).
• Software development experience (Python, Java, etc.), and fluency with AI tooling (Kiro, Claude Code, Codex, etc.)
• Experience in a technical role within a sales organization or in a principal/staff‑level engineering role with significant cross‑team influence.

Key job 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.

About The Team

Why AWS?

Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform. We pioneered cloud computing and never stopped innovating — that’s why customers from the most successful startups to Global 500 companies trust our robust suite of products and services to power their businesses.

Diverse Experiences

Amazon values diverse experiences. Even if you do not meet all of the preferred qualifications and skills listed in the job description, we encourage candidates to apply. If your career is just starting, hasn’t followed a traditional path, or includes alternative experiences, don’t let it stop you from applying.

Work/Life Balance

We value work‑life harmony. Achieving success at work should never come at the expense of sacrifices at home, which is why we strive for flexibility as part of our working culture. When we feel supported in the workplace and at home, there’s nothing we can’t achieve in the cloud.

Inclusive Team Culture

Here at AWS, it’s in our nature to learn and be curious. Our employee‑led affinity groups foster a culture of inclusion that empower us to be proud of our differences. Ongoing events and learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences, inspire us to never stop embracing our uniqueness.

Mentorship and Career Growth

We’re continuously raising our performance bar as we strive to become Earth’s Best Employer. That’s why you’ll find endless knowledge‑sharing, mentorship and other career‑advancing resources here to help you develop into a better‑rounded professional.

Basic Qualifications

• 7+ years of infrastructure architecture, database architecture and networking experience
• Experience in Postgres, or experience in software development and experience troubleshooting and debugging technical systems
• Experience communicating across technical and non‑technical audiences, including executive level stakeholders or clients
• Experience with database management systems
• 5+ years of customer‑facing work, engaging with customer executives, technologists or partners to solve business problems with advanced technologies experience
• Expertise in PostgreSQL internals and operational practices: MVCC and vacuum behavior, query planner and optimizer internals, pgvector, indexing strategies (B‑tree, GIN, GiST, BRIN), replication (streaming, logical), extension ecosystem/architecture, and connection management.

Preferred Qualifications

• Experience in Postgres, or experience in technical support and experience in any Bigdata architecture
• Experience in software development, or experience demonstrating software engineering skills in a previous internship, work experience, coding competitions, or publications and experience with programming/scripting (Batch, VB, PowerShell, Java, C#, Chef, Perl, Ruby and/or PHP)
• Experience working in a technology sales organization
• 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.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how‑we‑hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Company

Amazon AWS Services Brazil Ltd

Job ID: A10429556