Senior PostgreSQL Database Engineer, RDS - Amazon

Job ID: 2672069 | Amazon Development Center U.S., Inc.

Do you want to work in Relational Database Service (RDS) for PostgreSQL which is one of the fastest growing AWS businesses? PostgreSQL is the only DBMS that has been named the database of the year 3 times by DB-Engines DBMS of the year. It is one of the fastest growing databases in the industry where related expertise and experience is highly sought after. Our team’s (the Database Engineering Team for RDS and Aurora PostgreSQL) mission is to build, improve and manage PostgreSQL as a fully managed database service. This is not a typical DBA or DBE role where you manage databases for specific customers. Instead, you are an integral part of the core database engineering team as you will work closely with developers and product and program managers. You will engage and contribute in the full product cycle: feature brainstorming, design, implementation, validation and customer escalation.

Key job responsibilities

1. You work closely with our customers to understand their challenges, solve issues during critical escalations, and teach best practices.
2. You, acting as the “voice of the customer”, bring learnings to the engineering process to design new features and plan end-to-end test scenarios. By shaping the direction of the RDS service, you make it easier to understand how our service is used by customers, including database developers and administrators.
3. You will actively drive feature enhancements, permanently resolve the root causes of issues, and improve the performance of our managed database service.
4. You are viewed as the ultimate subject matter expertise for all things databases as your work will be highly sought by the development team, the support team, the account team and customers directly.
5. You will interact with the open-source community via forums, conferences and feature or bug-fix code submissions.
6. You will extend your knowledge to other database engines and not limited to PostgreSQL.

A day in the life

As you design and code solutions to help our team drive efficiencies in software architecture, you’ll create metrics, implement automation and other improvements, and resolve the root cause of software defects. You’ll also:

1. Build high-impact solutions to deliver to our large customer base.
2. Participate in design discussions, code review, and communicate with internal and external stakeholders.
3. Work cross-functionally to help drive business decisions with your technical input.
4. Work in a startup-like development environment, where you’re always working on the most important stuff.

About the team

Our team is dedicated to supporting new members. We have a broad mix of experience levels and tenures, and we’re building an environment that celebrates knowledge-sharing and mentorship. Our senior members enjoy one-on-one mentoring and thorough, but kind, code reviews. We care about your career growth and strive to assign projects that help our team members develop your engineering expertise so you feel empowered to take on more complex tasks in the future.

BASIC QUALIFICATIONS

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

PREFERRED QUALIFICATIONS

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

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status.

Posted: August 8, 2024