Database Engineer

Volusion

(Austin, Texas)

Full Time

Job Posting Details

About Volusion

Volusion is a fully hosted, all-in-one shopping cart software trusted by over 40,000 merchants. The platform, designed for small and medium business owners, includes everything you need to succeed.

Summary

As a Database Engineer, you will assist in the development of data warehouse information architecture, optimize SQL performance, and provide operational support to our high availability Microsoft SQL Server Warehouse infrastructure. An ideal candidate will be an extremely proficient DBA specifically with experience in Data Warehousing concepts (ETL and Dimensional Modeling methodologies.)

Responsibilities

* Design, implement and maintain SQL Server infrastructure for Data Warehouse dimensional model database and supporting databases.
* Assist in the development SSIS package for ETL data load processes into the Data Warehouse database and supporting databases.
* Develop and Optimize SQL Queries leverage by ETL ,reporting processes and for data analysis.
* Responsible for designing and maintaining High Availability solution for SQL Server 2008/2012 Enterprise Edition on Windows Failover Clustering environments and SQL Server Availability Groups
* Backup and restore procedures for Warehouse databases using various strategies (log shipping, LightSpeed, etc.)
* Plan for non-transactional data storage for reporting and analytics
* Database Schema design and architecture planning
* Create SSRS Reports as needed.
* Profile source system data as needed to provide feedback for business requirements
* Analyze and verify Data Warehouse data.
* Assist in the design, build and maintenance of SSAS cubes.

Design, implement and maintain SQL Server infrastructure for Data Warehouse dimensional model database and supporting databases.
Assist in the development SSIS package for ETL data load processes into the Data Warehouse database and supporting databases.
Develop and Optimize SQL Queries leverage by ETL ,reporting processes and for data analysis.
Responsible for designing and maintaining High Availability solution for SQL Server 2008/2012 Enterprise Edition on Windows Failover Clustering environments and SQL Server Availability Groups
Backup and restore procedures for Warehouse databases using various strategies (log shipping, LightSpeed, etc.)
Plan for non-transactional data storage for reporting and analytics
Database Schema design and architecture planning
Create SSRS Reports as needed.
Profile source system data as needed to provide feedback for business requirements
Analyze and verify Data Warehouse data.
Assist in the design, build and maintenance of SSAS cubes.

Ideal Candidate

Bachelor’s degree in Computer Science or Engineering preferred or equivalent work experience.
2+ years of experience Microsoft SQL Server database administration
Strong experience with performance optimization and tuning with database applications is a MUST.
Scripting and .NET knowledge
Experience with ETL (SSIS) and Data Warehousing (SSAS)
Highly organized, self-starter with an eye for detail who can maintain multiple ongoing projects simultaneously
Must be a team player with excellent oral and written communication skills