Current Openings

Data Warehouse SQL Server DBA

Detroit, MICHIGAN |
Post Date: 12/07/20
Job ID: 20-01132
Job Type:

Job Description

Job Responsibilities:

  • Work with our developers and business analysts to create and modify our database structure
  • Monitor the performance of the database servers
  • Perform database maintenance tasks, including backups/restores, updating statistics, rebuilding indexes, etc.
  • Work with our data engineers to help map data in our production databases to our data warehouse
  • Partner with application development teams to ensure optimal database operations
  • Maintain system security and data integrity
  • Work with our systems engineers to ensure optimal hardware and storage subsystems
  • Develop, manage and maintain a strong disaster recovery and high availability plan
  • Install, upgrade and patch the database servers
  • Participate in code and design reviews
  • Participate in production code pushes

Skills and Experience Required:

Required:

  • 3-5 years of experience working with Microsoft SQLServer 2012 and higher
  • 1 years managing a data warehouse or data lake database environment
  • Knowledge of database administration tasks
  • Ability to debug and troubleshoot problems

Desired:

  • Bachelor's degree in computer science or a related field or equivalent work experience 1 year of experience with SQL Server T-SQL coding
  • 1 year of programming experience (e.g., VBScript, Java, .Net, shell script)
  • Knowledge of SSIS and SSAS capabilities and usage
  • Proficiency in the Microsoft Office suite
  • Ability to understand large data models
  • Understanding of database design/architecture