Click here to login or register
Reference # : 18-03578 Title : SQL Server Developer
Location : Columbus, OH
Experience Level : Start Date : 07/12/2018  
Description
Job Title : SQL Server Developer
Location : Columbus, OH
Contract : Full Time Position
Responsibilities:
  • Work with the different database subsystems as required
  • 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
  • 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
  • Look for ways to leverage technologies to alleviate SQL dependencies (Elasticsearch, Redis, etc.)
  • Assist with data import and exports
Skills
  • At least 5 years' experience in T-SQL(queries, views, procedures)
  • Expert level T-SQL Optimization
  • Experience in SQL Server 2014 and above
  • Experience working with a very high traffic production SQL Server
  • Able to write and work with very complex stored procedures
  • Able to write dynamic SQL when necessary
  • 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
  • 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
  • Familiar with configuring services such as application and various database related services (SSIS,SSRS,SSAS,MS-SS services
  • MS SQL/SSIS/SSRS/SSAS Developer