Senior PostgreSQL Database Engineer, RDS

$131,400 - $227,000/Yr

Amazon - East Palo Alto, CA

Full-time - Senior

Remote - East Palo Alto, CA

Sporting Goods, Hobby, Musical Instrument, Book, and Miscellaneous Retailers

About the position

The Senior PostgreSQL Database Engineer for RDS is a pivotal role within the Database Engineering Team, focusing on building, improving, and managing PostgreSQL as a fully managed database service. This position emphasizes collaboration with developers and product managers throughout the product lifecycle, from feature brainstorming to implementation and customer escalation. The engineer will act as the voice of the customer, driving feature enhancements and resolving critical issues while also engaging with the open-source community.

Responsibilities

• Work closely with customers to understand their challenges and resolve issues during critical escalations.
• Act as the voice of the customer to inform the engineering process for new features and testing scenarios.
• Drive feature enhancements and permanently resolve root causes of issues to improve service performance.
• Serve as a subject matter expert for databases, providing support to development, support, and account teams.
• Interact with the open-source community through forums, conferences, and code submissions.
• Design and code solutions to enhance software architecture and resolve software defects.

Requirements

• 8 years' experience building and maintaining complex mission-critical production database systems such as Postgres, Oracle, MySQL, Microsoft SQL Server.
• 5 years' experience designing and maintaining PostgreSQL relational databases.
• 5 years' experience working directly with customers to resolve database and infrastructure-related issues.
• Awareness of customer workloads and use cases, including performance, availability, and scalability.
• Working knowledge of relational database internals (locking, consistency, serialization, recovery paths).
• Working knowledge of at least one scripting language (shell, Python, Perl).
• Working knowledge of at least one application programming language (Java, C#, C, C++, Go).
• Coding skills in the procedural language for at least one database engine (PL/SQL, T-SQL, etc.).

Nice-to-haves

• Experience supporting large analytical data warehousing databases with knowledge of ETL environments.
• Experience migrating databases from commercial engines to PostgreSQL.
• Experience migrating application code from commercial database engines to PostgreSQL.
• Storage engineering experience, including NAS, SAN, SSD, multi-pathing, and caching.
• Experience developing extensions or patches for PostgreSQL project or ecosystem.
• Software development or consulting experience.

Benefits

• Flexible work hours and hybrid work model options.
• Mentorship and career growth opportunities.
• Inclusive team culture with employee-led affinity groups.
• Work-life balance initiatives.
• Access to ongoing learning experiences and events.