Sr. Database Developer (OLTP)

Responsibilities

• Architecting solutions, designing databases and tables, writing effective T-SQL stored procedures, and optimizing existing structures and code to ensure our users have the best, fastest experience possible
• Advising, guiding, and providing input on a variety of business and technical challenges (we build and maintain complex algorithms that are heavily database driven)

Skills

• The ability to creatively solve problems and overcome unique challenges with minimal supervision or hand-holding
• Eagerness to write T-SQL code that will perform in a highly-transactional, 24/7/365 environment
• A good understanding of SQL Server internals (and why that’s important)
• Comfort with an agile, fast-paced environment
• Curiosity to better understand things like “how the optimizer works” and to learn the “why” that drives implementation choices
• The desire to maintain open, consistent communication with peers, business teams, and management
• BS in Computer Science (or equivalent experience)
• Design: create structures and code to solve complex problems in the best way
• T-SQL: create tables, indexes, stored procedures, functions from scratch
• SQL Server fundamentals: possess a strong grasp of how SQL Server works
• Performance tuning: use instrumentation and DMVs to troubleshoot and optimize
• Well-versed in high-volume, highly-transactional systems
• Working knowledge of DBA tasks (helps in design and performance tuning)
• Experience with version control and deploying changes to QA and production

Benefits

• 💼 Annual training budget for each employee
• 🌟 100% employer match on 401k contributions
• 💻 Specific COVID-19 allowance for home office set-up
• 🤝 Matched giving to qualified organizations
• 🍼 100% paid Parental Leave for up to 20 weeks
• 🎉 Happy Hours and Company events