5 - 7 years experience  •  e-Commerce

$110K - $120K
Posted on 10/10/17 by Amy Kilcoyne
Chicago, IL
5 - 7 years experience
$110K - $120K
Posted on 10/10/17 Amy Kilcoyne

Job Summary

This position is responsible for supporting and implementing all instances of MS SQL, new client implementations, upgrades to reporting per client specification, and general application changes including their rollouts to production. The successful candidate will possess a professional expertise in gathering application specifications from a variety of sources and successfully applying them to a production environment.  This is a great opportunity for a visionary SQL database administrator who enjoys variety in day to day activities and a good mix of application development and client interaction.

Primary Responsibilities

  • Enhance and modify SQL 2008, 2012 and 2014 production database tables, views, stored procedures and DTS and SSIS packages
  • Convey client application enhancement requests to programmer(s) and facilitate scheduled updates to production environments
  • Support all departments with requests related to SQL database, such as ad-hocreports, new database deployments, etc.
  • Maintains and monitors client data import/export processes
  • Develop new and improve existing stored procedures, Data Transformation Services, SSIS and MS SQL Server databases
  • Maintain and develop scripts in MS Visual Basic
  • Support and develop multiple SQL Server Databases and data replication subsystems
  • Maintain and monitor all redundancy and disaster recovery configurations for SQL systems including but not limited to data replication
  • Collaborate with application developers to support the development process
  • Ensure all developed SQL Server components function flawlessly in a production environment with stringent uptime standards
  • Each week review top 10 most resource-intensive queries and suggest ways to improve them
  • Implement, maintain and respond to critical job notifications on failure
  • Identify and troubleshoot issues and tune all SQL databases for maximum performance
  • Create and maintain up-to-date documentation of all SQL environments and processes associated with the database

Job Qualifications

  • In-depth understanding and experience with Data Transformation Services and SSIS packages
  • Minimum 5years experience with MS SQL Server Standard and Enterprise 2008 and SQL 2012; SQL 2014experience a plus
  • Proven experience deploying production quality MS SQL database, stored procedures, DTS and SSIS packages
  • Experiencesupporting a 24/7 environment
  • Experience with backup strategies, clustering, high-availability (AlwaysOn Availability Groups), replication and DR solutions for SQL a must
  • 5+ years of related experience, including functional requirements gathering
  • Previous SQL 2008 and 2012database design, administration and development experiencerequired
  • Strong T-SQL background for development of views, stored procedures and UDFs
  • Previous MS Access development experiences a plus
  • Hands-on experience with MySQL a plus
  • Understanding of ADO, DAO a plus
  • High level of enthusiasm for building and maintaining the business through the use of technology
  • Personal sense of urgency and proven business acumen
  • Open to new tasks and challenges
  • Excellent oral and written communication skills.
  • Bachelors degreerequired; preferably in Information Systems or Computer Science

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.