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 has an exciting opportunity available for an experienced Database Engineer 2 to join our collaborative team in Colchester, VT or Ottawa, ON. This position will work to ensure the security, integrity, and performance of our database systems. Are you a motivated self-starter with a passion for database engineering? We're looking for a skilled individual to contribute to the creation of new, enterprise-level systems as well as the maintenance of our existing infrastructure. Some on-call availability will be required.
Position Type: Full Time, hybrid. This position will report to our office headquarters in Ottawa, ON.
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
- Auditing database regularly to maintain quality
- 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 3 years experience as a database engineer with increasing responsibility in designing, implementing, maintaining, and troubleshooting complex database systems in production environments
- Minimum of 3+ years of solid relational database experience
- Minimum of 3+ years working with MS SQL Server Familiarity with programming languages
- Experience with database performance tuning and optimization
- Proven track record of successfully managing all stages of large-scale database projects
- 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 Employer Contributions & Match
- Life and Disability Insurance
- Health Savings and Flexible Spending Accounts
- Paid Parental Leave
- On-site Fitness Center
- 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.
