Senior PostgreSQL Database Engineer, RDS

Amazon; Palo Alto (CA); On-site; USD 131,000 - 227,000; Full time

Job summary

An innovative company is seeking an experienced Database Engineer to join their team. In this role, you will be an integral part of the core database engineering team, working on PostgreSQL and engaging in the full product cycle from feature brainstorming to implementation. You'll collaborate closely with developers and product managers to enhance database services, improve performance, and resolve customer issues. This position offers a dynamic environment that values mentorship and career growth, making it an exciting opportunity for those passionate about database technologies and customer success. If you thrive in a collaborative atmosphere and are eager to make an impact, this role is for you.

Qualifications

• 8+ years of experience with complex production database systems.
• 5+ years of experience designing and maintaining PostgreSQL databases.
• Knowledge of relational database internals and scripting languages.

Responsibilities

• Understand customer challenges and resolve issues during escalations.
• Drive feature enhancements and improve database service performance.
• Engage with the open-source community and contribute to PostgreSQL.

Skills

PostgreSQL

Oracle

MySQL

Microsoft SQL Server

Scripting languages (shell, Python, Perl)

Application programming languages (Java, C#, C, C++, Go)

Database internals knowledge

ETL environments

Job 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.

AWS Utility Computing (UC) provides product innovations — from foundational services such as Amazon’s Simple Storage Service (S3) and Amazon Elastic Compute Cloud (EC2), to consistently released new product innovations that continue to set AWS’s services and features apart in the industry. As a member of the UC organization, you’ll support the development and management of Compute, Database, Storage, Internet of Things (IoT), Platform, and Productivity Apps services in AWS, including support for customers who require specialized security solutions for their cloud services.

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.

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.

Minimum Requirements

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.)
9. Experience supporting large analytical data warehousing databases with knowledge of ETL environments.
10. Experience migrating databases from commercial engines to PostgreSQL.
11. Experience migrating application code from commercial database engines to PostgreSQL.
12. Storage engineering experience, including NAS, SAN, SSD, multi-pathing and caching.
13. Experience developing extensions or patches for PostgreSQL project or ecosystem.
14. 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.

Los Angeles County applicants: Job duties for this position include: work safely and cooperatively with other employees, supervisors, and staff; adhere to standards of excellence despite stressful conditions; communicate effectively and respectfully with employees, supervisors, and staff to ensure exceptional customer service; and follow all federal, state, and local laws and Company policies. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position.

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 this link for more information.

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 this link. This position will remain posted until filled. Applicants should apply via our internal or external career site.