Database Reliability Engineer, SQL Server
Job Description
Posted 2 days ago
SeatGeek is a product-centric organization that deploys code into production multiple times per day. As we grow, the scale of our infrastructure and operating environment will continue to increase.
As a Database Reliability Engineer, you'll improve the SeatGeek Enterprise database technology ecosystem, database efficiency, and oversee SeatGeek's production database systems.
SeatGeeks database layer supports millions of transactions on a weekly basis, which means efficient, well-tuned systems have to be the default when it comes to deploying new queries, evaluating indexes and managing our SQL Server platform.
The Database Reliability team is the backbone that supports SeatGeek Enterprise as we continue to grow our primary ticketing platform and support clients such as the Dallas Cowboys, Brooklyn Nets, and Manchester City FC.
What you'll do
- Develop and refine processes to review overall database system performance across all SeatGeek Enterprise clients
- Assist in performance testing with our team of SREs
- Plan for future growth capacity
- Participate in on-call / incident management schedule
- Assist with continued client migrations from legacy data centers to AWS
- Partner with the Enterprise engineering organization to help support them in getting the most out of our database systems
- Train and collaborate with other departments on how to run production database systems and write effective queries
Who you are
You love database and query design but have an even greater love for efficiency and tuning. You make decisions based on data and are not afraid of experimenting to get the information you need.
You also have the following :
- Passion for craftsmanship and product. You have well-considered opinions about how reliable database systems should work, and hold yourself and your code to a high standard
- SQL Server experience, primarily 2016 and 2019, including high availability and DR solutions
- AWS experience, including RDS and general experience with VMs, containers, and serverless compute platforms
- Experience with operating systems (primarily Windows 2019), configuration management, and Infrastructure as Code
- Scripting in Powershell, T-SQL or other interpreted languages such as Python and Ruby
- Familiarity with configuration management systems such as Chef, Ansible, Puppet, Salt
- Familiarity with continuous integration, delivery, testing, and code deployment (using tools such as Gitlab CI and Jenkins)
- Experience with extracting useful telemetry data to address issues and forecast future growth using tools like Datadog
- A focus on improving system architecture, diagnosing shortcomings and implementing recommendations based on analyzed evidence
Perks
- Equity stake
- Flexible work environment, allowing you to work as many days a week in the office as youd like or 100% remotely
- A WFH stipend to support your home office setup
- Flexible PTO
- Up to 16 weeks of paid family leave
- 401(k) matching program
- Health, vision, dental, and life insurance
- Annual subscriptions to Headspace, Ginger.io, and One Medical
- $120 a month to spend on tickets to live events
- Annual subscription to Spotify, Apple Music, or Amazon music
- SeatGeek is committed to providing equal employment opportunities to all employees and applicants for employment regardless of race, color, religion, creed, age, national origin or ancestry, ethnicity, sex, sexual orientation, gender identity or expression, disability, military or veteran status, or any other category protected by federal, state, or local law.
As an equal opportunities employer, we recognize that diversity is a positive attribute and we welcome the differences and benefits that a diverse culture brings. Come join us!*
New York, NY, US Location The largest community on the web to find and list jobs that aren't restricted by commutes or a specific location.