Job Details

Email to Friend Save Back

SQL DBA

CHICAGO-60610, IL, US
09/25/2019

-

Required Skills

VMWare, Microsoft Office 365

Company

Infinity Consulting Solutions, Inc

Experience

5 to 7 Year(s)

Job Description

Job Summary

Position establishes, provides oversight, and insures optimum performance, reliability, recoverability, security and stability across all database environments.

Responsible for the design, development, installation, configuration, upgrade, administration, monitoring, security, and maintenance of on-premises and cloud database environments.

Identifies and mitigates risk to eliminate or minimize impact on the organization.

Provides continuous improvement analysis and action.

Develops rules and guidelines for the development of SQL objects.

Optimizes indexes and tables, creates and maintains database dictionaries and schema documentation, and designs and deploys data table structures, triggers, functions, stored procedures and views.

Creates queries and reports, fulfills data requests, resolves database access and performance issues, and administers SharePoint reports and permissions.

Manages and secures production and non-production reporting environment, participates in project team meetings with business analysts, QA and development staff to determine requirements for database design, and determines procedural changes and/or modifications to the database environments.

Provides system integration assistance through database design, works with the Infrastructure team on database issues that involve network, server, and cloud environment, and ensures prompt and proactive communication occurs to the appropriate internal and external resources regarding the database environments.

Develops database security guidelines, establishes database access control levels, enforces adherence of database security standards and guidelines from development teams, operational staff and end-users, and performs audits.

Develops and integrates replication, archiving, log shipping, high availability, and backup and recovery strategies.

Accountable for the IT Disaster Recovery database processes and procedures, participates in Disaster
Recovery testing, and installs, upgrades and maintains database server and application tools.

Evaluates and makes recommendations of new database products in accordance with the needs of the business.

Performs other duties as assigned.

Job Requirements

Bachelor's degree in computer science/information systems or related field with database administration experience; or an equivalent amount of training and experience is required.

Minimum seven years of progressive information technology experience.

Minimum five years on-premises database administration and architecture experience.

Minimum two years cloud database administration and architecture experience.

Minimum of one year experience in HA/AG implementation and administration. Ability to work in a team environment.

Excellent written and oral communication skills.

Excellent problem solving skills.

Understanding of application development lifecycle, formal methodologies, process engineering, and project management concepts.

Technical expertise must include Microsoft SQL Server 2008/2012/2014/2016/2017+; Microsoft Azure
SQL Database/Managed Instance; SQL Server Management Studio (SSMS), SQL Server Integration
Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS); Microsoft
Windows Server 2008/2012/2016/2019+; Microsoft SharePoint, Microsoft Office. Expertise with .NET
Framework, Visual Studio, C#, VMWare; Microsoft Office 365 preferred.