SQL DBA Job at 1872 Consulting, Chicago, IL

YndPeDFET0Q5YWFHZVh0VERCZXBHSjA2Y1E9PQ==
  • 1872 Consulting
  • Chicago, IL

Job Description

Database Administrator

The Database Administrator will be a part of the team responsible for the operational support of project initiatives surrounding the company's Database environments. This position will play an integral role in the maintenance, support and enhancements of business-critical applications.

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
Requirements
  • Bachelor's degree in Computer Science or a related field
  • 5+ years of experience with SQL 2012, SQL 2014 and SQL 2016
  • 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 Experience
  • Ability to translate Logical Data Models into physical structures
  • Strong knowledge of Windows 2012 and 2016
  • Strong knowledge of physical and VMWare SQL configuration from an infrastructure perspective

Job Tags

Similar Jobs

FindTalent

Directional Drill Operator Job at FindTalent

 ...Job Description Job Description Directional Drill Operator Location: Southeastern and Mid-Atlantic Company Overview We are a leading utility construction company specializing in transmission, distribution, substation, and renewable energy projects.... 

K Con, LLC

CDL Driver Job at K Con, LLC

Job Description Job Description K Con is one of Washingtons fastest growing commercial and residential land development contractors. We are looking for an experienced Class A CDL Driver to operate our fleet on residential and commercial projects. We have projects ...

Carle Health

Certified Child Life Specialist (CCLS) - Methodist Job at Carle Health

 ...formal and informal teaching and in response to the learning needs of others. Performance Improvement- actively participates in data collection, analysis, problem-solving and gives input on process improvements and patient satisfaction. Works with interdisciplinary... 

ShalePro Energy Services

Roustabout Job at ShalePro Energy Services

 ...equipment to perform integrity management and regulatory tasks on oil or liquids pipelines Monitor activity in and around pipeline...  ...Respond to pipeline emergencies; perform cleanup associated with field ops and corrosion control activities . Qualifications The... 

iVenture Solutions

IT Help Desk Technician Job at iVenture Solutions

 ...Job Description Job Description Description Our Help Desk Technicians are the best of the best. Each day we have the privilege...  ...Bachelors Degree, business related field preferred, or equivalent experience Minimum of 1 year experience working in a 50+ user Windows...