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)
Requirements 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 The ability to creatively solve problems and overcome unique challenges with minimal supervision or hand-holding 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
Preferred Skills: 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
