Data Warehouse SQL Server DBA - Remote (Detroit, MI) - Georgia IT Inc.
Remote (Detroit, MI), MI
About the Job
Data Warehouse SQL Server DBA
Location: Remote (Detroit, MI)
Duration: Longterm
Rate: DOE
US Citizen, Green Card, TN, GC-EAD, and H4-EAD only No Third-party agencies corp to corp.
Job Responsibilities:
Skills and Experience Required:
Required:
Location: Remote (Detroit, MI)
Duration: Longterm
Rate: DOE
US Citizen, Green Card, TN, GC-EAD, and H4-EAD only No Third-party agencies corp to corp.
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 year managing a data warehouse or data lake database environment
- Knowledge of database administration tasks
- Ability to debug and troubleshoot problems
- 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
Source : Georgia IT Inc.