SQL Data Warehouse DBA
Carlin Shayn
Austin, United States of America
1 month ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Junior Compensation
$ 166KJob location
Remote
Austin, United States of America
Tech stack
Sql Data Warehouse
Databases
Data Dictionary
Data Integration
ETL
Data Mart
Data Warehousing
Database Security
IBM InfoSphere DataStage
Disaster Recovery
IBM Cognos Business Intelligence
Microsoft SQL Server
MicroStrategy
Oracle
Oracle Applications
Performance Tuning
Standard Sql
SQL Databases
SQL Server Reporting Services
Teradata
Oracle Hyperion
Database Optimization
Sap Business Objects
Database Migration
Star Schema
Data Management
Job description
- Database administration, maintenance, and performance tuning
- Data warehouse and data mart development/support
- Logical and physical data modeling
- Star Schema and Snowflake Schema design
- Database security, backup, recovery, and disaster recovery
- Database migrations and upgrades
- Data dictionary creation and maintenance
- ETL process support and data integration
- Reporting and analytics platform support
Requirements
Do you have experience in System tuning?, * 5+ years of Database Administration experience
- Strong SQL and Data Warehousing expertise
- Experience with SQL Server, Oracle, Teradata, or similar databases
- Experience with Informatica, DataStage, or other ETL tools
- Experience with Business Objects, Cognos, Hyperion, or MicroStrategy
- Strong performance tuning and database optimization experience
- Excellent analytical and communication skills
Preferred Skills:
- Oracle Database Administration
- SSRS Report Development
- M204 Database experience, * Database Administration: 6 years (Required)
- SQL and Data Warehousing: 1 year (Required)
- SQL Server, Oracle, Teradata, or similar databases: 1 year (Required)
- Informatica, DataStage, or other ETL tools: 1 year (Required)
- Business Objects, Cognos, Hyperion, or MicroStrategy: 1 year (Required)
Benefits & conditions
$75 - $80 an hour - Contract