• TechStyle Fashion Group
  • $31,160.00 -49,530.00/year*
  • Santa Cruz , CA
  • Information Technology
  • Full-Time
  • 24 River St S


Loading some great jobs for you...




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.

Responsibilities:

? 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

Qualifications:

? 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)

Associated topics: .net, architect, backend, c#, develop, expert, java, matlab, perl, software engineer lead
Associated topics: application developer, architect, c, c#, matlab, maven, programming, project architect, senior software developer, software architect

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...