IT - Database Administrator SmartPak
When most people say "work hard, play hard," they don't mean at the same time. But we're not most people. We're a little more awesome than that, and we're willing to bet that you are too.
At SmartPak, we're serious about supporting healthy horses and happy riders, but we're also serious about having fun. Our serious side has earned us several major awards for growth and innovation, while our "seriously playful" side landed us a spot on the Boston Globe's Top 100 Places to Work list and a "Best Bosses" award by Fortune Small Business and Winning Workplaces.
But enough about us ? let's talk about you! Are you confident, capable, creative and passionate? Do you want to know that your work makes a difference? Does a hard-working, collaborative, fast-paced environment sound exciting? If so, the Database Administrator position may be for you!
This position will be responsible for executing database administrative and development tasks to monitor, tune, optimize and secure enterprise data stores. Will also be the primary business intelligence developer, writing queries and reports, enhancing our data warehouse and additionally develop solutions to facilitate data exchange with our partners and vendors.
Responsible for executing database monitoring, optimization and security tasks identified by IT Manager, Software Architect and CIO
Work with end users and IT Manager to define data structures, ETL scripts and queries in support of data warehouse
Support end users in understanding and use of reporting technologies; Reporting Services, Analysis Services, Excel, Powerpivot, Proclarity, and others
Will be heavily involved in production support and troubleshooting
Will work closely with development team on database aspects of projects
Work with end users to define, deliver and validate queries and reports using SSRS
Manage and automate the import and export of various data feeds between systems and between SmartPak and external vendors
Other exciting projects as they arise!
Position must have?s:
Completed Bachelor?s degree
2-5 years of experience as a Database Administrator or similar position
Experience with SQL Server 2005/2008/2012 administration
Solid T-SQL/stored procedure skills. Ability to tune queries
Solid Entity Relationship Modeling skills
Experience writing reports with Sql Server Reporting Services or other reporting tool
Experience writing SSIS packages and ETL
Experience with Sql Server Replication
Familiarity with Data warehousing concepts and technologies. Experience with Analysis Services, ProClarity or other OLAP tools a plus
Knowledge of RedGateSql tools also a plus
Sense of humor!
||40 Grissom Road |
Plymouth, MA 02360