Job Details

Email to Friend Save Back

SQL DBA

CHICAGO-60604, IL, US
12/15/2016

-

Required Skills

T-SQL queries

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

SQL DBA

Seeking an experienced SQL DBA for an established and growing financial organization.

The SQL DBA will join a highly collaborative team and be in highly visible role.

The ideal SQL DBA candidate will have experience managing a mid to very large scale database environment and be comfortable working in a fast-paced environment.

Excellent communication skills are required.

Responsibilities:

Support and maintain all databases and servers for Microsoft and non-Microsoft database platforms.

Will own permissions, backups, sweeping BI-POOL desktops (i.e., manage static VDI image creation), and other front-line/routine duties.

Will act as the SQL point person for requests.

Ensure availability of existing SQL and other operational databases by designing highly available systems available from multiple data centers.

Centralize and condense the SQL environment to make the most effective use of resources.

Monitor, tune and manage scheduled tasks, backup jobs, recover processes, alerts, and database storage needs in line with firm change control procedures.

Perform fault diagnosis, troubleshoot and correct problems at the database and application performance level.

Work well in a team environment within the database administration team as well as with other Technical Service Group teams and other departments within the firm.

Provide regular reports on performance and stability of database environment, identifying coming needs proactively to ensure continued reliable service.

Document, develop, test and implement updates to database systems.

Requirements:

5+ years of experience in a SQL DBA role

Must have proven experience managing a mid to very large scale database environment

Experienced with SQL 2008 R2, 2012, 2014 and above RDMBS

Familiar with SSIS ETL development, SSRS and SSAS management and administration

Act as a problem solver

Able to write T-SQL queries

Subject matter expert on database design, performance issues, disaster recovery, backups and database maintenance

Team player and able to work independently in a fast-paced environment

Strong verbal and written communication skills