Job Details

Email to Friend Save Back

SQL Database Administrator

CHICAGO-60619, IL, US
09/30/2019

-

Required Skills

VMWare, XML

Company

Infinity Consulting Solutions, Inc

Experience

5 to 7 Year(s)

Job Description

Database Administrator

The Database Administrator will be a part of the team responsible for the operational support of project initiatives surrounding the firm's Database environments.

This position will play an integral role in the maintenance, support and enhancements of business critical applications.

Duties and Responsibilities

Monitor and maintain database security

Migrate databases between servers and various platforms

Review database object and create and maintain change controls

Analyze and resolve SQL Server faults

Investigate and resolve reported application issues, escalating issues as necessary to the application owners

Design, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systems

Document data flows, application specifications from a DB perspective and system procedures

Monitor relational databases to optimize performance, resource use, backup/recovery, and physical implementation

Implement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shipping

Implement, create reports and provide general support for SQL Server Reporting services

Support highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)

Provide 24x7 on-call support on a rotating basis

Flexible to work off-hours, as required

Education and/or Experience:

Required:

Bachelor's degree in Computer Science or a related field

A minimum of 5 years of experience with SQL 2012, SQL 2014 and SQL 2016

Strong knowledge of Windows 2012 and 2016

Strong knowledge of physical and VMWare SQL configuration from an infrastructure perspective

Strong understanding of security implementation

Experience with SQL Server performance management and tuning, including understanding of SQL execution plans

SQL Server Administration experience including:

Triggers

Stored Procedure Code Development and Standardization

Data Integration and Migration

Management Studio

SQL XML

Database Auditing and Controls

Proven troubleshooting abilities

Strong planning and analysis skills

Strong documentation skills

Preferred:

Ability to translate Logical Data Models into physical structures

Other Skills and Abilities:

The following will also be required of the successful candidate:

Strong organizational skills

Strong attention to detail

Good judgment

Strong interpersonal communication skills

Strong analytical and problem solving skills

Able to work harmoniously and effectively with others

Able to preserve confidentiality and exercise discretion

Able to work under pressure

Able to manage multiple projects with competing deadlines and priorities

A self-starter who desires to show ownership and commitment to the job

Proofreads accurately