Job Details

Email to Friend Save Back

SQL DBA

CHICAGO-60602, IL, US
10/16/2018

-

Required Skills

Microsoft Sequel Server 2014

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

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