Database Engineer 2 at VIP (Vermont Information Processing)

Vermont Information Processing (VIP), a leading provider of software solutions for the beverage industry, is seeking a Database Engineer 2. The Database Engineer 2 will be responsible for ensuring the security, integrity, and performance of database systems.

The Database Engineer 2 will report to the office headquarters. This is a full-time, hybrid position. VIP offers a great work environment and benefits that support a healthy work/life balance, as well as growth opportunities and a generous retirement plan.

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!

VIP offers:

• 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