Senior Database Reliability Engineer

Lattice’s Engineering team is continuously working to better both our product and our craft. We use a modern, cutting-edge tech stack and love experimenting with new technologies. We strive for maintainable, robust, and performant code. We’re highly collaborative and continuously iterative and work closely with designers and product managers. We prioritize not only great technical architecture but also an amazing product experience.

Lattice is hiring a reliability engineer to focus on our PostgreSQL databases, to ensure high reliability and performance. We run in Amazon Web Services, using both RDS and Aurora instances of PostgreSQL. We’re looking for someone who is comfortable configuring and tuning database clusters as well as partnering with engineering teams to review and improve data modeling and query optimization. You’re also a software developer, and will build tools, libraries, and other code to improve Lattice’s use of our databases. You’ll use Terraform for provisioning and managing the database infrastructure, and Datadog and other tools for database observability.

• Work on database reliability and performance as a member of the SRE team.
• Analyze solutions and implement best practices for operating our PostgreSQL databases.
• Work on observability of relevant database metrics and make sure we reach our database objectives.
• Work with other reliability engineers to roll out changes to our production environment and help mitigate database-related production incidents.
• Participate in on-call support rotation with the team.
• Provide database expertise to engineering teams (for example through reviews of database migrations, queries and performance optimizations).
• Work on automation of database infrastructure and help engineering succeed by providing self-service tools.
• Plan the growth and manage the capacity of GitLab's database infrastructure.
• Support and debug database production issues across services and levels of the stack.
• Document every action so your learnings turn into repeatable actions and then into automation.
• Cross-train other reliability engineers on aspects of database reliability.

Experience it’s important for you to have at some level:

• At least 5 years of experience running PostgreSQL in large production environments.
• Experience operating systems in cloud environments such as AWS or GCP.
• Have deep knowledge of SQL and data modeling for RDBMS.
• Have good knowledge of the internals of PostgreSQL.
• Experience deploying/utilizing proxy and optimization solutions such as RDS Proxy  pgBouncer, PGAnalyze, OtterTune, etc.
• Have several years of experience programming in a software engineering role.
• Understanding of SRE concepts such as SLA/SLI/SLOs and incident management processes.
• Strong desire to automate away the toil.
• Strong interest in collaborating with and mentoring product engineers about SQL and database topics.

Experience that would be helpful:

• Experience with infrastructure automation and configuration management using tools like Terraform, Chef, Ansible, Puppet, etc.
• Experience with observability tooling for database monitoring and troubleshooting, such as Datadog, Percona, EverSQL, etc.
• Familiarity with distributed systems and networking concepts as they apply to applications and database utilization.

#LI-remote

[For All U.S. based Roles, effective 1/1/2023 and onward:]

The estimated annual cash salary for this role is $163,758 - $216,090. This position is also eligible for incentive stock options, subject to the terms of Lattice’s applicable plans

[For Sales & CX only.] This position is also eligible for variable compensation of [$xx,000] or x0% of on target earnings (OTE) subject to personal performance, company performance, and the terms of Lattice’s applicable plans.

Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: Medical insurance; Dental insurance; Vision insurance; Life, AD&D, and Disability Insurance; Emergency Weather Support; Wellness Apps; Paid Parental Leave, Paid Time off inclusive of holidays and sick time; Commuter & Parking Accounts; Lunches in the Office; Workplace Amenities Stipend, Internet and Phone Stipend; One time WFH Office Set-Up Stipend; 401(k) retirement plan; Financial Planning; Learning & Development Budget; Sabbatical Program; and Invest in Your People Fund

*Note on Pay Transparency:

Lattice provides an estimate of the compensation for roles that may be hired as required by state regulations. Compensation may vary based on (a) location, as Lattice factors in specific location when benchmarking compensation for most roles; (b) individual candidate skills and qualifications; and (c) individual candidate experience.

Additionally, Lattice leverages current market data to determine compensation, so posted compensation figures are subject to change as new market data becomes available. The salary, other compensation, and benefits information is accurate as of the date of this posting. Lattice reserves the right to modify this information at any time, subject to applicable law.