W e are looking for a forward-thinking, passionate Sr. SQL Server Developer to play a vital role in our Database Workflow team. The ideal candidate will be an expert at TSQL and be able to work in our 24/7 high throughput environment to assist in development, optimization, and rewrites of existing data workflow applications.
This position will report to the Sr. Director, IT Ops.
? Work with the different database subsystems as required (cart, membership, product, billing, inventory) ? Manage product catalog and exports to Elasticsearch ? Assist other teams with job based SQL development ? Communicate regularly with technical, applications and operational staff to develop new tools and systems to support the growth of the business ? Develop queries, stored procedures, views, triggers, and other database objects to support internally hosted applications? ? Optimize/restructure our inventory management to prevent oversales and undersales ? Monitor and fix system issues (blocking, deadlocks, bad plans) ? Perform code pushes ? Work with ITOps/DBOps to help troubleshoot n-tier system issues ? Assist with migration of SQL Server 2008 to SQL Server 2016 ? Be available 24/7 when needed to ensure system health ? Look for ways to leverage technologies to alleviate SQL dependencies (Elasticsearch, redis, etc.) ? Increase our operational intelligence by providing endpoints for KPI monitoring ? Recommend, test, and prototype new version control methods ? Assist with data import and exports ? Review code from the development team and provide expert assistance when needed ? Assist with archiving large tables and perform int to bigint conversions online
? Experience in SQL Server 2014 and above ? At least 8 years experience in T-SQL ? Experience working with a very high traffic production SQL Server ? Able to write and work with very complex stored procedures ? Expert level T-SQL Optimization ? 24x7 Production support experience supporting a high throughput Database ? Understanding of SSIS ? Familiar with JSON data structures ? Strong knowledge of SQL Server DMVs ? In depth understanding of execution plans ? Able to write dynamic SQL when necessary ? Expert in when to apply different levels of normalization and demoralization ? Experience working with a multi TB database ? Skilled in transferring data quickly between platforms by performing efficient delta refreshes ? Strong understanding of the internals of SQL Server ? Previous experience in performing code changes for SQL compatibility upgrades ? Able to apply code and apply TSQL changes in an online fashion without blocking traffic ? Possesses an strong understanding of operations that block traffic ? Experience in performing online archiving of tables over 100GB ? Able to code SSIS ? Ability to create data workflows and jobs ? Good knowledge of N-tier architectures and troubleshooting ? Experience pushing code and giving code feedback to developers ? Ability to carry projects and be autonomous ? Self starter who can work independently and remotely if needed ? Technically proficient in more than one language and platform a plus ? Knowledge of Elasticsearch a plus ? Knowledge of JSON data structures a plus ? Familiar with AWS offerings a plus TechStyle is an Equal Opportunity Employer: M/F/PV/D (minority, female, protected veteran, disability)