PageRenderTime 75ms CodeModel.GetById 32ms RepoModel.GetById 1ms app.codeStats 0ms

/sites/uncategorized/source/job-families/engineering/infrastructure/database-reliability-engineer/index.html.md

https://gitlab.com/syedahmedz1/www-gitlab-com
Markdown | 175 lines | 136 code | 39 blank | 0 comment | 0 complexity | d6369dbd857634713f3e2f48f760495a MD5 | raw file
  1. ---
  2. layout: job_family_page
  3. title: "Database Reliability Engineer"
  4. ---
  5. Database Reliability Engineers (DBRE) are responsible for keeping database systems that support all user-facing services (most notably GitLab.com) and many other GitLab production systems running smoothly 24/7/365. DBREs are a blend of database engineering and administration gearheads and software developers that apply sound engineering principles, operational discipline and mature software development and automation, specializing in databases (PostgreSQL in particular). In that capacity, DBREs are peers to SREs and bring database expertise to the SRE and SAE Infrastructure teams as well as our engineering teams.
  6. GitLab.com is a unique site and it brings unique challenges: its the biggest GitLab instance in existence; in fact, its one of the largest single-tenancy open-source SaaS sites on the internet. The experience of our team feeds back into other engineering groups within the company, as well as to GitLab customers running self-managed installations
  7. ## As a DBRE you will:
  8. * Work on database reliability and performance aspects for GitLab.com from within the SRE team as well as work on shipping solutions with the product.
  9. * Analyze solutions and implement best practices for our main PostgreSQL database cluster and its components.
  10. * Work on observability of relevant database metrics and make sure we reach our database objectives.
  11. * Work with peer SREs to roll out changes to our production environment and help mitigate database-related production incidents.
  12. * OnCall support on rotation with the team.
  13. * Provide database expertise to engineering teams (for example through reviews of database migrations, queries and performance optimizations).
  14. * Work on automation of database infrastructure and help engineering succeed by providing self-service tools.
  15. * Use the GitLab product to run GitLab.com as a first resort and improve the product as much as possible.
  16. * Plan the growth and manage the capacity of GitLab's database infrastructure.
  17. * Design, build and maintain core database infrastructure pieces that allow GitLab to scale to assist hundreds of thousands of concurrent users.
  18. * Support and debug database production issues across services and levels of the stack.
  19. * Make monitoring and alerting alert on symptoms and SLOs, and not on outages.
  20. * Document every action so your learnings turn into repeatable actions and then into automation.
  21. ## The GitLab Database Ecosystem
  22. The GitLab Database Ecosystem has the following areas of interest:
  23. 1. PostgreSQL Core
  24. 1. PostgreSQL High Availability and Load Balancing (e.g. Patroni, PGBouncer, consul, PostgreSQL Replication etc.)
  25. 1. PostgreSQL Disaster Recovery (backup/restore and other techniques)
  26. 1. Database Observability (Prometheus instrumentation, workload analysis etc.)
  27. 1. GitLab Rails application specifics on PostgreSQL
  28. ## You may be a fit to this role if you:
  29. * Have at least 5 years of experience running PostgreSQL in large production environments.
  30. * Have at least 2 years of experience with infrastructure automation and configuration management (Chef, Ansible, Puppet, Terraform...).
  31. * Have at least 3 years of experience with any object oriented programming language in a software engineering role.
  32. * Have experience with Ruby on Rails, Django, other Ruby and/or Python web frameworks, or Go.
  33. * Have strong programming skills.
  34. * Have solid knowledge of SQL and PL/pgSQL.
  35. * Have solid knowledge of the internals of PostgreSQL.
  36. * Have experience working in a distributed production environment.
  37. * Share our [values](/handbook/values/), and work in accordance with those values.
  38. * Have excellent written and verbal English communication skills.
  39. * Have an urge to collaborate and communicate asynchronously.
  40. * Have an urge to document all the things so you don't need to learn the same thing twice.
  41. * Have a proactive, go-for-it attitude. When you see something broken, you can't help but fix it.
  42. * Have an urge for delivering quickly and iterating fast.
  43. * Know your way around Linux and the Unix Shell.
  44. * Have the ability to orchestrate and automate complex administrative tasks. Knowledge in config management systems like Chef (the one we use).
  45. * Have a passion for stable and secure systems management practices.
  46. * Possess data modeling and data structure design skills.
  47. ## Projects you could work on:
  48. * Review, analyze and implement solutions regarding database administration (e.g., backups, performance tuning)
  49. * Work with Terraform, Chef and other tools to build mature automation (automatic setup new replicas or testing and monitoring of backups).
  50. * Implement self-service tools for our engineers using GitLab ChatOps.
  51. * Provide technical assistance and support to other teams on database and database-related application design methodologies, system resources, application tuning.
  52. * Review database related changes from engineering teams (e.g., database migrations).
  53. * Recommend query and schema changes to optimize the performance of database queries.
  54. * Jump on a production incident to mitigate database-related issues on GitLab.com.
  55. * Participate actively in the infrastructure design and scalability considerations focusing on data storage aspects.
  56. * Make sure we know how to take the next step to scale the database.
  57. * Design and develop specifications for future database requirements including enhancements, upgrades, and capacity planning; evaluate alternatives; and make appropriate recommendations.
  58. ## Leveling
  59. ### Database Reliability Engineer
  60. #### Job Grade
  61. The Database Reliability Engineer is a [grade 6](/handbook/total-rewards/compensation/compensation-calculator/#gitlab-job-grades).
  62. #### Responsibilities
  63. * Provides emergency response either by being on-call or by reacting to symptoms according to monitoring.
  64. * Delivers production solutions that scale, identifying automation points, and proposing ideas on how to improve efficiency.
  65. * Delivers projects, design solutions, identifying potential issues, tradeoffs and risks.
  66. * Improves documentation all around, either in application documentation, or in runbooks, explaining the why, not stopping with the what.
  67. * Improves the performance of the system by either making better use of resources, distributing load or reducing the latency.
  68. * Shares the learnings publicly, either by creating issues that provide context for anyone to understand it or by writing blog posts.
  69. * Deep knowledge of the 2 of the areas of expertise in PostgreSQL ecosystem.
  70. * Great expertise in SQL, able to review SQL statements and guide developers with best practices how to interact with the database,for a high-scale web environment.
  71. * Process oriented driven, iterating with the existent or creating new ones.
  72. * Apply elevated testing practices to ensure smooth releases and changes.
  73. * Good communications skills, collaborative and good working in group.
  74. ### Senior Database Reliability Engineer
  75. #### Job Grade
  76. The Senior Database Reliability Engineer is a [grade 7](/handbook/total-rewards/compensation/compensation-calculator/#gitlab-job-grades).
  77. #### Responsibilities
  78. * Lead and mentor DBREs by setting the example.
  79. * Identifies changes for the product architecture from the reliability, performance and availability perspective with a data driven approach focused on relational databases. Knowledge of another data storage is a plus.
  80. * Proactively work on the efficiency and capacity planning to set clear requirements and reduce the system resources usage to make GitLab cheaper to run for all our customers.
  81. * Perform and run blameless RCA's on incidents and outages, relentlessly looking for answers that will prevent the incident from ever happening again.
  82. * Show ownership of PostgreSQL ecosystem, great plus on ownership of major part of the infrastructure.
  83. * Deep knowledge in architectural overview, knowledge of engineering practices, ORMs, caching...
  84. * Identify parts of the system that do not scale, provide immediate palliative measures and drive long term resolution of these incidents.
  85. * Identify the SLO (Service Level Objectives) that will align the team to meet the availability and latency objectives.
  86. * Be constructive, strong initiatives, approach with solutions, think out of the box, able to switch focus or priorities as required.
  87. * Priority driven, focused on what matters, raises concerns, delivered focus.
  88. * Deep knowledge in 3 areas of expertise related to PostgreSQL and his ecosystem, considering another data storages an option, general knowledge of all areas of expertise from the PostgreSQL ecosystem, radiate that knowledge.
  89. * Leads and participates in several projects, having an overview and giving input on projects to be accomplished with the best performance and lower impact.
  90. ### Staff Database Reliability Engineer
  91. #### Job Grade
  92. The Staff Database Reliability Engineer is a [grade 8](/handbook/total-rewards/compensation/compensation-calculator/#gitlab-job-grades).
  93. Staff Database Reliability Engineer are Senior Database Reliability Engineers who additionally meet the following criteria:
  94. Technical:
  95. 1. Able to create innovative solutions that push GitLab's technical abilities ahead of the curve on the database ecosystem.
  96. 1. Deep knowledge of GitLab database ecosystem in expertise. Knowledge of each area of expertise enough to mentor and guide other team members in those areas.
  97. 1. Lead (with others) GitLab's database ecosystem architecture to improve reliability and add new relevant functionality.
  98. Execution:
  99. 1. Strive for automation either by coding or by leading and influencing developers, to build systems that run automatically (ideally) in production.
  100. 1. Weight the risks of new features ahead of time, planning and mitigating accordingly, improving the infrastructure.
  101. 1. Propose and drive architectural changes that affect the whole company to solve scaling and performance problems.
  102. 1. Lead the team with significant project work, for OKR level goals.
  103. Communication and Collaboration:
  104. 1. Work with engineers across the whole company influencing the database design to create features that will improve both our SaaS and self hosted platforms.
  105. 1. Communicate proficiently and consistently at a company level, sharing information that enables others and being vocal in group calls.
  106. 1. Run proficiently RCAs and epic-level planning meetings, to get meaningful work scheduled into the roadmap.
  107. Influence and Maturity:
  108. 1. Routinely has an impact on the broader Engineering organization
  109. 1. Write in-depth documentation that shares knowledge and radiates GitLab technical strengths. Participate actively and lead Gitlab technical/Business calls.
  110. 1. Have a high level of self awareness.
  111. 1. Help to develop other team members into senior levels and leaders in the team.
  112. 1. Collaborates closely with development groups and exerts influence on how GitLab (the application) interacts with the database
  113. ## Performance Indicators
  114. Database Reliability Engineers have the following job-family performance indicators:
  115. - [GitLab.com Availability](https://about.gitlab.com/handbook/engineering/infrastructure/performance-indicators/#gitlab-com-availability)
  116. - [GitLab.com Performance](https://about.gitlab.com/handbook/engineering/infrastructure/performance-indicators/#gitlab-com-performance)
  117. - [Apdex and Error SLO per Service](https://about.gitlab.com/handbook/engineering/infrastructure/performance-indicators/#apdex-and-error-slo-per-service)
  118. - [Mean Time to Detection](https://about.gitlab.com/handbook/engineering/infrastructure/performance-indicators/#mean-time-to-detection-mttd)
  119. - [Mean Time to Resolution](https://about.gitlab.com/handbook/engineering/infrastructure/performance-indicators/#mean-time-to-resolution-mttr)
  120. - [Mean Time Between Failure](https://about.gitlab.com/handbook/engineering/infrastructure/performance-indicators/#mean-time-between-failures-mtbf)
  121. - [Mean Time to Production](https://about.gitlab.com/handbook/engineering/infrastructure/performance-indicators/#mean-time-to-production-mttp)
  122. - [Disaster Recovery Time to Recovery](https://about.gitlab.com/handbook/engineering/infrastructure/performance-indicators/#disaster-recovery-dr-time-to-recover)
  123. ## Hiring Process
  124. Candidates for this position can expect the hiring process to follow the order below. Please keep in mind that candidates can be declined from the position at any stage of the process. To learn more about someone who may be conducting the interview, find their job title on our [team page](/company/team/).
  125. * Qualified candidates will be invited to a 30min [screening call](/handbook/hiring/#screening-call) with our Global Recruiters.
  126. * Next, candidates will move to the first round of interviews.
  127. * 60 Minute Technical Interview with a Senior DBRE.
  128. * Two 60 Minute Technical Interviews with a member of the Infrastructure Engineering team
  129. * 60 Minute Interview with the Hiring Manager.
  130. * Next, candidates will move to the second round of interviews.
  131. * 60 Minute Interview with a Senior Manager/Director of Infrastructure Engineering.
  132. * Successful candidates will subsequently be made an offer.
  133. As always, the interviews and screening call will be conducted via a video call.
  134. See more details about our hiring process on the [hiring handbook](/handbook/hiring/).
  135. ## Career Ladder
  136. For more details on the engineering career ladders, please review the [engineering career development](/handbook/engineering/career-development/#roles) handbook page.