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