Senior PostgreSQL Database Engineer, RDS - Amazon

Description 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 - You work closely with our customers to understand their challenges, solve issues during critical escalations, and teach best practices. - 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. - You will actively drive feature enhancements, permanently resolve the root causes of issues, and improve the performance of our managed database service. - 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. - You will interact with the open-source community via forums, conferences and feature or bug-fix code submissions. - 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: Build high-impact solutions to deliver to our large customer base. Participate in design discussions, code review, and communicate with internal and external stakeholders. Work cross-functionally to help drive business decisions with your technical input. 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. Diverse Experiences AWS values diverse experiences. Even if you do not meet all of the 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. About 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. 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. 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. Mentorship & 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. Hybrid Work We value innovation and recognize this sometimes requires uninterrupted time to focus on a build. We also value in-person collaboration and time spent face-to-face. Our team affords employees options to work in the office every day or in a flexible, hybrid work model near one of our US Amazon offices. Our hybrid models allow you the freedom to work from home whenever in-office collaboration isn't necessary. Basic Qualifications - 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 and also providing systems architecture leadership. - 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 is a must (PL/SQL, T-SQL etc.) Preferred Qualifications - 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 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. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us. Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $131,400/year in our lowest geographic market up to $227,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.