Ref No.: 18-03228
Location: Chicago, Illinois
Position Type:Full Time
Pay Rate : $ 85,000.00 - 100,000.00 /Year
Small growing Financial Services company needs to expand the IT group by adding an MS SQL DBA. Reporting to the CIO, this candidate will assist in maintaining the internal databases for efficiency, performance, create ad-hoc reports and anticipate growth.

Key Position Responsibilities:
  • Writing database documentation regarding data standards, procedures and data dictionary
  • Work with developers on database design to ensure high performance and scalability
  • Capacity Planning
  • Responsible for ensuring adherence of all deliverables to appropriate standards & quality levels
  • Maintain knowledge of best practices surrounding IT technology, processes & database / support

Non Technical Requirements:
  • 5+ years of Microsoft DBA experience required
  • Experience working in smaller teams within a growing environment
  • Proven ability to independently manage tasks and priorities, accurately estimate work, and meet deadlines

Technical Requirements:
  • Prior experience with backup strategies, clustering, log shipping, and DR testing
  • Prior experience in performing software/patch updates to database server
  • Hands on experience creating, modifying, and analyzing SQL and T-SQL statements
  • Proven knowledge of Stored Procedures, Tables, Views, Indexes, Keys
  • Understanding of database performance bottlenecks and ability to track them down. Use of Execution Plans and Optimizer is a must.
  • Use of Visual Studio to create SSRS reports
  • Hands On experience with Microsoft Sequel Server 2014
  • Proven experience using MS SQL Server database design & T-SQL, with ability to write stored procedures, user defined functions & SQL queries
  • Building of cubes and use of MDX is an added plus, but not required

Pluses:
  • Experience with MS SQL Server SSIS, SSRS, and SSAS
  • Use of performance tools such as Idera and AppDynamics