Database Administrator (1 Year Contract)

Sunwing Travel Group is the largest vertically integrated travel group in North America and during this unprecedented time, we are continuing to search for top talent. We are looking for candidates who are EPIC (entrepreneurial, passionate, innovative and customer-centric) to join our team and help deliver our purpose “passionate people making vacation dreams come true”.

We want to continue to do our part to help end this pandemic, protect our employees and those vacationing with us, and to support the travel industry’s full recovery. Sunwing requires full vaccination against COVID-19 for our new and existing employees. We will make accommodations for qualifying medical or religious exemptions.

To learn more about our vaccination policy, follow this link: https://bit.ly/2X4TOOk
Also, learn more about our Safe with Sunwing commitment and how Sunwing is keeping its employees and customers safe here: https://bit.ly/3ngVrne

About You:

As the Database Administrator, you are responsible for the installation, configuration, upgrade, administration, monitoring, maintenance and security of the databases installed at Sunwing Travel Group. The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements as well as plan, coordinate and implement security measures to safeguard the databases.

What You’ll Do:

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Assist in migration of on premises SQL Server instances to Azure IaaS and Azure PaaS solutions.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end, including after-hours and weekends
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Upgrade MS SQL Server environment to the latest versions and patches
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Design and write complex SQL Server scripts to automate database management tasks where possible
• Provide after hours On Call Support as required as you will be the person the company would call if the SQL Server service stopped working.
• Design indexes for existing applications, choosing when to add or remove indexes

What You’ll Need:

• Degree in Computer Science, Computer Engineering or 5 years of equivalent experience in the Administration of Databases on premises and in Azure.
• 5 years or more experience in Tuning T-SQL queries to improve performance, MS SQL Server Installation and Configuration for Stand-Alone and clustered instances, writing SSIS Packages, Working with Windows Server (all versions) including Active Directory, Partitioning, Disk Configuration and Architecture, SQL Server Backup and Restore concepts and with SQL Server tools
• Good understanding of Data Modeling, RDBMS Concepts, Data Warehouse Concepts
• Experience with and/or good understanding of Azure Analysis Services, Azure Data Factory and Azure Synapse

What You’ll Be A Part Of:

• Remote and Hybrid Work Opportunities
• Grow your career with challenging and rewarding work that makes a difference
• Opportunity to give back through our social responsibility initiatives
• Work with a fun, passionate, travel-loving team!
• Great travel perks!
• Free Parking
• Open concept, collaborative workspace
• See for yourself! @sunwinglife

We thank all who apply however only those who meet the qualifications will be contacted.

At Sunwing, diversity is important to us, follow this link: https://bit.ly/3DYzBel to learn about how Diversity and Inclusion has always been, and continues to be, a top priority for us. We are proud that our workforce is made up of passionate people from all experiences and backgrounds. We are also committed to employment equity and to fostering an inclusive, accessible environment. We welcome applications from everyone. We will accommodate all applicants throughout the hiring process. If you are an individual who requires accommodation to apply to this position, please email mmarcus@sunwing.ca or call 416 859 2973.