Intermediate Site Reliability Engineer, Database Operations

Intermediate Site Reliability Engineer, Database Operations GitLab is an open-core software company that develops the AI-powered DevSecOps Platform used by more than 100,000 organizations. The Database Operations team owns the lifecycle of the PostgreSQL database engine for GitLab.com, focusing on reliability, scalability, performance, and security of the database engine and its supporting services.
GitLab.com is the largest GitLab instance and presents unique challenges. The experience of our team feeds back into other engineering groups and our customers running self-managed installations.
Responsibilities Automate operational tasks across environments (e.g., package updates, configuration changes, provisioning of user-facing services).
Respond to platform emergencies, alerts, and escalations from Customer Support.
Minimize manual effort in managing software lifecycles (operating systems, etc.).
Develop a fully automated, multi-environment observability stack and extend it to predict capacity needs based on usage patterns.
Plan for new service roll-outs, capacity management, and work with users to optimize resource consumption.
As An SRE You Will Work on database reliability and performance for GitLab.com within the SRE team and in product collaborations.
Analyze solutions and implement best practices for PostgreSQL clusters and components.
Improve observability of database metrics and meet database objectives.
Collaborate with peer SREs to roll out changes and mitigate production incidents.
On-call support on rotation; provide database expertise to engineering teams (migrations, queries, performance).
Automate database infrastructure and build self-service tooling; use GitLab product to operate GitLab.com efficiently.
Plan growth of GitLab/'s database infrastructure and design/maintain core components to scale for hundreds of thousands of concurrent users.
Support and debug database production issues across services and stack levels; ensure monitoring and alerting target symptoms rather than outages.
Document actions for repeatability and automation.
Projects You Could Work On Database administration review (backups, performance tuning) and automation of replica setup and backups monitoring.
Build self-service tools for engineers using GitLab ChatOps; provide technical assistance on database design and tuning.
Review migrations and recommend query/schema changes for performance; participate in production incident mitigation.
Contribute to infrastructure design and scalability focusing on data storage; plan next steps to scale the database.
Define specifications for future database requirements including enhancements, upgrades, and capacity planning.
Qualifications / Requirements Experience running PostgreSQL in high-growth, large production environments, using self-managed (VM, Kubernetes with PostgreSQL Operators) and DBaaS services.
Hands-on experience using PostgreSQL internals data to design, build, and troubleshoot systems.
Experience with infrastructure automation, orchestration, and configuration management (Chef, Ansible, Puppet, Terraform).
Solid understanding of SQL and PL/pgSQL.
Significant experience in a large SaaS distributed systems production environment.
Strong written and verbal English communication skills; ability to collaborate asynchronously.
Documentation-focused mindset and ability to deliver quickly with iteration.
Proactive, go-for-it attitude and a desire to fix problems when you see them.
Strong data modeling and data structure design skills.
Bonus: programming skills (backend engineer), preferably Ruby and/or Go.
Bonus: experience with ClickHouse or other modern OLAP databases.
Senioriy level Associate
Employment type Full-time
Job function Engineering and Information Technology
GitLab is an equal opportunity employer. If you require accommodation during the recruiting process or have questions about location eligibility, contact our Talent Acquisition team.

#J-18808-Ljbffr