Senior PostgreSQL Database Reliability Engineer

Vollzeit
vor 3 Monate

Get to know OktaOkta is The World’s Identity Company. We free everyone to safely use any technology—anywhere, on any device or app. Our Workforce and Customer Identity Clouds enable secure yet flexible access, authentication, and automation that transforms how people move through the digital world, putting Identity at the heart of business security and growth. At Okta, we celebrate a variety of perspectives and experiences. We are not looking for someone who checks every single box - we’re looking for lifelong learners and people who can make us better with their unique experiences. Join our team! We’re building a world where Identity belongs to you.

At Okta, we’re always pushing the bounds of the entire identity landscape. Data is a critical component of our product and our mission as a data store team is to provide a highly available, reliable, secure and performant transactional persistent data layer which we do by leveraging our vast experience and through the skillful use of automation. We would love to hear from you if you are passionate about solving problems at scale with automation, testing, and tuning. The ideal candidate exemplifies the ethics of, “If you have to do something more than once, automate it” and who can rapidly self-educate on new concepts and tooling. 

We seek a skilled PostgreSQL Database Reliability Engineer (DBRE) with specialized expertise in Aurora PostgreSQL and a strong foundation in PostgreSQL itself. As a crucial member of our database operations team, you will be responsible for ensuring the performance, availability, and security of our database systems. This role demands database design expertise, query and schema tuning, and proactive monitoring to ensure reliability and scale required to support our growing business needs.

Key Responsibilities:

  • Deploy infrastructure as code using terraform, configure, and maintain Aurora PostgreSQL database instances to ensure high availability, disaster recovery, and backups are properly implemented.
  • Conduct thorough performance analysis and tuning to meet application SLAs, optimizing database schema, indexes, and SQL queries. Quickly troubleshoot and resolve database performance issues.
  • Develop automation scripts (e.g., Go/Python) to streamline tasks and enhance efficiency. Implement robust monitoring tools and proactive alerts for effective management and mitigation of database instances.
  • Implement and enforce stringent database security practices, including data encryption (at rest and in transit), certificate management, access controls, and comprehensive audit logging.
  • Collaborate closely with developers and infrastructure teams to support seamless application deployments and resolve complex database-related issues. Provide mentorship and knowledge sharing to other DBREs on the team.

Required Skills and Qualifications:

  • Proven experience as a PostgreSQL DBRE, especially with specific expertise in Aurora PostgreSQL.
  • In-depth knowledge of PostgreSQL internals, performance tuning, and query optimization.
  • Experience in database design, implementation, and maintenance in a high-availability environment.
  • Strong proficiency in SQL and scripting languages (especially Go and Python).
  • Familiarity with database monitoring tools (e.g., CloudWatch, Grafana).
  • Solid understanding of database security practices and compliance requirements.
  • Ability to troubleshoot and resolve database performance issues and outages promptly.
  • Excellent communication skills and ability to work effectively in a team environment.
  • Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent work experience).

Preferred Skills:

  • AWS Certified Database - Specialty or related certifications demonstrating proficiency in AWS database services and cloud infrastructure management.
  • Familiarity or hands-on experience with MySQL or other relational database management systems (RDBMS), understanding their differences and implications for database management.
  • Understanding of containerization technologies such as Docker and Kubernetes and their impact on database deployments and scalability.
  • Proven track record of applying innovative solutions to complex database challenges and a strong problem-solving mindset in a dynamic operational environment.

Why Join Us:Joining our team means being part of a dynamic environment where your expertise in Aurora PostgreSQL and PostgreSQL will have a direct and very valued contribution to our mission-critical database operations. You’ll have opportunities for professional growth, working with cutting-edge technologies and collaborating with a diverse and geographically distributed  talented team dedicated to achieving our business goals.

#LI-TM

#LI- Remote

 

Below is the annual base salary range for candidates located in California, Colorado, New York and Washington. Your actual base salary will depend on factors such as your skills, qualifications, experience, and work location. In addition, Okta offers equity (where applicable), bonus, and benefits, including health, dental and vision insurance, 401(k), flexible spending account, and paid leave (including PTO and parental leave) in accordance with our applicable plans and policies. To learn more about our Total Rewards program please visit: https://rewards.okta.com/us.   

The annual base salary range for this position for candidates located in California (excluding San Francisco Bay Area), Colorado, New York, and Washington is between:$132,000—$198,000 USD The annual base salary range for this position for candidates located in the San Francisco Bay area is between: $148,000—$222,000 USD

What you can look forward to as an Full-Time Okta employee!

  • Amazing Benefits
  • Making Social Impact
  • Fostering Diversity, Equity, Inclusion and Belonging at Okta 

Okta cultivates a dynamic work environment, providing the best tools, technology and benefits to empower our employees to work productively in a setting that best and uniquely suits their needs. Each organization is unique in the degree of flexibility and mobility in which they work so that all employees are enabled to be their most creative and successful versions of themselves, regardless of where they live. Find your place at Okta today! https://www.okta.com/company/careers/.

Okta is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, ancestry, marital status, age, physical or mental disability, or status as a protected veteran. We also consider for employment qualified applicants with arrest and convictions records, consistent with applicable laws. If reasonable accommodation is needed to participate in the job application or interview process, please use this Form to request an accommodation.

Okta is committed to complying with applicable data privacy and security laws and regulations. For more information, please see our Privacy Policy at https://www.okta.com/privacy-policy/.