Dice - The career hub for tech™
  • Post Jobs

More Jobs Like This

ETL Developer - SSIS Assurity Staffing Group - Chicago, IL US
SQL Application Support Addison Group - Libertyville, IL US
SQL Server DBA DivIHN Integration Inc. - Chicago, IL US
DevOps DBA (SQL Server) DivIHN Integration Inc. - Chicago, IL US
Sr. ASP.NET/MVC Software Developer Solution Partners, Inc. - Chicago, IL US

Dice Instant Referrals

Powered by Facebook

Who you know gets you noticed

You can add Facebook friends as Instant Referrals to your application.

Senior SQL Developer

Location:
Chicago, IL 
Area Code:
312 
Telecommute:
no 
Travel Required:
none 
Skills:
SSIS SQL T-SQL stored procedures server SSRS SSAS ETL extract transfer load code reviews database administration 
Pay Rate:
115000 
Tax Term:
FULLTIME CON_CORP 
Length:
Fulltime 
Date Posted:
10-24-2014 
Position ID:
027583 
Dice ID:
10143403 

Senior SQL Developer

Start up in downtown Chicago with a fun interactive environment is looking for a Senior Senior SQL developer to execute on T-SQL development for our service oriented architecture persistence layer. The Senior SQL developer will lead a small team and also be required to contribute to the larger Database needs including production support

Responsibilities

Provide technical leadership and hands-on database administration supporting the application development team throughout the lifecycle of assigned projects
Define and implement company’s database strategy by analyzing the database requirements of the supported business systems and designing a database infrastructure to support the business objectives
Collaborate with software engineers on code reviews, data access contracts, and DAL implementation
Participate in data-warehousing design, development and implementation efforts
Develop and maintain advanced T-SQL code and ETL scripts
Develop and evolve the logical and physical database design

Requirements

3+ years of database development with a primary focus on MS SQL Server and experience with large database deployments
2+ years of database administration
Experience with high transaction volume in a fast-paced, production environment
Excellent problem-solving skills
Self-starting attitude and good communication skills are essential. Ability to communicate with business and technology teams to translate complex business requirements into a manageable database schema
Ability to write complex T-SQL code (stored procedures, in-line TVSs, CTEs, XML shredding) while avoiding deadlocks and other performance and consistency issues
Deep understanding of SQL lock escalation and isolation levels
Must be able to work in a team-oriented environment and as a member of the production support team
Experience Maintaining high-availability systems (7x24x365) in an E-commerce environment
Experience with Backup & Recovery, Security, Performance monitoring and tuning
Experience with SQL Server Log Shipping, Replication and Clustering
Experience with physical database design for SQL Server 2008/2008 R2/2012
Experience with SSIS
Experience with C#
Experience with Entity Framework
Experience with Visual Studio 2012 Database Projects
Experience with distributed cache technology desirable
Experience with SQL Server Encryption Hierarchy desirable
Experience with SSRS desirable
Experience with SSAS desirable
Experience with Perforce desirable
Bachelors Degree in Computer Science or equivalent experience

Infinity Consulting Solutions