Amazon - Seattle, WA

posted 2 months ago

Full-time - Senior
Remote - Seattle, WA
Sporting Goods, Hobby, Musical Instrument, Book, and Miscellaneous Retailers

About the position

As a Senior PostgreSQL Database Engineer in the Relational Database Service (RDS) for PostgreSQL at Amazon, you will be part of a dynamic team that is responsible for building, improving, and managing PostgreSQL as a fully managed database service. This role is not a typical DBA or DBE position; instead, you will be an integral part of the core database engineering team, collaborating closely with developers, product managers, and program managers. Your contributions will span the entire product lifecycle, from feature brainstorming and design to implementation, validation, and customer escalation. In this position, you will work directly with customers to understand their challenges, resolve issues during critical escalations, and teach best practices. Acting as the “voice of the customer,” you will bring valuable insights to the engineering process, helping to design new features and plan comprehensive test scenarios. Your expertise will shape the direction of the RDS service, making it easier for customers, including database developers and administrators, to utilize our offerings effectively. You will actively drive feature enhancements, permanently resolve root causes of issues, and improve the performance of our managed database service. As a subject matter expert, your knowledge will be highly sought after by development, support, and account teams, as well as customers. You will also engage with the open-source community through forums, conferences, and code submissions, extending your knowledge beyond PostgreSQL to other database engines. Your daily responsibilities will include designing and coding solutions to enhance software architecture, creating metrics, implementing automation, and resolving software defects. You will build high-impact solutions for a large customer base, participate in design discussions and code reviews, and communicate effectively with both internal and external stakeholders. Working in a startup-like environment, you will focus on the most critical tasks that drive business success.

Responsibilities

  • Work closely with customers to understand their challenges and resolve issues during critical escalations.
  • Act as the 'voice of the customer' to bring learnings to the engineering process for new feature design and testing.
  • Drive feature enhancements and resolve root causes of issues to improve database service performance.
  • Serve as a subject matter expert for databases, providing guidance to development, support, and account teams.
  • Engage with the open-source community through forums, conferences, and code submissions.
  • Design and code solutions to improve software architecture and resolve software defects.
  • Build high-impact solutions for a large customer base.
  • Participate in design discussions and code reviews, communicating with stakeholders.

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, resolving database, systems, 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

  • Comprehensive medical, financial, and other benefits package.
  • Equity and sign-on payments as part of total compensation package.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service