Job Details

Email to Friend Save Back

SQL DBA

CHICAGO-60613, IL, US
03/03/2020

-

Required Skills

VMWare

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

Job Summary

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. 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.

Participates in project team meetings with business analysts, QA and development staff to determine requirements for database design.

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.

Ensures that prompt and proactive communication occurs to the appropriate internal and external resources regarding the database environments.

Develops database security guidelines. Establishes appropriate database access control levels. Enforces adherence of database security standards and guidelines from development teams, operational staff and end-users. 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.

Installs, upgrades and maintains database server and application tools that support the database
environment. 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 applicable job experience.

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.

Ability to work in a team environment. Excellent written and oral communication skills. Excellent problem
solving skills. Understanding of application development lifecycle and formal methodologies.
Understanding of process engineering. Understanding of 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 Office.

The following are preferred but not required: .NET Framework, Visual Studio, C#, VMWare; Microsoft Office 365, SharePoint.