Database Engineer

  • Engineering
  • Chicago, United States

Database Engineer

Job description

MAX Digital is looking for a Database Engineer. The position will focus on design and implementation of the database tier and background processing of an analytical web application built with a Microsoft SQL2008R2 Enterprise backend.  We utilize the entire SQL2K8R2 technology stack, including Analysis Services for OLAP, SSIS for ETL and data integration, and Reporting Services for building reports. The successful candidate will be a member of the database operations team responsible for ongoing operations of the database tier, administration, and development in concert with the application engineering team. As a member of a small team delivering SaaS to thousands of clients in a 24x7 operational environment, the successful candidate will share production support responsibilities with the rest of the Database Operations team. If mutually desired, this role has the potentially evolve to that of an administrator.


The ideal candidate is an engineer with a solid computer science foundation, an analytical mind with good communications and problem solving skills, and 3-5 years of professional experience.  In addition, a background in relational database modeling and experience building high performance database-intensive transactional applications is required. The candidate must be able to analyze SQL queries for performance bottlenecks and optimize queries with a structured approach.  Specific experience on the SQL2K8R2 platform is required. Familiarity with OLAP and data warehousing concepts and OLAP modeling is a plus, but not a strict requirement for this position.

Requirements

Requirements        

  • Experience building the database-tier of SaaS web applications (J2EE or C#)

  • Strong grounding in relational database concepts and data modeling on the SQL Server 2008R2 platform.

  • .Net Programming experience (C#)

  • Experience with various SDLC methodologies

  • SQL query execution fundamentals and query optimization principles

  • Data integration and ETL experience

  • Experience deploying database entities via script from code-versioning systems

  • Undergraduate degree or higher in Computer Science

  • Minimum 3 years of experience building database applications, 3-5 years of total experience.

  • Good communication skills and ability to communicate design intent outside code

  • Good estimation skills, the ability to meet tight deadlines, and to work in a fast-paced environment

Nice To Haves

  • Experience working with cloud-based services

  • Experience with recent versions of SQL Server ( 2016, 2017+)

  • Experience working with web services

  • Exposure to SSIS required

  • Analytical schema design and OLAP; experience with Analysis Services