Database Engineer 2

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 Colchester, VT.

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 Match & Employer Contributions
• 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.