Database Engineer 3

Vermont Information Processing is the country's leading provider of software solutions for the beverage industry. We craft the technology that assists in every part of a beverage's journey from its creator to your glass!  For over 50 years VIP's success has been driven by the relationships we've built with our beverage customers and partners. We work to solve their mission-critical problems, provide innovative solutions for their businesses and never stop reimagining ways that we can help them succeed.  

VIP's BizStride team is seeking an experienced Database Engineer to work on the creation of new, enterprise-level systems as well as the maintenance of existing infrastructure. We are looking for a motivated self-starter who enjoys collaboration and innovation. As a database engineer on the BizStride team you will work as a midway point between support and the development team. Some evening availability will be required.

Primary Responsibilities:

• Ensure database security, integrity, stability and system availability
• Tune database for optimum system performance and reliability.
• Ensure data integrity, data quality, and data consistency.
• Profile server resource usage and optimize as necessary
• Maintain database backup and recovery infrastructure
• Assist in monthly database server maintenance and upgrades
• Create, maintain and optimize complex SQL scripts and stored procedures
• Follow (and if necessary, refine) in-house coding standards
• Troubleshoot/bug-fix SQL scripts
• Support application development staff with database design and implementation
• Use database code repositories for change management
• Assist in compliance efforts to include reporting, auditing and implementation
• Effectively communicate and collaborate within and across teams.
• Collaborate on innovative database solutions.
• Mentor team members to improve overall database knowledge.

Requirements:

• BS / MS in Computer Science or related field
• Minimum of 6 years experience as a database engineer with increasing responsibility in designing, implementing, maintaining, and troubleshooting complex database systems in production environments.
• Experience with database performance tuning and optimization.
• Proven track record of successfully managing all stages of large-scale database projects.
• Minimum of 5+ years of solid relational database experience
• Minimum of 6+ years working with MS SQL ServerFamiliarity with programming languages (stored procedures, cursors, node/express )
• Ability to function well in a fast-paced, dynamic environment with competing priorities
• Ability to manage all the stages of database development
• Expertise in understanding and enhancing  complex database models
• In-depth knowledge of referential integrity constraints and indexing
• Strong communication skills, both written and verbal
• Knowledge of Snowflake and DB2 is a plus! 

Benefits Include:

• Health Insurance
• Vision and Dental Expense Reimbursement
• 401k and Profit Sharing
• Life and Disability Insurance
• Health Savings and Flexible Spending Accounts
• Paid Parental Leave
• On-site Child Care Center (VT)
• On-site Fitness Center (VT)
• On-site Health Clinic (VT) 
• Discounted Gym Memberships
• Combined Time Off and Floating Holidays
• Flex and Hybrid Schedules 

All full time job offers are contingent upon passing a pre-employment drug screening and background check.

VIP offers the unique opportunity to become a valued member of an industry-leading organization. We provide a great work environment and benefits that support a healthy work/life balance, as well as growth opportunities and a generous retirement plan that support a stable future. Consistently named one of the Best Places to Work in Vermont, our goal is to offer an atmosphere that you can look forward to being a part of every day.